Inventory unit cost and/or on-hand quantity are incorrect

In Sage 50 Accounting the inventory quantity on hand, the unit cost, or both, are incorrect.

Adjust quantity

1. Select Tasks, and then select Inventory Adjustments.
2. Select the needed Item ID.
3. If desired, enter a Reference number.
4. Enter effective Date.
   • If also adjusting unit cost, select the date one day before the effective date. (For example, if the cost is changing 5/15/25, select 5/14/25.)

   If desired, enter the Job ID.

5. Enter the amount to Adjust quantity by, as a positive number to raise, or negative to lower.
   • If also adjusting unit cost, the quantity on-hand must be reduced to zero. (For example, if the current quantity is 5, adjust it by -5.) The correct quantity will be re-entered in the next section.

8. Enter Reason to adjust.
9. Click Save.
   • If only adjusting quantity, repeat these steps as necessary, and then close Inventory Adjustments
   • If also adjusting unit cost, don’t close the window, and proceed to the next section

Adjust cost

1. Select Item ID.
2. If desired, enter the Reference number.
3. Enter effective Date.
4. If desired, enter the Job ID.
5. Enter the new Unit cost.
6. Enter the amount to Adjust quantity by, to restore the quantity to the correct level.
7. If desired, enter Reason to adjust.
8. Click Save.
9. Close Inventory Adjustments.
10. Verify the cost and quantity is correct, if not proceed to the next section.

Run Integrity Check

Run the Inventory/Journal synchronization test.