Excel Journal Import
This easy to install add-on enables you easily import MS Excel data into Dynamics NAV. Create, save and manipulate journals using Excel features and transfer data into a Microsoft Dynamics NAV journal quickly.
Some of the functions imported
- Dimensions (global and extended)
- Custom fields
- Boolean check boxes
Excel Journal Import also creates grouped document numbers, according NAV’s rules, so that grouped navigation is provided for when posting a journal.
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 (eg G/L Account Number).