Cause 1The account is not linked to an Accounting Class. See Resolution 1 below.
Cause 2The aaBrowseType may be incorrect for the account within the AAG20001 subledger distribution table. See Resolution 2 below.
Cause 3The Account Master table in Analytical Accounting (AAG00200) has not been populated or is missing accounts. See Resolution 3 below.
Cause 4Records exist in the AAG20000 series tables with an invalid header ID. See Resolution 4 below.
Cause 5The next available number in the AAG00102 table is out of sync with the last used number in the actual AA transaction table. Although with this method, they should also be experience Duplicate Key errors. See Resolution 5.
Resolution 1Verify that the account is marked as being linked to an Accounting Class. To do this, click on Cards, point to Financial, point to Analytical Accounting and click on Account. Enter the account number. Verify that Class ID field is populated.
Resolution 2In SQL Server Management Studio, review the AAG20001 (aaSubledgerDist) table that stores all the distribution records associated with a particular subledger transaction. Each transaction should have at least two or more distributions (debit and credit) associated with it. You can cross-reference the Account Index to the GL00100 Account Master table in GL to be sure you are viewing the correct distribution line. Review the value listed in the aaBrowseType column. To be able to add AA data to this distribution line, you would want this field to show a '1' if the account is linked to AA.
The values in the aaBrowseType column mean:
0 - Not linked
1 - Required or Optional codes allowed
2 - AA Code is set to Required, but not filled in
A good starting point is to look for missing required codes (value of '2') and update those to a '1' to see if that resolves it.
select * from AAG20001 where aaBrowsetype = 2
Note: To obtain a script (AA_Update_aaBrowsetype.sql) that will update the aaBrowseType column for all linked accounts to match the current setup for that account/class, you would have to open a support case for further assistance. To open a chargeable support case, you may call Microsoft Technical Support at 1-888-477-7877.
Resolution 3In SQL Server Management Studio, make sure the Account Master table (AAG00200) in Analytical Accounting has been populated. This table should have the same number of records as the Account Master (GL00100) table and the Account Index Master (GL00500) in GL.
To repopulate the AAG00200 table, you can run the script below. This script will insert any missing accounts into the AAG00200 Account Master table that exist in the GL00100 Account Master table.
Insert into AAG00200 (ACTINDX,aaAcctClassID,aaChangeDate,aaChangeTime)
getdate(),114) from GL00100 where ACTINDX not in (select ACTINDX from AAG00200)
Resolution 4If there are records in the AAG20000 subledger tables in AA with an invalid header ID of '0', this could cause issues. If there are invalid records in the AAG20000 series tables, the validation process checks to see if the distributions are linked to an Accounting Class, and may see these records as not linked and produce the error message above.
You can correct the problem by clearing out the records with an invalid header ID from the AAG20000 tables. Execute the scripts below in a query window in SQL Server Management Studio against the company database to see if there are any invalid records and if so, you may remove them:
Select * from AAG20000 where aaSubLedgerHdrID = 0
Select * from AAG20001 where aaSubLedgerHdrID = 0
Select * from AAG20002 where aaSubLedgerHdrID = 0
Select * from AAG20003 where aaSubLedgerHdrID = 0
Resolution 5For more information or steps on how to update the next available number in the AAG00102 table, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 2535754 - Last Review: Apr 13, 2016 - Revision: 1