Revising Reconciled Transactions
If you revise transaction amounts or general ledger accounts, you must first post them to the F0018 table, and then rerun the Update Tax Reconciliation Repository program to update the F0018R table. When you post the revised transaction, the system creates a new record in the F0018 table for that pay item and increases the Line Number field by an increment of one. When you rerun the Update Tax Reconciliation Repository program, the system:
Locates unprocessed records from the F0018 table.
Locates processed records in the F0018 table that have the same key fields and removes the 1 from the PROCFL field so that all records can be considered for new tax calculations.
Deletes all records that have the same key fields from the F0018R table so that new relative percentages can be calculated.
Reruns the reconciliation process as described in steps 1-8.