Reconciling Tax Amounts by GL Account
The Update Tax Reconciliation Repository program uses this process to reconcile tax amounts by GL account and update the F0018R table:
Locates an unprocessed record from the F0018 table (an unprocessed record is one in which the Tax Processed Flag field (PROCFL) is not Y).
Uses these key fields in the order specified to locate the corresponding taxable records in the Account Ledger (F0911) table:
Document number
Document type
Document company
GL date
Tax rate/area
Tax explanation code
Tax item number
Totals the records in the F0911 table.
Determines a relative percent for each F0911 record by dividing the amount of each account by the total amount.
Multiplies the relative percent by the tax amount in the F0018 table to determine the tax amount per account.
Performs an allocation for each tax rate/area and tax-explanation code combination.
Creates records in the F0018R table.
Note: Although the system writes tax amounts to both the AA and CA ledgers in the F0911 table, it updates only AA amounts to table F0018R.Updates the F0018 record to processed (PROCFL field is Y).