The function amount in AP header is round into 2 decimals (round(ap_invoices_all.invoice_amount*exchange_rate,2)), however line functional amount in AP lines are rounded every lines(round(ap_invoice_lines_all.amount*exchange_rate,2)).
This may cause the difference(rounding_amt) between header functional amount and SUM(line functional amount). Standard function round the difference from the functional amount AP line order by base_amount descend.
Column base_amount stores the functional amount and column rounding_amt keep the difference.
This may cause the difference(rounding_amt) between header functional amount and SUM(line functional amount). Standard function round the difference from the functional amount AP line order by base_amount descend.
Column base_amount stores the functional amount and column rounding_amt keep the difference.
Program path:APXIIMPT -> AP_IMPORT_INVOICES_PKG.IMPORT_INVOICES ->
AP_IMPORT_UTILITIES_PKG.Create_Lines -> AP_INVOICES_UTILITY_PKG.round_base_amts
Figure 1
Figure 2