Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

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

*This post is locked for comments

  • 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans