Understanding the Process to Update the Tax Reconciliation Repository

If you are using the track taxes by tax rate/area method, you must run the Update Tax Reconciliation Repository (R0018R) program after you post vouchers and invoices and update the Taxes (F0018) table. The system allocates tax amounts to the taxable general ledger accounts that were used to distribute voucher and invoice transactions, as well as any journal entries with valued-added tax (VAT).

The system stores these tax amounts in the Tax Reconciliation Repository (F0018R) table for reporting purposes.

Important: Do not use data selection to update records to the F0018R table. Instead, use the processing options for the Update Tax Reconciliation Repository program.