Understanding Accounts Payable AAIs

Each time you enter a transaction for which the system must create journal entries, the system must locate the appropriate account numbers. It does this by reviewing the AAI tables that correspond to the transaction. In the JD Edwards EnterpriseOne Accounts Payable system, for example, if you enter a voucher, the system locates the item that contains account numbers for AP trade accounts.

The name of an AAI item, such as PC, is hard-coded. AAI items for the JD Edwards EnterpriseOne Accounts Payable system always start with the letter P. For example, PC is the AAI item for payables class (trade account) and PB is the AAI item for payables bank. Each AAI item has account codes consisting of a business unit, object, and subsidiary, which are mapped to the chart of accounts. If you decide not to include a business unit for an AAI, the business unit of the voucher is used as part of the specified account number.

Some AAIs require that you define a complete range, consisting of a beginning and an ending AAI item. For example, for item PX (used for 1099 processing), the first range must begin with PXyy01. You must end the first range with PXyy02, the next consecutive number. Define the next range, if needed, to start with PXyy03 and end with PXyy04, and so on.

Each AAI has a hierarchical order in which the system searches for an account number. For example, if you enter a voucher for company 00100 and GL offset code 30, the system determines which AP trade account to use based on this search hierarchy:

  • The system searches for AAI item PC30 for company 00100 to locate the AP trade account.

  • If the system cannot locate this AAI item, the system searches for item PC30 for company 00000.

  • If the system cannot locate this AAI item, the system returns an error message that the AAI is missing.

The following subsections describe the AAIs used in the JD Edwards EnterpriseOne Accounts Payable system.