How to Import Excel Journals to Create Data Entry Efficiencies in NAV

The ability to import journals from Excel provides an easy and efficient way to undertake data entry in Microsoft Dynamics NAV.

You can take advantage of Excel features to prepare journals and use NAV standard functionality to transfer to NAV Journals for Print and “Post”.

You can import Excel Journals to NAV using 1. RapidStart Services and 2. Copying and pasting (Rows) functions in Microsoft Dynamics NAV.

Follow the following steps below:

RapidStart Services

Step 1 –

Setup a new ‘Configuration Package’ for the Journal Import. The ‘Table ID’ is 81 (Gen. Journal Line)

Step 2 –

Select the required Config. Package Fields.

Tick ‘Include Field’ to select a field.

Step 3 –

Export the Excel Template. Click on: Excel > Export to Excel

Step 4 –

Fill the Excel Template with the journal details. Save and Close the Excel template.

Step 5 –

Import the completed Excel Template. Click on: Excel > Import from Excel. The ‘No. of Package Records’ column will be display the number of records imported. Any errors will be displayed on ‘No. of Package Errors’ column.

Step 6 –

Apply Data. Click on: Function > Apply Data

This function will update the Journal in NAV.

Step 7 –

Go to Journal Window. Review the details imported. Print and Post.

Copy and Paste (Rows) functions in Microsoft Dynamics NAV

This function provides a quick way to import Excel Journal to NAV.

Step 1 –

Export Excel Template from NAV Journal window.

Click on ‘Microsoft Excel’ button on the Home ribbon to export the template.

Step 2 –

Fill in the Excel Template with the journal details.

Step 3 –

Copy the journal data items from the Excel Template.

Step 4 –

Open the NAV Journal window. The Journal Batch needs to be empty. Right Click on the 1^st line and select ‘Paste Rows’.

By Elvin Narain, Microsoft Dynamics NAV Developer/Consultant at EBS. For more information on Microsoft Dynamics NAV please contact Paul Woods at EBS on 1300 303 973 or email info@ebsys.com.au

Subscribe to the EBS monthly enewsletter to get the latest Microsoft Dynamics NAV, Arrow Financials news and more.  EBS enews.

Evolution Business Systems (EBS) specialises in business management solutions that give you the freedom to focus on your business. Melbourne based EBS does this by automating your core business processes and integrating your specialist business applications to deliver the right financial management solution. With deep expertise in leading financial applications including Microsoft Dynamics NAV and Arrow Financials, EBS works beside clients to ensure their software solves problems rather than creating more. EBS has a detailed implementation strategy that is tailored to customers in terms of timelines, requirements, risks and responsibilities. While it does not sell or support hardware or site network environments, EBS informally partners with selected specialists in these areas to provide clients with a “total solution”.

Contact EBS to find out how we can help you achieve your business goals.  Call EBS on 1300 303 973, email info@ebsys.com.au or visit our website to read more.

by