There are different ways to reduce the size and speed of a Dynamics NAV upgrade. This blog will cover one component, compressing item ledger entries that may prove useful. However, it is important to note that with any major change such as this, it requires thorough testing of the solution and mapping out a blue print for the plan.
To begin, it is important ask yourself:
The following is a summary of what I have discussed with partners who have done the process through an upgrade scenario. In particular, this was completed often when moving from 2.X to 3.X Versions due to the significant change in data structure, which was a result of the introduction of the Value Entries in Version 3.X and prior. As a result, the process below requires modifications depending upon what data exists – i.e. Manufacturing, Assembly (2013 and later), Kit Data (2009 and earlier), open Orders – Sales/Purchase/Production/Assembly, Warehouse Entries, Location Setup, etc.
Make sure all SO’s and PO’s are invoiced (no received/shipped not invoiced) and run the Adjust Cost Item Entries and Post Inventory Cost to G/L. This may entail having to use the Undo Receipt Shipment or Undo Receipt if the orders cannot be invoiced. This is key so that you do not delete Item Ledger Data that has dependencies on existing outstanding order status as well as any unprocessed adjustments for quantity or value. NOTE: Further challenges come into play with Manufacturing Production Orders. The best practice is not to have partially processed transactions prior to deleting Item data, which can get to be quite challenging.
The primary goal of this process is to be able to import and export data in the system and generate through Dataports the Item Journals to establish new Inventory data beginning quantity and cost.
The biggest challenge is managing some of the additional details, such as Item Tracking (LN and SN Data), Manufacturing, Assembly (or Kitting depending on Version), and other data linked to the existing ILE and VE data.
I hope this gets to a place to where there is a vision for the processing required. Again, I would test the process extensively because removal of data and identifying all related dependencies is an extremely challenging endeavor. I suggest referring to the Inventory Costing in Microsoft Dynamics NAV white paper. This is a good reference as a beginning point for consideration with the data structure for inventory posting and costing data analysis. While the paper was written for Dynamics NAV 2013, the fundamentals are still the same.
I wish to keep in mind that this is kind of a theoretical discussion. I have never blown away item data and then rebuilt it with the process. Through interactions with partners along the way, this has become kind of a moving document for how to manage the process. We would like to hear your thoughts and ideas. Please comment below.
For more Microsoft Dynamics NAV development related topics, please subscribe to our NAV Developer blog where you will find a plethora of development-related tips, how-to’s, and NAV-related discussions.