We are FIFO, Average Costed on NAV 2015.
We have Finished RPOs that have left value in WIP. We have run the adjusted cost and that doesn't seem to correct the problem. It seems to occur when someone consumes an item on the RPO at XX value. Then later the item is negative consumed at a different value. So the quantity is now zero but there is value (negative or positive) left on the RPO. Since the item is no longer consumed, the value doesn't get put into the output. Below is an example. We cannot find a way to clear these out after the RPO is finished. We really need to be able to clear this. Does anyone know of a way?
Posting Date | Item Ledger Entry Type | Entry Type | Adjustment | Document No. | Item No. | Cost Amount (Actual) | Cost Posted to G/L | Item Ledger Entry Quantity |
4/12/2018 | Consumption | Direct Cost | FALSE | RPO117491 | 400-10499-00 | -26,947.77 | -26,947.77 | -4. |
4/19/2018 | Consumption | Direct Cost | FALSE | RPO117491 | 400-10499-00 | 24,279.26 | 24,279.26 | 4. |
This RPO finished with a credit in WIP of $2,668.51.
Thanks in advance for any help.
Nicole Ward
Cost Accountant
*This post is locked for comments