By AJ Ansari, NAV Product Manager
A key shortcoming with Microsoft’s current data migration tools for importing data from QuickBooks, Dynamics GP or Excel into Dynamics 365 for Financials is that they all focus on migration of Master records, and not on import of any transactional data.
Most customers at least want an opening balance for each G/L Account, and sometimes Net Change by G/L Account by month for the last 12 months (for comparative reporting), and to bring in opening Receivable balance for each Customer, Payable balance for each Vendor, and Inventory valuation and quantities.
These can be done by entering or importing data into the General Journal, Sales Journal, Purchase Journal, and Item Journal. BUT, with no RapidStart for Data Migration yet, and the fact that none of these Journals have an ‘Edit in Excel’ option out-of-the-box, getting transactional data in can be quite a hassle.
What I find curious is that there is an Edit in Excel button on the ribbon on the Batch selection screen for each journal, but not on the actual journals themselves (where it is needed).
So you either need to type all that data in, or you have to get creative. What we’ve done is created and published a Web Service for each of those Journal pages, and did a little reverse-engineering to be able to Publish data from Excel into Dynamics 365 for Financials like you can from an “Edit in Excel” list.