How do I force my inventory to use the (most recent cost) for shipped items. Client has some catching up to do to normalize their inventory before either (moving average and or LIFO) can be used.

Having a hard time explaining why COGS is credited and Inventory Debited, when it should be the reverse as well as (unknown ghost figures)from a shipment batch, even though when they were invoicing the most recent cost was correct.

From my investigation all of this is due to items with a (negative total cost) averaged based on QTY sold. Control Account Set is Moving Average.


Right now the Ledger is completely incorrect.
Will have to work some magic on items already posted - reverse then write a report to compute what it should have been but I need help going forward.

How do I force the system to use ((Most Recent Cost)), I am aware of the accounting implications ?

Thanks