Complex Payment Term setup
I have a requirement where I have to setup the below logic in the Payment term. Can someone please help with this? I am not sure if this can be achieved using the standard Oracle Payment Term definition form.
NET 60..but if you make the payment early then the discount rate calculation is = number of days earlier than the actual due date * discount
e.g. Invoice amount is 100 and Invoice Date is 01-SEP-2012. So, due date is 30-OCT-2012. If I make the payment on 18-SEP-2012 then the discount rate is 42 * 0.002. The total discount amount is 42*0.002*100 = 8.4
Any help you could provide is appreciated.