Invoice has a higher AMOUNT_PAID value than INVOICE_AMOUNT value
Hi All,
We have an Invoice (Invoice X) that has a Different Amounts in the Columns "Amount Paid" (AP_INVOICES_ALL.AMOUNT_PAID) and "Invoice Amount"(AP_INVOICES_ALL.INVOICE_AMOUNT). AMOUNT_PAID has a value of $639.75 and the INVOICE_AMOUNT has a value of $630.84.
Upon checking in the Distributions, the Sum is the same as the Invoice_amount ($630.84)
select sum(amount) FROM AP_INVOICE_DISTRIBUTIONS_ALL where invoice_id = XXXX;
The Invoice Headers were created at around, 8:00 AM and most of the invoice distributions also showed a CREATION_DATE same as the header.
Upon further checking, it has a distribution value of
1