Automatic Accounting Instructions
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.
Read Next
This Section Also Contains
- Credit Card Prepayment Information Flow
- Credit Card Prepayment Flow
- Credit Card Prepayment Setup
- Entering Sales Orders
- Updating Credit Card Prepayment Information - PQ670041
- Clearing Multiple Accounts Receivable Invoices with Credit Card Payment - PQ670042
- Uploading Customer Credit Cards on File - PQ670043
- Work with Future Dated Receipts - PQ670313
- Auto Invoice Payment Rules - PQ670315
- Authorize by Message Status Application - PQ674236
- Pay Invoice by Message Status - PQ674237
- Work with Companies by Store - PQ679912
- Credit Cards on File - PQ67CCIF
- Apply AutoPay Rules - RQ670315
- Surcharge Errors - PQ67SUER
- Batch Authorization of Credit Card Transactions - RQ6704201
- Settling Credit Card Transactions - RQ6704202
- Recording Settled Credit Card Transactions into Financial System - RQ6704203
- Credit Card Prepayment Analysis Report - RQ6704204
- Authorized Credit Card Expiring Report - RQ6704205
- Clearing Sensitive Card Holder Information - RQ6704208
- Credit Card AR Settlement Report - RQ6704209
- Deposit Settlement Report - RQ6704210
- Renew Credit Card on File - RQ6704212
- Credit Card Reconciliation - RQ6704213 & RQ6704214
- Credit Card Surcharge Fee Batch Report - RQ6704215
- Authorize by Email Automated Process - RQ6704216
- Create Invoice Payment by Email Process - RQ6704217
- Pay Invoice by Email Process - RQ6704218
- Update JDE Payments to PayCloud - Email Payment Document - RQ6704219
- Change Invoice Email Status to Expired - RQ6704220
- Credit Card Future Payments Process - RQ670429F
- Import Credit Card on File Information from Cloud - RQ67CCIF