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:

1. Locates an unprocessed record from the F0018 table (an unprocessed record is one in which the Tax Processed Flag field (PROCFL) is not Y).

2. 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

3. Totals the records in the F0911 table.

4. Determines a relative percent for each F0911 record by dividing the amount of each account by the total amount.

5. Multiplies the relative percent by the tax amount in the F0018 table to determine the tax amount per account.

6. Performs an allocation for each tax rate/area and tax-explanation code combination.

7. 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.

8. Updates the F0018 record to processed (PROCFL field is Y).