Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Inventory costing method change
srle
Member Posts: 6
Hi,
Our customer has decided to change Inventory costing method at the end of fiscal year. They wish their inventory costing method to be FIFO and SPECIFIC (tracking specific for serial number) instead of Standard Cost (used for manufactured items) and Average Cost (used for rest of inventory). Although we have the general idea how to solve it - that is to decrease all inventory to zero, change Costing Method on every item to FIFO or specific depending of specific tracking, and then return all inventory through Item Journal – we suppose that could be a tricky operation, or even more, a completely wrong approach to this problem.
We would be very grateful if you could help us on this matter.
Our customer has decided to change Inventory costing method at the end of fiscal year. They wish their inventory costing method to be FIFO and SPECIFIC (tracking specific for serial number) instead of Standard Cost (used for manufactured items) and Average Cost (used for rest of inventory). Although we have the general idea how to solve it - that is to decrease all inventory to zero, change Costing Method on every item to FIFO or specific depending of specific tracking, and then return all inventory through Item Journal – we suppose that could be a tricky operation, or even more, a completely wrong approach to this problem.
We would be very grateful if you could help us on this matter.
0
Comments
This subject and question has been asked and discussed several time.
http://www.mibuso.com/forum/search.php?mode=results
One more thing that you need to do is make sure there aren't any particially received not invoiced PO. as well as run adjust cost routine and post it to GL.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Your general aproach is correct. You could also do this by programatically changing soe paramaters, but that is not as safe as what you are suggesting.
So be aware that if you have outstanding Purchase invoices, then these must be posted. Basically all costs need to be in the system. Then run the adjustment routines. Make sure all the items are now stable with correct costs. Run a physical, to get the currnt quantities to zero, and then reintroduce the items as required. Now get your new costs and post a second physical after changing costing method.
Our customer has decided to change Inventory costing method at the end of fiscal year. They wish their inventory costing method to be FIFO and SPECIFIC (tracking specific for serial number) instead of Standard Cost (used for manufactured items) and Average Cost (used for rest of inventory). Although we have the general idea how to solve it - that is to decrease all inventory to zero, change Costing Method on every item to FIFO or specific depending of specific tracking, and then return all inventory through Item Journal – we suppose that could be a tricky operation, or even more, a completely wrong approach to this problem.
We would be very grateful if you could help us on this matter.