How to Avoid Sale Item Stock Errors

Tyms

Updated 2 days ago by Tyms

When you save a transaction as a Draft in Tyms, it does not affect your financial reports and can still be edited. Once you Publish it, the transaction is posted to your books and immediately reflects in your reports. Some users encounter an error after publishing sales invoices or receipts for inventory items. The error usually states:

Validation errors

  • The following items exceed current stock: "Laptop". Please reduce the quantities or restock to continue.

                                                                    Or 

  • Cannot record sales for the following items: "Laptop". Stock on this date is insufficient. Please pass an inventory adjustment on or before 01 Apr 2025 to proceed.

This happens because Tyms uses a Perpetual Inventory System with FIFO (First-In, First-Out) valuation. Inventory quantities must accurately match the transaction date for proper tracking.

Why This Error Occurs

1. Backdated Sale Before Item Quantity Creation

If you backdate a sale to a date before the inventory item was created, Tyms cannot recognize the stock.

Example:

  • Item created: April 1, 2025

  • Sale backdated to: March 2025

2. Insufficient Stock as of the Sale Date

Stock must be available on the exact date of the sale, even if you restock later.

Backdating a sale does not retroactively add stock.

Important: You cannot backdate restocks, this follows standard accounting principles.

Example:

  • Stock fully depleted by April 30, 2025

  • Restock occurs on April 30, 2025

  • Sale backdated to April 28, 2025

  • Result: Cannot record sales for the following items: Laptop. Stock on this date is insufficient. Please pass an inventory adjustment on or before 28 Apr 2025 to proceed.

3. Recording Quantities Greater Than Available Inventory

When the quantity entered on a sales transaction is higher than the stock available in inventory as of the transaction date.

Tyms validates stock levels strictly to prevent negative inventory and inaccurate financial reporting.

Example 1:

  • Available stock on May 10, 2025: 5 units

  • Quantity entered on invoice: 8 units

  • Result: The following items exceed current stock: Laptop Please reduce the quantities or restock to continue.

Example 2 (Backdated Sale):

  • Available stock on April 15, 2025: 3 units

  • Stock restocked on April 20, 2025: +10 units

  • Sale backdated to April 15, 2025 for 6 units

  • Result: The following items exceed current stock: Laptop. Please reduce the quantities or restock to continue.

4. Publishing Transactions Out of Chronological Order

Sales transactions must be published in date order (oldest first).

Publishing a future dated transaction before an earlier one creates a conflict.

5. Deleting Restock Records

Deleting restock entries reduces available stock. If the remaining quantity no longer covers previous sales, those sales will revert to Draft.

How to Fix It

  • Always confirm that sufficient stock exists as of the exact sale date.

  • Remember: Restocking today will not fix past stock shortages, use an inventory adjustment for past periods if required.

  • Publish transactions in chronological order (oldest to newest). Example: If you have 10 draft sales between June 29 to July 3, 2025, publish starting with June 29 and work forward until July 3.

  • Avoid deleting restock records unless absolutely necessary.

  • Review the impact of inventory adjustments that reduce historical quantities before saving.

Still Need Help?

If the issue persists after following this guide, please contact support  contact@tyms.io  or use the in-app chat to speak with a team member.



Making accounting easy and affordable for every business.

Discover how Tyms transforms complex accounting into a seamless experience for businesses: Our cutting-edge automation takes the hassle out of financial management, simplifying repetitive tasks and empowering businesses with effortless precision.

ISO Certified
AICPA Certified