Easily Import Excel Data
Take advantage of the power of Microsoft Excel by creating journal entries in Excel using any of its formulas and features, and transfer them directly into any Microsoft Dynamics NAV journal. Create complex journal entries using Excel’s totaling and subtotaling function and import the lines directly into a Dynamics NAV journal with our special utility. Even Dimensions (global and extended), data in custom fields, and Boolean check boxes can be imported. If you wish to import into a Recurring Journal, date formulae can be imported. And all data is validated before being imported into to Dynamics NAV.
Create a journal in Microsoft Excel...
...then import it directly into the journal, print and post.
If desired, Excel Journal Import will create grouped document numbers, according NAV’s rules, so that posting the journal will allow for grouped navigation.
Export from a payroll program to an Excel file, and import directly into a Dynamics NAV journal, using the Excel auto-fill function to create information required by NAV that may not be in the payroll program, such as G/L Account Number.
Import Recurring Journal entries, Fix Asset entries, Job Journal entries, Item Journal entries, Cash Receipts entries, or entries in any other journal.