Example
You have a scenario with the following dimension settings:
- A customer without default dimensions
- An item with ADM as the dimension value for the DEPARTMENT dimension
- location Atlanta with PROD as the dimension value the DEPARTMENT dimension
- location Miami with FABRIC as the dimension value the DEPARTMENT dimension
- Location “Dallas” with “ADMIN” as the dimension value the DEPARTMENT dimension
- Default dimension priorities are set as Location > Customer > Item
When you create a new document in this scenario, dimensions are used as follows:
- If you create a new document and add a location, the default value for new lines will be PROD.
When you add lines with items, Business Central will keep PROD because it comes from the header of the document.
- Here we have the first wording issue:
We should not look everytime on the header by getting Dimensions for the lines.
On our site we should check the priorities.
When the location code has a higher Priority as the customer (because the customer is also the variable for the header), then the system should look at the line location. And not overwrite the dimensions, when the location itself has a dimension value.
Here my issue is only the wording
The wording “because it comes from the header of the document.”
On our site this is not correct, when you have other higher dimension priorities.
- If you create a new document and add items that have the ADM dimension value, and then specify a location in the header of the document, Business Central will ask whether you want to overwrite the existing lines because there's a conflict.
- That’s correct.
- But on our site, it should look everytime at the dimension priority – When Location is higher then item -> We can get the dimension from the location
- When the customer is higher as the item -> We can get it from the header
New example from me
- If you create a new document and add the location Atlanta in the header.
Then the header has firstly the dimension from the location atlanta.
Now we select an item without a location in the lines, then the Dimension in the lines should be PROD because customer has a higher priority as the item.
When we select in the line a new location “Miami” then the line has the dimension value “FABRIC”. (Because Location has a higher priority as Customer/Header).
When we now change the header location to DALLAS.
· NOW
§ The header and the lines are getting the dimension “ADMIN” (By answering the question to change the dimension in the lines with yes)
· Our Opinion
§ The Header should get ADMIN and the lines should keep FABRIC, because the Dimension Priority is by the location higher as by the customer/header.