Cost Not Updating before Change Status in Production Order

dede_aja_tuh

Hi All, i got question like this :

If i create 1 new item like say : Item Code - ABC (as Finished Good; unit cost : 0) which contains Item 123 (as Component; unit cost 100).

Next, i create Prod Order to create 10 item ABC, then create consumption journal and output journal.

When i finished posting output journal, then i go to item card ABC, i see stok/quantity already update 10. So, i make Sales Order and post shipment, but when i go to history post shipment | navigate, there is no GL Journal create.

When i check this, maybe this is caused unit cost item ABC still 0 (zero). So, i try to Change Status Prod Order (released to finished), and when i see again unit cost item ABC, it already updating. Again, i see history post shipment | navigate, suddenly NAV create the journal shipment.

One question from me :
How to make unit cost item ABC already update from 0 became 100 eventhough i don't change status Prod Order yet? Any setting can i do to make this happen?

Because it will make big problem for the client (in Indonesia) expecially if they already do Monthly Closing at their book which once they already closed, it never can opened again because the number already give to Management. Depend on my example above, if i do Output Journal and Post Shipment in January, then i change status Prod Order in February, so COGS Amount that we got for January before change status and after change status will be different.

Appreciate for any advise. Thanks and Help me!

bbrown

Have you run Adjust Cost?

dede_aja_tuh

bbrown wrote:

Have you run Adjust Cost?

Hi BBrown,

thanks for ur reply. Sorry, i don't inform warehouse setting in my client.

This is the setting : in Warehouse module | Setup | Inventory Setup :
Automatic cost Posting : YES (checklist)
Expected Cost Posting : YES (checklist)
Automatic Cost Adjustment : Always
Average Cost Calc. Type : Item
Average Cost Period : Day

Any idea again for me Bbrown?

Follow up ur question for me, i try to adjust cost in Financial Management | Inventory | Costing | Adjust Cost - Item Entries, and after that, i look at again item ABC, but still the unit cost still 0 (zero) ](*,) .

Please help!

cernst

When posting output NAV posts expected costs because you've marked this in setup. When it post expected costs NAV looks at the unit cost on the item and there you have 0 so no postng is done. When you create a new production item always calculate standard cost and make sure you have a value in the unit cost field no matter what costing method you're using then you'll get expected cost posting. When fnishing the production order and everything is invoiced you get an adjusted cost.