Using Table Validated value sets in Chart of Accounts
Summary
Since dependent values sets are not supported (For CoA) can Table Validated value sets be used insteadContent
The client has over 200 stores which belong to 10 different legal entities. "Entity" and "Stores" will be segments in the CoA. However, when entering the value of a store only those stores should be visible depending on "Entity" value chosen. This requirement would have been resolved if dependent value sets were supported in the CoA. However, since its not, we were considering using Table Validated value sets instead. Any thoughts on its possibility or impact?
Note - Using security rules and CVR will be a last resort as maintaining it will be extremely difficult.
1