
We have a production order that when we run the Inventory Valuation - WIP report, has a large negative output number:
I looked into the transactions and found where in the GL entries, the values that make up the -80k are entered and are related to Output value entries with those amounts as Expected Costs.
When I run the Prod order statistics, the Expected Cost isn't anywhere near the amounts in the above items. Is there something I am missing? Is the Expected costs postings correct? I am not sure exactly what triggered those postings. Any insight is appreciated.
Expected Costs in the GL are not the same as Expected costs in Production Order Statistics. Production Order Statistics expected cost is the system calculating material from components and capacity from work centers (in your case). The idea is to compare the expect material and capacity from BOM and routing to Actual from consumption and output. In the general ledger expected cost contains from: purchase orders-received not invoiced and from production orders-output not finished.
It looks like you have not changed the status of your production order to Finished, doing so will move costs from WIP to finished goods.