Oracle-Developer.com Forums

[vj.jain]

Invoices with Tax or Freight

Oracle calculates the discount based on information in the invoice header. Note the Invoice Amount and the Discount Amount

If the Tax Amount on the Invoice Header is not being populated, then the discount will be based on the invoice amount only. Using tax accounts on the distribution is not considered by Oracle.

The discount is calculated using the following:
(Invoice Amount - Invoice Tax Amount) * Discount = (110 – 0) * 1% = 1.10

That is the standard functionality.


If you need the discount to exclude the tax from the discount calculation. For example, the discount calculation needs to be:
(Sum of Distribution Lines – Tax Distributions) * Discount

In order to accomplish this, we need to specify the discountable amount in the invoice header. If you do not see the Discountable Amount in the Invoice Header, from the toolbar, select Folder-Show Field and include this column.

Change the Discountable Amount as needed and save the Invoice. The discount is now being calculated as required.