This issue was posted in Dynamics AX thread a couple years ago but solution was not published - Client has the Main account in fourth position of account structure and I cannot activate two structures in the same company that have the exact same segments but different 'Allowed values'. It works with the Main account in first position.
I'm experiencing the exact same issue with on an F&O project, v8.1, Update 23.
Thanks in advance.
Thanks Ryan. Understood. I think we'll be able to convince the client to put Main account in position one, so this might be moot but it's good to know. And thank you Andre for the assistance also!
Hi Frank, The account structure would simply be changed for the dimensions ahead of the main account to not allow blanks. So that checkbox would be removed. This will allow the 2 chart of accounts to be added to the ledger without the possibility of "unknown/optional" values for a particular dimension before the main account is specified. The dimensions ahead of main account would need to have a new value added of <blank> that are a hard string. This value of <blank> as a string would be used/set where the value is actually empty today. It is quite a workaround, but is a limitation today for the account structure setup if blanks are allowed before the main account.
Thanks Ryan. What would the account structure config look like with <blank> instead of ""? Appreciate the help.
Andre is correct. The account structure setup is still read left to right, and allowing blanks (optional) makes it hard to know in code what structure to apply to the account entry. Specifying the main account allows it to identify what structure to apply but would require the main account to move left in the structure setup.
Secondly - the use of <blank> as a value selected instead of " " an empty string or allowing actual blank value in the account structure is an option to allow the flow to use that value to signify blanks.
Hi Frank,
When activating an account structure, there are two validations.
1) Is there any inconsistency in the structure?
2) If the structure is linked to one or more legders, it will validate for inconsistencies/overlaps between the structures.
The second validation is used when you link the structure on a ledger also. This is now causing the error. A blank value would be a duplicate (overlap) when you have multiple account structures.
"The node for dimension Department with criteria * for account structure Demo COGS is marked optional. You must unmark the Optional checkbox for the node before you can activate the account structure."
The error message is misleading because the structure has been activated. The error appears when attempting to add the structure to the ledger where another structure already exists with different 'Allowed value' details in dimensions preceding the Main account.
What is the exact error message then?
No issue when activating the Account structure - the error occurs when attempting to add the second active Account structure to the ledger. Thanks
Hi Frank,
Do you get any error when activating the account structure or when you want to add an active account structure on the ledger form?
The system might check the first column to have unique values, but I'm not sure as I never did have the main account on another position. If you think it is a wrong behavior, you can create a ticket for Microsoft Support.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
