Understanding Multicurrency Fields Updated During Receipt and Draft Entry
When you enter a foreign currency receipt or draft or an alternate currency receipt, the system populates one or more fields in one or more tables with the short account ID of the account associated with the AAI items involved. The system uses these account IDs to create automatic entries when you post receipts and drafts.
The fields populated during receipt and draft entry are the same with two exceptions. For draft entry, the system does not populate:
The GL bank account.
The field for this account does not display during draft entry
The alternate currency realized gain/loss accounts and amounts and clearing accounts and amounts.
Drafts are not processed in alternate currencies; they are processed only in domestic and foreign currencies.
By understanding how the system updates the fields, you can better understand the automatic entries that the system generates during the post. This table shows the fields and tables that are updated based on the AAI that is used:
Account |
Field Updated |
Table Updated |
AAI Item Used |
Additional Comments |
|---|---|---|---|---|
General Ledger Bank |
GLBA |
F03B13 |
RB |
If the account associated with the AAI item RB that the system uses is a monetary account, the currency of the account must be the same as the transaction currency of the receipt. |
Accounts Receivable Trade |
AID |
F03B14 |
RC |
The system always uses the account ID of the AID field from the F03B11 invoice record that the receipt pays. Otherwise, the accounts receivable trade account used for the invoice would not be offset by the receipt. |
Foreign Currency Realized Gain |
AIDT |
F03B14 |
RG |
None. |
Foreign Currency Realized Loss |
AIDT |
F03B14 |
RL |
None. |
Alternate Currency Realized Gain |
AIDA |
F03B14 |
RY |
None. |
Alternate Currency Realized Loss |
AIDA |
F03B14 |
RZ |
None. |
Accounts Receivable Trade for Chargebacks |
AID AIDC |
F03B11 F03B14 |
RC |
If you know the invoice number to which the chargeback applies, the system creates the chargeback record in the currency of the invoice to which it applies. If you do not know the invoice number to which the chargeback applies, you can create a stand-alone chargeback for one or more invoices. When you enter the stand-alone chargeback for multiple invoices, the system creates the chargeback records in the receipt currency. |
Deduction Suspense |
AID DAID |
F03B11 F03B14 |
RN |
If you know the invoice number to which the deduction applies, the system creates the deduction record in the currency of the invoice to which it applies. If you do not know the invoice number to which the deduction applies, you can create a stand-alone deduction for one or more invoices. When you enter the stand-alone deduction for multiple invoices, the system creates the deduction records in the receipt currency. |
Rounding Differences |
RASI |
F03B14 |
R8 |
The system assigns document type RR to a receipt record in the Receipts Detail table (F03B14) when the receipt is either fully applied on the foreign side but not fully applied on the domestic side, or fully unapplied on the foreign side but not fully unapplied on the domestic side. This rounding record is at the receipt level and is not associated with any particular invoice line. |