Negative Quantity Adjustments

 

Expand/Collapse all Show/Hide All

When an inventory item is sold, the cost is calculated in different ways depending on the valuation method assigned to the item. Negative quantity adjustments are only posted for items using the Average Cost valuation method. When an Average Cost item is sold, the system looks at the average cost of all items on hand in the selling warehouse and uses that amount as the average cost of the sale. If a transaction is created that sells more of the item than is on hand, the system estimates that these pre-sold items will have the same cost as the rest of the stock on hand.

Later, when a receipt is processed, the receipt's cost is compared to the cost that was used in the pre-sales phase. If the two costs do not match, an adjustment is needed to correct the postings made at the estimated cost. The adjustments are made to the general ledger Inventory account, and offset against an adjustment account. A transaction is also posted to the inventory transaction detail table. This posting is noted with a transaction type of IZ. There are no quantities or prices associated with this transaction, only the total adjustment amount. The purpose is to make sure the value posted to inventory matches the amount posted if the receipt was created first.

Expand/Collapse item  Example 1

 

Expand/Collapse item  Example 2

 

Expand/Collapse item  Example 3

For more information, see Item Maintenance.