E1: 03B: Paid Invoices with Not Null Open Amount Were Found in F03B11 (Customer Ledger) (Doc ID 2831849.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

One or more paid invoices which have an open amount have been identified in F03B11 (Customer Ledger) table.

Steps to replicate:

1. Open Databrowser for F03B11 table
2. Search for the invoice line(s) with Open Amount > 0 but with Paid Status "P" (Paid)
3. Double check for any associated receipts with the invoice in F03B14 (Receipts Detail) table using Doc (Document Number)= invoice number. Make sure payment amounts for the invoice equals Gross Amount plus/minus write offs.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.