Ap Invoice distribution lines seen in the invoice screen does not exist in the AP_INVOICE_DISTRIBUTI
Hi All,
I have an invoice in Status : Needs Revalidation and Accounted : No. There is a hold due to the invoice lines total does not match the distribution total.
We could see that for invoice line 2, there are 14 dist lines in the invoice distribution screen
line total = 822.65
distribution total = -3797.35
But when I run APlist or when I run select query on ap_invoice_distributions_all table with the invoice id, it fetches 12 dist lines only for invoice line 2.
Due to these extra 2 distribution lines (which I could not find in the backend) I am not able to datafix to tally the invoice line and distribution total and proceed to revalidate, account and then cancel the invoice.