Symptoms

• A Project Accounting draft invoice item has incorrect billing amounts across multiple amount fields.
• The amount, inv_amount, acct_amount, and related functional/project currency amounts on PA_DRAFT_INVOICE_ITEMS_ALL do not match the expected billing amount.
• Rounding amounts (rounding_amount, unbilled_rounding_amount, unearned_rounding_amount) are non-zero when they should be zero.
• The unbilled_receivable_dr value is incorrect.
• Revenue recognition or customer billing reports show discrepancies for the affected project.

Root Cause

The draft invoice item amounts in PA_DRAFT_INVOICE_ITEMS_ALL were incorrectly calculated or overridden, resulting in mismatched values across the billing amount, functional currency amount, project currency amount, and funding currency amount fields. Rounding fields were populated with non-zero values that should be zero. The fix corrects all affected amount columns to the proper billing value.

Resolution

Run data_fix.sql. The script creates a backup of the affected draft invoice item row:

CREATE TABLE rsi_pa_draft_inv_items AS
SELECT * FROM pa_draft_invoice_items_all
 WHERE project_id = <project_id>
   AND draft_invoice_num = <invoice_num>
   AND line_num = <line_num>;

Update PA_DRAFT_INVOICE_ITEMS_ALL for the affected project/invoice/line combination to set:

• amount — correct billing amount
• unbilled_receivable_dr — correct unbilled DR (negative of billing amount)
• inv_amount — invoice amount
• acct_amount — accounted amount
• rounding_amount = 0
• unbilled_rounding_amount = 0
• unearned_rounding_amount = 0
• projfunc_bill_amount, funding_bill_amount, project_bill_amount, bill_trans_bill_amount

Issue COMMIT. Verify the draft invoice now shows the correct amounts and can be approved and transferred to AR.

Script Inventory

Key Tables Affected