Now Available in Community - New TechTalk Videos for 2020
Read More about New TechTalks for 2020
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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.
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.
No issue when activating the Account structure - the error occurs when attempting to add the second active Account structure to the ledger. Thanks
What is the exact error message then?
"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.
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.
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.
Thanks Ryan. What would the account structure config look like with <blank> instead of ""? Appreciate the help.
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. 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!
Business Applications communities