G/L 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:
  • Colum No. = Fill in column number from Excel sheet, column number 1 is the first column starting on the left hand side.
  • Field No. = Choose the field that you want to import
  • Field name = Name of the field that has been chosen
  • Field caption = Name caption of the field that has been chosen
  • Validate field = Validates the imported value for the field in general journal
  • Remove characters = Removes character in imported value when filled in
  • Remove space = Removes space in imported value when ticked
  • Shortcut dimension No. = When you choose a shortcut dimension 3 or higher you are required to fill this field with the shortcut dimension code number.

  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:
  • File Name = Choose your Excel Sheet for Import.
  • Import Code = Choose your import code that has been created during Step 3
  • Journal Template Name = Pick your Business Central Journal
  • Journal Batch Name = Choose your Business Central Batch

  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.

Let's Partner Up

Want to resell one (or more) of the suggested apps. Click the button, fill out the (pop-up) form and we will get in touch with you.

Suggest an App

We can develop the app you need for you! Click the button, fill out the (pop-up) form and we will get in touch with you.

Let's Partner Up

Want to resell one (or more) of the suggested apps. Fill out the pop-up form and we will get in touch with you.

Suggest an App

We can develop the app you need for you! Click the button, fill out the (pop-up) form and we will get in touch with you.

Suggest an App

Got a great app idea you want us to develop for Business Central? Click the button (form pops up), tell us what you want and we’ll get in touch!

Become a Partner

Want to resell one (or more) of the suggested apps. Click the button, fill out the (pop-up) form and we will get in touch with you.

Micro Apps B.V.

📌 Kastanjelaan 400 (Microlab)
📍 5616 LZ Eindhoven
📩 info@micro-apps.com

Let's Partner up

Earn money per sale, broaden your offer and build better customer relations by selling Micro Apps through your own channels!

Earn commissions per Micro App you sell, increase and improve customer relations with an extended Business Central App offer!

WE ARE Here To Assist You

Tell us a bit about the app you want us to develop...

Congratulations!

let us come back to you within 24hrs..

If Something Wasn’t Clear?

Feel free to contact us, and we’ll be more than happy to answer all of your questions.