Oracle-Developer.com Forums

[vj.jain]

If you are trying to exclude freight from AP invoices with discount payment terms on imported invoices, then this Metalink Note will be helpful:


User wants to avail the advantage of Exclude Freight From Discount, but since
he is importing data from Open Interface and as there is not field in the Open
Interface tables to update Freight field in the ap_invoices_all, the discount
is getting calculated by the system on amount including freight and not
excluding.

No field in the Open Interface table ap_invoices_interface to store the Freight
details

The freight amount in the invoice header (ap_invoices_all) is for some other
purpose. If you want system to generate the freight distributions automatically
then you need to enter the amount there and need to have the Automatically
create freight distribution enabled. This will create the distributions for you
having line type as freight.

There is one more option called Exclude Freight From Discount. If this
option is enabled for an invoice, Payables automatically subtracts the freight
amount from the invoice amount when calculating the invoice amount subject to
discount. Payables uses the Discountable Amount on an invoice to calculate the
discount amounts when creating a scheduled payment for an invoice.

Enhancement request 770414 is already logged for this issue but it is not yet
incorporated into the intended functionality of the application.

The work around to this issue is that System calculates the discount on the
discountable amount field in the invoice header, which is the reflected in the
ap_invoices_interface by amount_applicable_to_discount field. This field is
also displayed in the invoice gateway. Hence while uploading data into
interface tables also update the AMOUNT_APPLICABLE_TO_DISCOUNT field and then
upload the same to ap_invoices_all. This will provide figure to system to
calculate discount on the right figure which you want after freight deduction.