Nav2015 - Migrating Historical Data ie Old Sale transactions

Eoin_L

Hi,

I am using Nav2015 having changed from an old legacy accounting system.

I have the Customer/Vendors/Inventory & chart of accounts created using the rapidstart & spreadsheets from the legacy system. I have the opening balances & outstanding Invoices in journal batches & these posted ok.

But due to customer enquiries - I also have the old sales transactions(header/total details) in a spread sheet, these are Invoices/cr notes & payments that have already been posted & matched of prior to the customer opening balances now entered in NAV2015. Is it possible to take these into Nav without affecting the current accounts? If so would anyone know the best practice steps/guide for doing this successfully?

I know normally it's best practice not to take in historical data but at the same time I need to investigate if this is possible.

Many Thanks, Eoin

mrealm1

A lot of this may be based on their requirements. Do they need the corresponding historical financial data (ledgers) or just the posted documents? Trying to populate the data for reference into the posted documents is possible, however a lot of the functionality in the posted documents may not work and it could be, well, problematic if not extremely careful and or complete. I have on several occasions, where the information was for reference only and needed to be centralized, created historical tables and pages for viewing the tables. This allows the users access to the historical data without affecting the NAV processing. They can also join the data for reporting if really needed. Eventually, when the historical data is stale and falls off, you can remove the tables if desired.

Eoin_L

Thanks for the reply.
The main reason for the data being needed is to have the ability to be able to run a customer account statement/enquiry & see all transactions from both the old & new systems (both matched & open transactions). Also to be able to run stock sales enquiries.
(This migration is mid financial year, not at the end of year.)

Thinking more about it, Should I just bring everything in as open journals, post them all & then do the opening balances on the customers/vendors & chart of accounts?

Then take a backup & make that the start point for new transactions in NAV2015 - Preventing the user form changing any older dates.