Dimension Priority

MBClarke

Hi all,

I have a situation regarding how the dimension priority should work. We are using Dynamics NAV 2017, W1 version. The scenario is as follows:

Client has a global dimension for department, this department is extremely important to them, as it determines how reporting to the board is done. They are a print manufacturer which is very complicated. We have the expected cost turned on, as we need that to reflect in the GL at time of receipt or shipment of items, as well as consumption of raw materials.

The issue is this, the GRN Suspense account (2222010), which is the set as the Inventory accrual account (Interim) needs to have dimension department set to 140. The opposite side of that entry, to GL account Inventory Account (Interim) - (1711000) should post to dimension department 110.

I have these on the two GL accounts as the default dimension. In the dimension priority, I have set the GL table to be priority 1 for all source codes, and then the Item table as priority 2. The item I am purchasing does not have a default dimension set, not is it set to use any dimension.

When I create a PO for a Vendor and the item, the Vendor has no default dimensions. The PO is created with no dimensions at all, and when I try receive the PO line, I get an error that I need to enter the department dimension as 140 for GL account 2222010. This is set as the default dimension on the GL account. I then enter a dimension for the PO line, and set it to 140, and receive. The GL entries then post both sides to department 140, and not to the dimension set on the various GL accounts, and the GL is priority 1.

Sample of what should happen:
PO 100
Vendor ABC - No dimensions set. - Trade Payables GL account has department dimension set as 110 by default.
Item 101 - no dimension - The interim and Inventory accounts in the GL have the department dimension set by default. Accrual account (interim) - Department 140
Inventory account (Interim) - Department 110

No dimensions on the PO header or line.

When receipt, receive dimension error that department should be 140 for Accrual account, which it is in the actual account.

This has me stumped as to whether I will be able to accomplish the clients requirements.

Is there anyway for me to get around this? I basically need my PO receipt to post to separate department dimensions for both sides of the interim posting, and then when invoiced to same.

I don't see the dimension priority doing anything for me in this regard, as no matter what I change and setup, I get the same error at time of receipt.

Any insight or assistance on this would be greatly appreciated.

Thanks

Malcolm

allenyyzhou

Hi

I think the reason is all the General Journal created inside the PO posting procedure, there is no validate there. So no default dimension will insert for GL account.

You can try add G/L Account directly into purchase order subform, I think dimension priority will work.

Back to your requirement, you have to set default dimension in vendor or item, otherwise you need to do some customization about it.