Business Central - Setting Up Dimensions

Setting up Dimensions 

1. After choosing Connected Company, click Get Dimensions to get the list of dimensions from Business Central. Dimension 1 and  2 dropdown list will be populated and the user will be able to select dimensions accordingly. Save the form to keep the configuration.
   
   

   Open

   

2. Interface Suppress Inter-Company Posting setting must be checked
   
   

   Open

   

Dimension/Analysis 1

Given that the setting - Interface Suppress Inter-Company Posting is ticked, Dimension 1 is mapped to the Job's Profit Centre Export Code. The Export Code should correspond to a dimension value code of the selected dimension in Business Central. If the PC Export code does not exist in Business Central, Dimension 1 will not be recorded to BC

Dimension/Analysis 2

Given that the setting - Interface Suppress Inter-Company Posting is ticked, there are a few settings/checks on determining dimension 2 value.

1st check: If setting Export Job Codes is checked, dimension 2 is set to line's Job Code.

2nd check: If line Job has Job Group with Category = ‘Export' then dimension 2 is set to Value or Group if there is no Value. In this example, the dimension 2 value will be set to 'Victoria’

Last check: If the result of the above checks is the same as the Retention Job Code of the Financial Company of the Profit Centre of the header Job, dimension 2 will be set to line's header Job Code.

Validating dimensions after Export

1. AP Invoice

   1. Path: Purchase Invoices > locate and open exported invoice

   2. Select purchase invoice line > click on Line (Click More options if not available) > Related Information > Dimensions

   3. Validate that Dimension 1 is set with the correct Dimension Value/ PC Export CODE

2. AR Invoice / Credit

   1. Path: Sales Invoice / Sales Credit Memo > locate and open exported invoice

   2. Select sales invoice line > click on Line (Click More options if not available) > Related Information > Dimensions

   3. Validate that Dimension 1 is set with the correct Dimension Value/ PC Export CODE

3. GL Journals

   1. Path: Search for General Ledger Entries

   2. Locate Journal batch entries > Click on ellipsis > Dimensions