Conflicting Dimensions in Microsoft Dynamics NAV

Conflicting Dimensions in Microsoft Dynamics NAV

In Microsoft Dynamics NAV you are able to specify or prevent a dimension on any master record.  Examples of master records include the Item card, G/L Account, Customer Card, and Vendor Card. Occasionally the Dimensions specified on 2 different master records may conflict. Read on to learn how to resolve should you run into this issue.

Master Records

Microsoft Dynamics NAV allows you to specify or prevent a dimension on any master record.  Examples of master records include the Item Card, G/L Account, Customer Card, and Vendor Card.

Occasionally the Dimensions specified on 2 different master records may conflict. 

The example below shows the Customer Card and the Bank Card.  The ‘Area’ dimension is mandatory on the Customer Card and prevented on the Bank Account Card:

screen shot Customer card Dynamics NAV
Figure 1 – Customer Card, Area Dimension

 

screen shot of Bank Card in Dynamics NAV
Figure 2 – Bank Card, Area Dimension

 

If you try to combine the above 2 master records on the same line on a journal (a cash receipts journal in this example) you will get a conflict error. See example below:

screen shot, error code on master record dimension Dynamics NAV
Figure 3 – Error Code on Dimension Code in Master Record

 

To get around this issue, two separate journal lines need to be created for the journal to post successfully.

screen shot, creating journal entries in dynamics nav
Figure 4 – Creating Separate Journal Entries

 

Avoiding conflicting dimensions doesn’t have to be difficult, it just takes a little forethought. Always include separate journal lines for each entry and your journal will post correctly.

For more information on this or any other Dynamics NAV topic, please contact ArcherPoint.

For more step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV, see our collection of How-To blogs.

 

Trending Posts

Stay Informed

Choose Your Preferences
First Name
*required
Last Name
*required
Email
*required
Subscription Options
Your Privacy is Guaranteed