I’ve posted this in the Technical Forum section by mistake. Should have been posted here!
We are running MBS - Nav 4.0 SP1. We have expected and automatic cost posting enabled. We use FIFO and we verified, by comparing the Inventory Valuation report with Inventory To G/L Reconcile report that everything is setup correctly. From time to time we have to send out material that has been received into inventory, and has been invoiced on the vendor side, to third party vendors for additional upgrades or repairs. We do this via a $0.00 VRMA, as we are tracking our material via serial numbers, and bring the material back in via moving the negative lines on the VRMA to a PO. When we bring tha material back in we bring it, as we did when we shipped it, at $0.00 cost in. The problem we are having is that the expected cost is being consumed and posted to the G/L, which taints our Income Statement as some of the material may not ship the same month.
The question we are having is whether or not the following accounts should be included on the account schedule for an income statement:
Inventory Interim Accrual
COGS - Interim Accrual
Inventory Adjustment Interim Accrual
Currently, because of the expected cost posting, our bottom line is way off because the expected costs moved all the way through, but the material is not being sold for another 2 - 3 month, potentially. Our fiscal year end is June 30th, and our numbers are way off. Fun stuff!
Any advice will be much appreciated.