Understanding Fields Updated During Receipt or Draft Entry
When you enter a receipt, the system updates specific fields with the account ID. The system locates the AAI based on the how the receipt is applied to invoices. The system uses this account ID when you post the receipt to create automatic entries. This table lists the fields that the system updates based on the type of receipt, and the AAI that the system uses to locate the account.
Account |
Type of Payment Application |
Type Input Code |
Field Updated |
Table Updated |
AAI Used |
---|---|---|---|---|---|
Bank Account |
All |
N/A |
GLBA |
F03B13 |
The system uses the bank account number entered on the receipt. If the Bank Account field is blank, the system locates the account based on this hierarchy:
Note: The system updates the bank account field when you enter a receipt; however, it does not update the bank account field on the draft until you either remit or collect the draft. |
A/R Trade |
Applied payment |
10 |
AID |
F03B14 |
The system does not use an AAI. The system uses the account entered in the AID field of the invoice record in the F03B11 table. |
A/R Trade |
Unapplied payment |
N/A |
AID |
F03B13 |
The system locates the account using this hierarchy, where xxxx is the value of the Unapplied G/L Offset field:
|
A/R Trade |
Payment that generates a chargeback |
11 and 16 |
AIDC and AID |
F03B14 and F03B11 |
The system locates the account using this hierarchy, where xxxx is the value of the Chargeback G/L Offset field:
|
A/R Trade |
Stand-alone chargeback |
26 |
AIDC |
F03B14 |
The system locates the account using this hierarchy, where xxxx is the value of the Chargeback G/L Offset field:
|
Discount Taken |
Payment with a discount |
10 |
AIDD |
F03B14 |
The system uses this hierarchy, where xx is the discount reason code:
|
Write-off |
Payment with a write-off |
10 and 15 |
AIDW |
F03B14 |
The system uses this hierarchy, where xx is the write-off reason code:
|
Write-off |
Stand-alone write-off |
25 |
AIDW |
F03B14 |
The system uses this hierarchy, where xx is the write-off reason code:
|
Deduction Suspense |
Payment with a deduction |
17 |
DAID |
F03B14 |
The system uses this hierarchy:
|
Deduction Suspense |
Stand-alone deduction |
27 |
DAID |
F03B14 |
The system uses this hierarchy:
|
This table shows how the system updates the AID2 field of the records in the F03B14 table when you accept, remit, or collect a draft. The system creates the records during each draft stage based on the AAI listed, where x is the payment instrument.
Draft Stage |
AAI |
---|---|
Acceptance |
RD1x |
Remittance |
RD2x |
Remittance for Discount |
RD3x |
Remittance with Contingent Liability |
RD4x |