I had recently a request from a customer that they want to relate dimensions in Business Central. I.e you have a Sales Person dimension and you want to assign these dimensions values to a Sales Department dimensions.
Tag Archives: Dimension
Automatically create dimensions, it’s not that hard!
In this video, I show how you can auto-create new dimension values and populate the dimension set with your new dimension value. Check it out:
Dynamics 365 Business Central: How to import Dimension Combinations
I was asked an interesting question before, if there is a way to import the Dimension Combinations.
What are dimension combinations?
In Business Central, if you want to avoid posting entries with contradictory or irrelevant dimensions, you can using dimension combinations feature to block or limit specific combinations of two dimensions.
New Dimension Correction tool in Dynamics 365 Business Central version 18
To be honest I’m thrilled to write about this topic. The thing is, that I started my NAV developer career by developing the Dimension Correction tool for NAV 3.7 and then supported and upgraded it till NAV2016. “Trust me” I know what I’m talking about. After I’ve written this post I realized that it ended up very big. So, I added a context:
Create New Dimension ID to import dimension values from buffer table
Many questions in Microsoft forum about this topic: “How to generate new dimension ID from data (dimensions values for NAV login) existing on external tables ?”
Use standard NAV to achieve this, you can use standard NAV function DimMgt.GetDimensionSetID(Rec) to create New Dimension SET ID of function existing on UpgradeToolkit since NAV 2013.
How to Assign Dimensions to Master Data & GL Accounts in Dynamics NAV
This article and video continues the series of articles dedicated to Dimensions and explains how to assign Dimensions and Dimension Values to master data and G/L Accounts. In this article, the term “master data” is used to refer to such data as Customers, Vendors, and Items.
Easily Finding a Dimension Set ID in Microsoft Dynamics NAV…or Mr. Billion Goes to Washington
With the advent of the Dimension Set feature in Microsoft Dynamics NAV (Navision), it can be tricky to figure out how to change the Dimension Set ID assigned to a record in code or how to assign new dimensions to code. If you don’t know what you’re doing, you’ll spend a few hours writing stuff to go through all the possible dimension sets until you find just the right one, or your code determines that there isn’t a valid dimension set at all and you have to create one