Skip to main content

Notifications

Community site session details

Community site session details

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

Automatic Assignment of Location Dimension Values to SKUs

(1) ShareShare
ReportReport
Posted on by 1,479
Hi:
 
Let's say that you have a "Location" Dimension Code where 1 represents Location A and 5 is Location B.
 
Further, let's say that you use the "Create Stockkeeping Units" screen to create two SKUs for an inventory item based on these two Locations.
 
Is it possible for Business Central to automatically assign 1 to one SKU and 5 to the other SKU, instead of having to do so manually within each SKU?
 
Thanks!
 
John
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    14,448 Super User 2025 Season 1 on at
    Automatic Assignment of Location Dimension Values to SKUs
    out-of-the-box Business Central doesn’t automatically assign dimensions to SKUs, so customization is needed.
    Alternative Without Customization: Using Default Dimensions on Locations
    This does not automatically assign dimensions to SKUs—it only applies dimensions when using Locations in documents.
    If your goal is to track dimensions only at the transaction level, this method works without customization.
  • Ramesh Kumar Profile Picture
    3,280 on at
    Automatic Assignment of Location Dimension Values to SKUs
    Hi John,
     
    But why do you want to do that? The reason behind using consistent dimension values is to standardize your reporting and maintain consistency. If you assign different dimension values for the same item based on different locations, it will prevent you from making accurate, apples-to-apples comparisons between locations.

    But it's achievable through customization, or there are some good apps available on AppSource.

     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,466 Moderator on at
    Automatic Assignment of Location Dimension Values to SKUs
    I don't think you can do it without customisation.
     
    Why not put the Location Dimension under your Location Card. The dimension will flow to the documents if you use that location.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans