I have a situation where we need to report on several attributes per main account number. There is one dimension that must be balanced, but there are about fourteen attributes that need to be reported on in addition to this one dimension. and Main account, the primary dimension needs to show the value of each of the other attributes for that dimension. Since there are more than 10 of them, how could I handle reporting on all of the attributes? By the way, the word "attribute" does not mean attribute as defined in AX. They are all general ledger items that need to show based on the initial balanced dimension. The dimension that has to be balanced may have one or more of these items, up to the total amount of items. I do not believe that any of these contain every one of the dimensions, but it will be used in a single Legal entity and will use the same Chart of Accounts. Is therte any way this can be accomplished?
Thanks in advance,
Could you give an example of what that would be? Obviously, you've run into the limitation of 10 dimensions account structure, so it'd be interesting to see if there's another way to handle your requirement.
Here are the issues we are having in more detail:
Our setup uses a balancing segment where each number is unique and must be balanced. Let us call this field “Balancing Dimension”. It is the first dimension. They also have listed 7 companies. At the current moment, we do not know whether these are separate legal entities. In their current system, they all use the same ledger, but use the same Chart of Accounts and account structure, and each company has its own Balancing units that are not in any other company. In my opinion, company would probably have to be balanced as well, but they usually report it at a consolidated level. These fields are for a school.
There are no cases where any Balancing Unit uses all of the dimensions We need to report like a matrix across each dimension or attribute.
We are considering the following:
Do you have any ideas?
Are any of these things related to each other? For example, does a location always map to the same college? Also, one way might be to separate the legal entity into a company and use the same account structures everywhere. Finally, do ALL accounts need the same dimensions?