Symptoms

• Multiple fully paid AP invoices continue to appear on the AP Trial Balance with non-zero balances.
• The invoice and payment accounting entries in AP_AE_LINES_ALL and AP_LIABILITY_BALANCE reference different code_combination_id values for the liability account, causing the net balance to not clear to zero.
• The invoice was booked to one liability account CCID, and the payment was recorded against a different CCID, resulting in a permanent mismatch on the Trial Balance.

Root Cause

The AP liability balance table (AP_LIABILITY_BALANCE) and accounting entry lines (AP_AE_LINES_ALL) for the payment side of multiple affected invoices contain a different code_combination_id than the corresponding invoice liability lines. This account mismatch prevents the Trial Balance from netting the invoice and payment to zero. The fix consolidates all affected liability balance and AE line records to use the invoice's credited account as the correct CCID. This is a follow-on case to the same pattern addressed in case 00088203.

Resolution

Populate RSI_AP_BAL_TMP_126977 with the affected invoice IDs, their current account balances, and CCID values before running the fix script.

Run data_fix.sql. For each affected invoice, the script determines the correct target CCID from the credited account in the driver table, then:

1. Backs up the affected AP_AE_LINES_ALL and AP_LIABILITY_BALANCE records.
2. Updates AP_LIABILITY_BALANCE.code_combination_id to the target CCID for all payment-side balance rows with the incorrect account.
3. Updates AP_AE_LINES_ALL.code_combination_id to the target CCID for the corresponding AE lines.
4. Optionally inserts GL Interface adjustment entries to document the reclassification in GL (if GL transfer is required).

The script commits after each invoice and prints a summary of successful and failed records. Errors are logged to rsi_ap_tb_recon_126977. Verify the affected invoices no longer appear on the AP Trial Balance.

Script Inventory

Key Tables Affected