Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1.1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 326 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Cost Not Updating before Change Status in Production Order
dede_aja_tuh
Member Posts: 39
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!
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!
0
Comments
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!
NAV Freelance Consultant