Last month, I had written about the table changes in AA after GP 10 SP2.
Below are some more details, which might help those of you who have custom reports reading data from Analytical Accounting. Thanks to Rubal for detailing these out.
Earlier there were only AAG3XXXX series of tables for AA codes with GL Transactions. They contained data for both Open Year and Historical Year data.
Now, the Open Year and Historical Year data is stored in different tables. For Historical Years data AAG4XXXX series of tables have been added.
There is one historical table corresponding to each open table. Example - For table AAG30001, new table AAG40001 has been added for historical data.
| New Table Name | Corresponding Table for Open Year Data | Description |
| AAG40000 | AAG30000 | This is the Header table. It contains Journal Entry number and AAHdrID |
| AAG40001 | AAG30001 | Account Distribution of transactions |
| AAG40002 | AAG30002 | Assign Percentage details for the transactions |
| AAG40003 | AAG30003 | Dimension Codes used with the transactions |
Tables in GP
New tables Added for AA Alias
Aliases for Dimension codes was a cool new feature that was added in the Feature pack. (Create a grouping of Analytical Accounting Transaction Dimension codes as defaults when entering analytical information on a transaction similar to the account alias in General Ledger. A default combination of transaction dimension codes will help increase speed and accuracy for data entry and enable users to create more than a single set of defaults for the transaction dimensions.)
This information is stored in:
New Tables
| Display Name | Technical Name | Physical Name |
| AA Alias master | aaAliasMstr | AAG00800 |
| AA alias transaction Dimension Code | aaAliasTrxDimCode | AAG00801 |
Modified tables:
| Physical Name | Modification |
| AAG30002 | aaAliasID field added |
No comments:
Post a Comment