Inventory consumed on wrong date

hansika · 2009-06-14

Hi folks,

Clent environment = Nav 4.0 SP3

client received the Rawmaterials against the purchase order on 01/06/09.

he created the production order on 02/06/09.
Actually he has to consume the rawmaterials on 08/06/09.

but he posted consumption journal on 08/05/09.(last month)

and our put posted and chnged the status of production order to Finish.
My problem is when
i run the inventory valuation for this month it is showing wrong qty and values.

so now how to correct this wrong posted entry and how to get the correct inventory valuation ?

Please shre your experience to solve the problem.

kapil4dynamics · 2009-06-14

problem is when i run the inventory valuation for this month it is showing wrong qty and values.

If it would have showed u correct then it would have been a problem.

The best , by default option, after finishing the production order is always, for all the issues, is reversal of posted entries with correct selection of apply to and from entries.

AdamRoue · 2009-06-14

I would recommend you sort out your posting controls from a date perspective to stop this happening again.

What costing method are you? If you are standard you can do a positive on 08.05 and a negative on 08.06 to correct timing on the stock. If you are average or FIFO then you cannot do this without altering the cost, so you would need to run it through.

hansika · 2009-06-15

Thanks steven,

we are using the FIFO costing method for the Rawmaterials.
so please throw some solution on this.

AdamRoue · 2009-06-15

You would need to setup the scenario in a test system, then load the journals, run the adjust costs and see the affects this has and if you need to do any revaluation.

Inventory consumed on wrong date

Comments

Categories