Troubleshooting Automatic Accounting Instructions Within EnterpriseOne Accounts Payable (P0012)

RESOLUTION . Use the AAI Display program (P00121) to correct the Account Number associated with the G/L Class Code AAI. NOTE . . . . You may display the invalid AAIs that caused this error by using the "Referenced Program" facility (Option 2).

Scenario: What causes the "AAI for G/L Class Code Invalid" error when entering a Pre-Payment Voucher?

Solution: In case of entering a Prepayment voucher, please check the value specified in Processing Option 1. G/L Offset Account on the Prepayments tab of the Standard Voucher Entry (P0411) application. Depending on the valuse specified,it is required to setup the PCxxxx AAI (where xxxx is GL offset) for the mentioned GL Offset.

Error ID: 2976 - "AAI for G/L Class Code Invalid"

CAUSE . . . . The Automatic Accounting Instruction (AAI) for the G/L Class Code does not exist.

RESOLUTION . Add the missing AAI through the Automatic Accounting Instructions program. NOTE . . . . You may display the invalid AAIs that caused this error by using the "Referenced Program" facility (Option 2).

Scenario: Recieving Error 2976 "AAI for G/L Class Code Invalid"

Resolution: Processing Option Prepayments Tab - GL Offset Account. Use this processing option to set up automatic accounting instructions (AAI item PCxxxx) to predefine classes of automatic offset accounts for accounts. For example, you can assign G/L offsets as follows:

Blank or 4110 - Trade Accounts Payable
RETN or 4120 - Retainage Payable
OTHR or 4230 - Other Accounts Payable (see A/P class code - APC)
PREP or 4111 - Prepayment A/P Trade Account

Enter the code for the G/L offset account that the system uses to create prepayment pay items. You must enter a value to allow automatic creation of prepayment pay items. If you leave this field blank (default), the system uses the Standard Voucher Entry program.

Bank Account Related - AAI Errors

Error ID: 2979 - "AAI Account for Bank Account Invalid"

CAUSE . . . . The Account Number associated with the Automatic Accounting Instruction (AAI) for the Bank Account is invalid.

RESOLUTION . Use the AAI Display program (P00121) to correct the Account Number associated with the Bank Account AAI. NOTE . . . . You may display the invalid AAIs that caused this error by using the "Referenced Program" facility (Option 2).

Error ID: 2978 - "AAI for Bank Account Invalid"

CAUSE . . . . The Automatic Accounting Instruction (AAI) for the Bank Account does not exist.

Error ID: 0015I - "PBC01 and PBC02 AAI Required"

Cause:The Post Balances by Currency AAI’ s PBC01 and PBC02 must exist when enabling the Post by Currency flag in the Company Constants program (P0010).

Resolution: Create the PBC01 and PBC02 AAIs for the company.

Error ID: 120D - "'PBCxx' AAI's Not Set Up for Co &1 ."

CAUSE . . . WARNING ONLY! The "PBCxx" AAI Account Range(s) are not set up correctly for company &1 . This company is flagged in the company constants file for 'Posting Balances by Currency'. At least one "PBC01" AAI specifying a beginning account range should be set up, as well as an ending account range in the "PBC02" AAI. Additional PBC account ranges may also be set up as PBC03, PBC04, etc.

RESOLUTION. . Set up the proper "PBCxx" account ranges in Automatic Accounting Instructions. A generic AAI range may be set up for company "00000" to be used by all PBC companies, or a specific AAI range may be set up for an individual company. NOTE: If no other errors occur- red, this batch posted successfully... However, transactions were posted in mixed currency balances, since AA and CA account balances will not specify the originating currency (CRCD) unless the account has a currency code OR falls within a PBC account range in AAIs.

Discount Related - AAI Errors

Error ID: 2974 - "AAI Account for Discount Invalid"

CAUSE . . . . The Account Number associated with the Automatic Accounting Instruction (AAI) used to determine the journal entry account number for the Discount account is invalid.

RESOLUTION . Use the AAI Display program (P00121) to correct the Account Number associated with the Discount AAI. NOTE . . . . You may display the invalid AAIs that caused this error by using the "Referenced Program" facility (Option 2).

Error ID: 2972 - "AAI for Discount Account Invalid"

CAUSE . . . . The Automatic Accounting Instruction (AAI) used to determine the journal entry account number for the Discount account does not exist.

Logged Voucher Related - AAI Error

Error ID: 3986 - "AAI PQ Account Not Set Up"

Cause. . . . . The Automatic Accounting Instruction required for the Accounts Payable Suspense Trade Account is not set up.

Resolution . . The Suspense Account method used during the redistribution process has been activated at the company level. If you want to continue with the suspense method, then you must set up an AAI for a PQ account. If you do not want to used the suspense method, then you must turn off the suspense method flag for a particular company in the Company Constants file (F0010).

Multi Currency - AAI Errors

Error ID: 087B - "AAI Account for Alt. Gain/Loss Invalid"

CAUSE . . . . The Account Number associated with the Automatic Accounting Instruction (AAI) used to determine the journal entry account number for the Gain or Loss account for an Alternate Currency Payment or Receipt is invalid.

RESOLUTION . Use the AAI Display program (P00121) to correct the Account Number associated with the Gain AAI (PY,RY) or Loss AAI (PZ,RZ).

Error ID: 2975 - "AAI Account for Gain/Loss Invalid"

CAUSE . . . . The Account Number associated with the Automatic Accounting Instruction (AAI) used to determine the journal entry account number for the Gain or Loss account is invalid.

RESOLUTION . Use the AAI Display program (P00121) to correct the Account Number associated with the Gain AAI or Loss AAI. NOTE . . . . You may display the invalid AAIs that caused this error by using the "Referenced Program" facility (Option 2).

Error ID: 085H - "AAI Acct. for Alternate Currency Invalid"

CAUSE . . . . The Account Number associated with the Automatic Accounting Instruction (AAI) used to determine the journal entry account number for the Alternate Currency Clearing Account is invalid or is a monetary account.

RESOLUTION . Use the AAI Display program (P00121) to correct the Account Number associated with the Alternate Currency Clearing Account AAI.

Error ID: 087C - "Alt. Currency Gain/Loss AAIs Invalid"

CAUSE . . . . The Automatic Accounting Instructions (AAIs) used to determine the journal entry account numbers for the Gain/Loss for Alternate Currency Payments or Receipts do not exist. RESOLUTION . Add the missing AAIs through the Automatic Accounting Instructions program. The AAIs which need to be set up for Alternate Currency Gain/Loss are: PY - Realized Gain on Alternate Currency Payments PZ - Realized Loss on Alternate Currency Payments RY - Realized Gain on Alternate Currency Receipts RZ - Realized Loss on Alternate Currency Receipts

Error ID: 1130 - "Currency Gain/Loss AAI Account Invalid"

CAUSE . . . . If you are using foreign currency accounting, an Automatic Accounting Instruction (AAI) for currency gains and losses must be set up and it must be a valid account in the Account Master file. In Accounts Receivable, the AAIs are "RG " and "RL ". In Accounts Payable, the AAIs are "PG " and "PL ". These may be set up by company or just for the default '000' company.

RESOLUTION. . Review the setup of your Automatic Accounting Instructions for the items mentioned and add or change as required.

Error ID: 2973 - "Gain/Loss and/or Discount AAIs Invalid"

CAUSE . . . . The Automatic Accounting Instructions (AAIs) used to determine the journal entry account numbers for the Gain/Loss or Discount accounts do not exist.

RESOLUTION . Add the missing AAIs through the Automatic Accounting Instructions program. The AAIs which need to be set up for Gain/Loss and Discounts are: PG - Realized Gain on Foreign Currency Payments PL - Realized Loss on Foreign Currency Payments PKD - Discounts Available PKL - Discounts Lost NOTE . . . . You may display the invalid AAIs that caused this error by using the "Referenced Program" facility (Option 2).

Intercompany Settlements Related - AAI Errors

Error ID: 045K - "InterCo Settlement AAI Error"

CAUSE . . . . Your AAI for item &1 , company &2 (intercompany settlements) are not set up correctly.

RESOLUTION. . Verify that you have intercompany settlements setup correctly. If the Intercompany Settlement method is set to '1', you must have an 'ICH' AAI for company '00000'. If the Intercompany Settlement method is set to '1' , '2', or '3' you must have an 'ICCC' AAI set up for all account companies.

Error ID: 4662 - "InterCo Settlement AAI Error"

CAUSE . . . . Your AAI for intercompany settlements are not set up correctly.

RESOLUTION. . Verify that you have intercompany settlements setup correctly. If the Intercompany Settlement method is set to '1', you must have an 'ICH' AAI for company '00000'. If the Intercompany Settlement method is set to '1', '2', or '3' you must have an 'ICCC' AAI set up for all account companies.

Error ID: 470K - "InterCo Settlement AAI Error"

CAUSE . . . . Your AAI for item &1 , company &2 , (intercompany settlements) is not set up correctly.

RESOLUTION. . Verify that you have intercompany settlements setup correctly. If the Intercompany Settlement method is set to '1', you must have an 'ICH' AAI for company '00000'. If the Intercompany Settlement method is set to '1', '2', or '3', you must have an 'ICCC' AAI set up for all account companies.

General AAI Missing Errors

Error ID: 023Q - "AAI Missing"

CAUSE . . . . The &1 Automatic Accounting Instruction (AAI) for company &2 does not exist.

RESOLUTION . Add the missing AAI through the Automatic Accounting Instructions program. For OneWorld: If currency is on, the currency code will be evaluated, if passed. If Allow Multi-Currency Intercompany Transactions is on in the General Accounting Constants, then if the company currency code is different than company zero, and no AAI is set up for the company, the account for company zero will be used and no errors are set. If Allow Multi-Currency Intercompany Transactions is not on, if the company currency code is different than company zero, and no AAI is set up for the company, this error will be given.

Error ID: 023T - "AAI missing for a specific GL Offset"

CAUSE . . . . The &1 Automatic Accounting Instruction (AAI) for company &2 and GL Offset &3 does not exist.

RESOLUTION . Add the missing AAI through the Automatic Accounting Instructions program.

Error ID: 2507 - "AAI Invalid - Use Reference Pgm (F2)"

CAUSE . . . . The Automatic Accounting Instruction (AAI) used to determine the journal entry account number either does not exist or specifies an invalid account number.

RESOLUTION. . Add the missing AAI through the Automatic Accounting Instructions program or update the existing AAI to specify a valid account number. NOTE: You may display the invalid AAIs that caused this error by using the "Referenced Program" facility. Type the error ID (2507) in the "Reference #" field and press function key 2 (F2).

Error ID: 0237 - "AAI Not Found"

CAUSE . . . . The Automatic Accouting Instruction account number is not set up in the AAI file for either the discount taken, discount lost, adjustment reason or job closing.

RESOLUTION. . The accounts being validated are: A/R . . . . . . Adjustment Reason = 'RA + adjustment reason ' Discount Taken = 'RKD ' VAT Tax Account = 'PT + G/L Offset' A/P . . . . . . Discount Taken = 'PKD ' Discount Lost = 'PKL ' VAT Tax Account = 'RT + G/L Offset' Job Closing . . Prior Year End Balance in Closed Jobs Account = 'JCPB ' Job Revenue Account = 'JCR ' Job Costs Account = 'JCC ' Revenue Account = 'JCCA '

Error ID: 031T - "AAI Account Not Setup"

CAUSE . . . . The Automatic Accounting Instruction (AAI) does not exist in the Automatic Accounting Instruction Master file (F0012).

RESOLUTION. . Add the missing AAI through the Single AAI Revisions (P0012) or Multiple AAI Revisions (P00122) program.

Error ID: 1964 - "AAI Account Number Invalid"

CAUSE . . . . The account number specified with an Automatic Accounting Instruction (AAI) for this transaction does not exist in the Account Master file (F0901).

RESOLUTION. . Change the account number associated with the AAI for this transaction to specify a valid account number.