Historical data
When moving from an ERP system to another ERP system such as Microsoft Dynamics NAV, a lot of companies want to import their historical data into the new ERP. For example, the companies may want to import all the inventory entries made for the previous year for statistical purposes; or, if they start working with Microsoft Dynamics NAV in the middle of a fiscal year, they may want to import all the G/L entries made in the old system for the current fiscal year.
In Microsoft Dynamics NAV, this kind of data is stored in ledger entry tables. If you have to conduct a migration of such data, never import it directly into the ledger entry tables. Use journals instead, and post the data. This way, Microsoft Dynamics NAV will create the ledger entries for you in a consistent way.
For the item ledger entries, for instance, not only is the item ledger entry created, but the value, item register, item application entries, and other entries are created as well. If a journal is used, all...