1 Reply Latest reply on Jan 24, 2013 2:39 AM by comment

    Calculating potential discount from invoice terms.

    b.weaver

      Hi all,

       

      I'm looking for an elegant solution to calculate the potential discount for an invoice, based on the terms of invoice.

       

      I have a list of terms which has a discount percent, along with the net days to pay. Company pays within that time, they get the discount.

       

      So, this list looks something like:

       

      Net 10

      Net 20

      -

      1% 10 Net 30

      2% 10 Net 20

      3% 10 Net 10

      -

      15% 30

       

       

      I'm envisioning a Terms/Discount table where the properties of each term are stored and the value list is made up of the available terms (2nd field, calculated descripiton). When the invoice is created or the terms are changed, then the individual "parts" of the terms can be looked up and applied to the invoice.

       

      ...or should I just keep the value list as is and use if statements in a script to calculate the discount?

       

       

      Thanks for the look!

       

      - Brian