How need some Help (Analytical Accounting)

[VirtualMx]

Good Day!

I have been Request to create a report based on aaTrxDimCode
which is located in(AAG00401)and also Display the aaTrxDimDescr(AAG00400) belong to the same Dimcode.

Once I have all the DimCodes and TrxDimDescriptions I have to associate all the accounts used on those DimCodes Which I believe are in the file AAG30001, but to get to this file I must Call the file AA30003(this contain the aaTrxDimId,aaTrxCodeId) Then to display the Account Description I must to Call the file GL00100 Which have all the Accounts plus I must be able to show the Invoices related to each TrxDimCode.

My Big problem is:

When I choose a TrxDimCode its shows accounts related to it but also is showing accounts that are belong to another trxDimCode.
How can I make sure that all the account are exactly related to the TrxDimCode that I'm using?

This are the File that I'm Trying to use:

For the TrxDimCodes
AAG00400------------->By aaTrxDimId

For the TrxDimDescr
AAG00401-------------->By aaTrxDimCodeId

AccountsRelated
AAG30003-------------->By aaTrxID or TrxCodeId
AAG30001-------------->By ACTINDX

Account Description
GL00100--------------->By ACTINDX,ACTDESCR


Again, How can I make sure that The TrxDimCode that I'm using is showing the correct ACTINDX Related?

 

[stef315]

What product is that? The one that uses TrxDimCode? I'm not familar with the AAG00401 table so it's either a module I haven't used or a 3rd party product or custom table.

 

[VirtualMx]

The product is Analytical Accounting and its belong to Great Plains..

Have you done some like that before?

 

[stef315]

No, I've never used Analytical Accounting before. I see Luvsql is responding to another post you have though so I'll let her respond there.