Financial dimensions are used to categorize your financial transactions. But when bulk entering transactions  in Dynamics 365 Business Central,a drawback only allows you to set two dimensions. In this article I'll demonstrate how all the dimensions can be set while importing and exporting entries through Business Central using Excel. This is very important because General Journals are used to make transactions and corrections to the General Ledger, which typically involves bulk imports and exports from Excel.

Pre-requisites

  • VS Code
  • AL Language Extension
  • Functional knowledge of  dimensions
  • Microsoft Dynamics NAV /  Business Central
  • Setup dimensions in General Ledger

1. Understanding how dimensions work technically

Any dimensions that are inserted in an entry in the system are validated to be stored in the Dimension Set Entries table.

dimension_set_entries_table

This Dimension Set Entry ID is stored on the entries to be used as a reference. For instance, if we want to Apply Dimensions to General Journal Entries, the Dimension Set Entries ID is stored on General Journal Lines Table.

dimension_set_id_storage

Out of eight total dimensions, two dimensions are stored on the table. These two dimensions are also known as Global Dimensions.

2.  Getting to work in Business Central

....Read More