GL Import – Installation Instructions

In order to successfully implement G/L Import the following steps must be completed:

Setup

  1. In your Microsoft Dynamics 365 Business Central environment locate G/L Import on the menu. Click onceand choose for the option Import Mapping.
  2. Select +New
  3. A new screen will pop up, under the Code-row you need to select a blank cell and enter: Import; Under the Description-row you need to enter: Import GL entries

  1. Locate the drop-down menu labelled Navigate, and click on Columns.
  2. This allows for the following fields to be filled in:
  1. See below for a visual example:

 

  1. In order to ensure a proper import process, please see the example below on how to fill in your Excel-sheet:

Save the Excel sheet as a CSV-file (CSV UTF-8)

 

  1. To test the dimension values, make sure the dimension values in the excel sheet are added in Dynamics 365 Business Central. First you must add dimension “TEST”:

  1. After you have added the Dimension, you need to add Dimension Values “Test1” for the first, “Test 2” for the second and “Test3” for the fifth dimension. In order to do this you must navigate to: Dimensions to Dimension Values and add the following values:

The first dimension:

The second dimension:

The fifth dimension:

  1. In the General Ledger Setup you must now add the TEST Dimension to Shortcut Dimension 5

  1. Navigate to the menu and select G/L Import to Import
  2. A screen will pop up, fill in the open fields as follows:

  1. After pressing OK you are prompted with the screen as seen below, pick Allow Always to ensure proper functionality.

  1. Open your Journal (ALGEMEEN) and Batch (GL IMPORT) to see the imported GL entries
  2. To conclude the process you must now Post the Journal.