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
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
Thank you
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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156