Business Central - Setting Up Dimensions

Owned by Maria Harreguy
Last updated: Jul 12, 2023
3 min read

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.

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

 

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