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)

 

Excel journals and Microsoft Dynamics NAV Image 1

Step 2 –

Select the required Config. Package Fields.

Tick ‘Include Field’ to select a field.

Excel journals and Microsoft Dynamics NAV Image 2

 

Step 3 –

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

Excel journals and Microsoft Dynamics NAV Image 3A Excel journals and Microsoft Dynamics NAV Image 3B

Step 4 –

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

Excel journals and Microsoft Dynamics NAV Image 4

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.

Excel journals and Microsoft Dynamics NAV Image 5A Excel journals and Microsoft Dynamics NAV Image 5B

Step 6 –

Apply Data. Click on: Function > Apply Data

This function will update the Journal in NAV.

Excel journals and Microsoft Dynamics NAV Image 6A Excel journals and Microsoft Dynamics NAV Image 6B

Step 7 –

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

Excel journals and Microsoft Dynamics NAV Image 7

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.

Excel journals and Microsoft Dynamics NAV Image 8

Step 2 –

Fill in the Excel Template with the journal details.

Excel journals and Microsoft Dynamics NAV Image 9

Step 3 –

Copy the journal data items from the Excel Template.

Excel journals and Microsoft Dynamics NAV Image 10

Step 4 –

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

Excel journals and Microsoft Dynamics NAV Image 11 Excel journals and Microsoft Dynamics NAV Image 11B

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.