Feasibility of calculating the Term discount on Invoice excluding the SO discount applied on AR

Summary: Feasibility of calculating the Term discount on Invoice Amount excluding the discount line interfaced in AR Invoice lines from Sales Order

Content (required):

Hello Team,

We have a business requirement wherein user want Oracle to calculate terms discount (early payment discount) on invoice amount excluding the discount line in invoice lines.

For example: If Invoice line has item line of $10,000 and discount line of $300 (in negative) coming from Order Management, which makes Total Invoice amount equal to $9700 with payment terms lets say 4/10, Net 30, so if the payment is made by customer within 10 days, Oracle is currently calculating 4% discount on $9700, however business expectation is to calculate 4% discount on $10,000.