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

Note: The system updates this 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.

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:

  • RB for the company entered on the receipt

  • RB for company 00000

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:

  • RCxxxx for the company entered on the receipt or draft

  • RCxxxx for company 00000

  • RCUC for the company entered on the receipt or draft

  • RCUC for company 00000

A/R Trade

Payment that generates a chargeback

11 and 16

AIDC and AID

F03B11 and F03B14

The system locates the account using this hierarchy, where xxxx is the value of the Chargeback G/L Offset field:

  • RCxxxx for the company entered on the invoice

  • RCxxxx for company 00000

  • RC for the company entered on the invoice

  • RC for company 00000

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:

  • RCxxxx for the company entered on the receipt or draft

  • RCxxxx for company 00000

  • RC for the company entered on the receipt or draft

  • RC for company 00000

Discount Taken

Payment with a discount

10

AIDD

F03B14

The system uses this hierarchy, where xx is the discount reason code:

  • RKDxx for the company entered on the receipt or draft

  • RKDxx for company 00000

  • RKD for the company entered on the receipt or draft

  • RKD for company 00000

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:

  • RA xx for the company entered on the invoice

  • RA xx for company 00000

Write-off

Stand-alone write-off

25

AIDW

F03B14

The system uses this hierarchy, where xx is the write-off reason code:

  • RA xx for the company entered on the receipt or draft

  • RA xx for company 00000

Deduction Suspense

Payment with a deduction

17

DAID

F03B14

The system uses this hierarchy:

  • RN that is set up for the company entered on the invoice

  • RN for company 00000

Deduction Suspense

Stand-alone deduction

27

DAID

F03B14

The system uses this hierarchy:

  • RN that is set up for the company entered on the receipt or draft

  • RN for company 00000

This table shows how the system updates the AID2 field on 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