Hi all,
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,
Amy.
Hey Amy,
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.
Hi Jake,
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.
- In addition they have the following items that they call attributes. In addition, it contains a unique balancing dimension and Main account. The remainder of fields are the following:
- COMPANY – There are currently 7 companies but they use the same ledger, so we are not sure if company is a dimension or can be a separate legal entity that needs to be consolidated. These may or may not be separate legal entities.
- Codes
- Type Of Funds
- COLLEGE (Currently up to 3 characters defining what is being studied
- LOCATION (Locations used for different sub-departments) Currently, there are 10
- PURPOSE (a 2 digit field that shows what the amounts are used for
- DEPARTMENT a 5 digit account structure for each department
- FUNDSOURCE – the Name of the place that is funding transactions
- Survey – Only used when it is related to any type of Science including Computer Science
- ICC Code
- Map – has the same data as in the first balancing segment, but approximately 7000 of these report to the same Balancing Unit, but another 5000 point to a different balancing unit. In their old system, if the first digits were identical, it printed zeroes for the rest of the account number. If the Balancing Unit was different than the Map, the account number would show the Balancing Unit followed by the Map as the account number. In their current system, they set this up as two different attributes (dimensions). In their old system it occurred automatically based on a grid.
- RESPONSIBLE PERSON – the person responsible
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:
- Multiple account structures
- A way that does not necessarily use dimensions but derives the number.
- A way to populate the entire string using the 11 dimensions allowed.
- A way to have more than 11 dimensions. We found a document that said you could do this using advanced rules, but we are still researching that.
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?
-Jake