Setting Up Automatic Accounting Instructions

You can create automatic accounting instructions (AAIs) for each unique combination of company and either billing code, adjustment reason code, or general ledger (GL) offset code. AAIs define which accounts the system uses to post entries to the General Ledger. Billing and GL offset codes are one to four characters and adjustment reason codes are only two characters.

You can also set up AAIs for default company 00000, if a specific AAI is not defined. Each AAI is associated with a GL account that consists of a business unit, object, and optionally, a subsidiary.

The following table lists the AAI items in the JD Edwards EnterpriseOne Real Estate Management system, the code type that is used with each AAI item, and a description of the associated account:

AAI

Code Type

Description of AAI

PM

Billing code

The revenue account for an invoice, which the system credits. You must set up this AAI for each bill code that you use. For example, PMRO identifies the revenue account for regular office rent, as specified by the billing code (RO).

PM

Tax code

The tax account for an invoice that is generated with taxes using tax explanation code AR. You must enter a GL offset in the tax rate area, and then set up the AAI using the GL offset that is specified. For example, if the tax rate area CO is set up with the GL offset TXTX, the system generates a journal entry for the tax amount and uses the account that is set up for AAI PMTXTX.

RC

GL offset

The receivables trade account, which the system debits. For example, RCRO identifies the receivables trade account for regular office rent, as specified by the GL offset code (RO).

RC

Tax offset

The offset for the tax amount if the tax explanation code is AR. You must set up the AAI using the GL offset that is entered for the tax explanation code.

RM

Billing code

The expense account for a voucher, which the system debits. You must set up this AAI for each bill code that you use. For example, RMRENT identifies the expense account for the rent payment that is related to a payable lease, as specified by the billing code (RENT).

RM

Tax code

The tax account for a voucher that is generated with taxes using tax explanation code AR. You must enter a GL offset for the tax rate area, and then set up the AAI using the GL offset that is specified. For example, if the tax rate area CO is set up with the GL offset TXTX, the system generates a journal entry for the tax amount and uses the account that is set up for AAI RMTXTX.

PC

GL offset

The payables trade account, which the system credits. For example, PCRENT identifies to the payables trade account for the rent payment that is related to a payable lease, as specified by the GL offset code (RENT).

PC

Tax offset

The offset for the tax amount if the tax explanation code is AR. You must set up the AAI using the GL offset that is entered for the tax explanation code.

RA

Adjustment code

The adjustment account for a receipt transaction, which the system either debits or credits, depending on how it is used.

For example, the system uses the RASI to identify the account to credit for interest that is earned on a security deposit; and RABD to identify the write-off account to debit for bad debt.