web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to import Vendor / Customer with Shortcut dimension in BC?

(6) ShareShare
ReportReport
Posted on by 541
Hi all,
 
Q1. This is a data migration topic.
There are 4 dimension ---- 2 Global dimensions and 2 Shortcut dimensions.
 
The user requires to set a default shortcut dimension value in Vendor. Therefore, they are gonna populate the values on the excel template.
However, I don't find the field them. I used Configuration Package to export the template.
 
How do I insert the field in the template?
 
Q2. In General Journal excel template, there are only 2 dimensions by default, the rest of dimensions can be added via Edit in Excel. Is there any way for us to upload the template with header only (no any data)? Such that we don't need to add the dimensions in the next time.
 
Thanks.
I have the same question (0)
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,639 Super User 2025 Season 2 on at
    Hello,
     

    Question 1: To include default shortcut dimension values in the Vendor Excel template using a Configuration Package, manually add the fields Shortcut Dimension 1 Code and Shortcut Dimension 2 Code (field numbers 100 and 101) to the Vendor table (ID 23) in the package, then re-export the template to reflect these fields.

     

     
    Question 2: To upload a General Journal Excel template with headers only and retain all dimension fields, either use a Configuration Package for the General Journal Line table (ID 81) with all dimension fields added manually, or use the Edit in Excel feature to create and save a reusable header-only template with all required dimensions pre-included.
  • Suggested answer
    Tech-Lucky Profile Picture
    1,267 Super User 2025 Season 2 on at
    Q1:
    When using Configuration Packages, only Global Dimension 1 and Global Dimension 2 are available as direct fields in master tables (like Vendor). The other dimensions (Shortcut Dimensions 3–8) are not stored as fields but are instead managed through the Default Dimensions table.
    To populate default values for additional dimensions in vendors:
    You need to import your data into the "Default Dimension" table.
    In your configuration package, include the table "Default Dimension" (ID 352).
     
    Table ID = 23 (for Vendor)
    No. = Vendor No.
    Dimension Code = Your Shortcut Dimension Code
    Dimension Value Code = The default value you want to assign
    This allows you to assign default dimensions for vendors beyond the global dimensions.
     
    Q2:
    You're correct — the General Journal Line table only exposes Global Dimension 1 & 2 by default in Configuration Packages.

    For additional dimensions (Shortcut Dimensions), Business Central uses Dimension Set Entries, which are stored in a separate structure and are tied using the Dimension Set ID field.

    To import these:

    You need to simulate the dimension combination using the "Dimension Set Entry" table (ID 480).
    Then assign the resulting Dimension Set ID back to your General Journal Line records.
    This approach is a bit complex and typically handled via AL code or data migration tools.

    Unfortunately, Configuration Packages don’t support loading a header-only template that retains all editable dimension fields. However:

    Edit in Excel provides access to all shortcut dimensions.
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
    Hi, try the option below in Configuration Package.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    RockwithNav Profile Picture
    8,637 Super User 2025 Season 2 on at
    Use configuration package and enable the flag which says Dimension as column. This will add additional 2 columns for Dimension which you can go and process.
  • Suggested answer
    Sohail Ahmed Profile Picture
    11,148 Super User 2025 Season 2 on at
     
    1. To import default shortcut dimensions for Vendor/Customer, include Table 352 – Default Dimension in your configuration package. Set:
     
    Table ID = 23 (Vendor) or 18 (Customer)
     
    No. = Vendor/Customer No.
     
    Dimension Code = your dimension
     
    Dimension Value Code = desired value
     
     
     
    2. For General Journal templates, use Edit in Excel to add extra dimensions manually, save the file as a template, and reuse it. Business Central only shows 2 global dimensions by default.
     
     
     
    ✅ Mark this as the verified answer if it helped.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans