Invoice Distributions
When I query the distributions for an invoice in R12 using the form I get amount total 2751.75 (record count 349).
When I query the same invoice on the AP_INVOICE_DISTRIBUTIONS_ALL table I get amount total of 2480.50 (record count 215).
The missing records seems to be some tax lines. The AP_INVOICE_DISTRIBUTIONS_ALL table does contain some tax lines. The difference in the amounts is not the tax figure.
When I check the last query run it uses the AP_INVOICE_DISTRIBUTIONS_V view which doesn't show all the records.
How do I get to the records that the distributions form is showing? Can someone please clarify?
Tagged:
0