JD Edwards Traditional Automatic Accounting Instructions

JD Edwards uses a set of rules called automatic accounting instructions to determine how transactions will be posted to the general ledger, accounts receivable and/or accounts payable systems. These instructions are referred to as AAI's.

The AAI item UCXXXX defines the default offset accounts used when credit card payments are posted to accounts receivable. The ‘XXXX’ code is set up in the user defined codes table (00/CA) and represents the credit card type such as VISA for Visa.

The AAIs are read in a hierarchical order. This order allows the system to locate the proper account number to post the transaction to.  For example, if you enter a Visa credit card payment for company 00001 the system uses the following hierarchy to locate the credit card payment offset account:

The system searches for AAI item UCVISA for company 00001.  If that combination is found the specified offset will be used during posting. However, if the system cannot locate this AAI item it will then search for item UCVISA for company 00000. If found the specified offset will be used during posting.  However, if the system cannot locate the AAI using this combination it will then search for item UC for company 00000. If found the specified offset will be used during posting. If the system still cannot locate an AAI item matching this combination it will return an error message that the AAI is missing.  The AAI will need to be added before the transaction can post.

Extended AAI

As you note above JDE AAIs only differentiate by Item Number and Company.  SmarterCommerce extended AAI functionality gives your organization more flexibility by allowing you to setup posting accounts based on Sales Order Header Branch Plant, SmarterCommerce Point of Sale Register ID and Drawer Number. To setup extended AAI posting information follow the steps outlined below:

Step 1

Step 3

When a payment processes the Extended AAI setup table will be evaluated.  First, the system checks for the most detailed match (ie: Company, Item Number, Header Business Unit, Register and Drawer Number), if a match is found the account code information defined will be used. If a match is not found then the system will check for a less detailed match (ie: Company, Item Number, Header Business Unit with Register and Drawer Number blank), if a match is found the account code information defined will be used.  If a match is not found then the system uses the traditional JDE AAIs described above for posting.