Items Display Zero Quantity with a Remaining Value on the Valuation Report in Sage 100
Description
Items display zero quantity with a remaining value on the valuation report. There is no remaining negative tier for the FIFO item in Sage 100.
Resolution
An inventory adjustment was made and the cost on the transaction was overridden, usually with a zero cost. This transaction can be seen on the Inventory Detail Transaction Report for the period when it was posted.
Two adjustments are required to address this.
- First enter a positive adjustment to match the errant entry, and override the cost to match as well; for example, if the overridden cost was zero, enter zero.
- Post the Adjustment
- Then enter a negative quantity adjustment and select the open positive tier with the remaining cost.
- Post the second adjustment to bring the quantity back to zero and relieve the outstanding cost tier.
Additional Information
Example:
Inventory Valuation Report: Qty=0, Value = -$72,123
Inventory Transaction Entry, Adjustment Qty 1, Distribute, Override Unit Cost at $72,123(reverse of the negative or positive amount so the result will be 1 on hand at $0)
Inventory Transaction Entry, Adjustment Qty -1, Distribute, Unit Cost at $0
Support
If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.