Skip to main content

Notifications

Microsoft Dynamics AX forum
Suggested answer

You must select a value in the (dimension) field in combination with the following dimensions values that are valid:

Posted on by 230

Hello!

Our customer ask us to improve the financial dimension structure with more financial dimensions, so we create a new one. 

The old one has the main account and a personalized financial dimension while the new one have Main Account/Bus. Units/Department/CostCenter/personalized fin.dim (with allow blank flag active).

After validation of the new structure the activation and after adding it in the General Ldger entry point we proceed to add some default financial dimension on main account (department and cost center) and item (business unit). 

Now we have some issue with SO (status open order/ delivered) already in the system --> we update the saleslines in order to update financial dimension with Business Unit and now we have on the sales line Business unit and in some cases the personalized financial dim. Cost Center and department are on the main account.

At the posting we have the following type of errors

You must select a value in the (dimension) field in combination with the following dimensions values that are valid...

I understand that the problem are related with the sales order header, If we add the fin. dimensions related to the account in the header the error disappear and the posting complete successfully. 

Should AX retrieve those fin.dim. on the sales lines and at the account level?

How is possible to update SO and PO already in the system before the change without develop some job?

We are on AX2012R3 CU12

Thank you

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: You must select a value in the (dimension) field in combination with the following dimensions values that are valid:

    Hi FBA,

    The findims that you setup as default values are not used when sales orders are created.

    That is because the default findim setups that have been made at the customer level and the item level overwrite the default values that have been specified at the ledger account level.

    That is, even if no default financial dimension values have been specified at the customer or item level - i.e. only 'blanks values are defined - those blanks overwrite what you have setup at the ledger account level resulting in the error that you see.

    To get this fixed you have to manually enter the findims at the header and line level as required.

    For future sales orders, please setup default findims at the customer and item level that will default into the SO header and lines section and allow you posting without any manual modifications.

    Best regards,

    Ludwig

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: You must select a value in the (dimension) field in combination with the following dimensions values that are valid:

    Thank you

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: You must select a value in the (dimension) field in combination with the following dimensions values that are valid:

    Sorry Crispin but I don't understand...

    I have a SO with no financial dimension on the header while I have two sales line with the same 2 financial dimensions, the other two are on the main account related to the posting.

    Why AX can't retrieve the other 2 financial dimensions on the account?

    Best regards

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: You must select a value in the (dimension) field in combination with the following dimensions values that are valid:

    Yes it's right.

    I would like to know why we should add dimension in the SO header and not on the lines, and why AX is not able to retrieve the financial dimension from the main account

  • Fabio C. Profile Picture
    Fabio C. 230 on at
    RE: You must select a value in the (dimension) field in combination with the following dimensions values that are valid:

    Thanks Crispin,

    unfortunately with new structure only if the allow blank flag for all the segments is active we are able to post the invoice, otherwise it is not possible to post anything without fin.dimensions.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,682 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,000 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans