Symptoms

• AP accounting journal entry lines show incorrect debit or credit amounts that do not match the invoice totals.
• The entered and accounted DR/CR amounts in AP_AE_LINES_ALL are out of balance, causing downstream GL reconciliation issues.
• Reports such as the AP Trial Balance or Posted Invoice Register reflect the incorrect amounts.

Root Cause

The accounting entry line records in AP_AE_LINES_ALL were created with incorrect entered_dr, accounted_dr, entered_cr, and accounted_cr values, typically due to a rounding error, a manual override, or a system calculation failure during the accounting run. The debit line and its corresponding credit line both contained wrong amounts that needed direct correction.

Resolution

Run data_fix.sql. The script first creates a backup of the affected rows:

CREATE TABLE rsi_ap_ae_lines_<case> AS
SELECT * FROM ap_ae_lines_all
 WHERE ae_line_id IN (<debit_line_id>, <credit_line_id>);

A SELECT on the backup table confirms 2 rows were captured before any modifications.

Set entered_dr and accounted_dr to the correct amount on the debit AE line.

Set entered_cr and accounted_cr to the correct amount on the credit AE line.

Issue COMMIT. Verify the GL balance and AP reports now reflect the corrected amounts.

Script Inventory

Key Tables Affected