8 Replies Latest reply: Aug 17, 2011 8:44 AM by Kaushik Solanki RSS

    Adding in Date

      Dear All,

       

      I need to know how to get payment due date based on invoice date and payment terms.

       

      Please check below table.

       

      Invoice NO

      Payment Term

      Invoice Date

      5702021

      90 Days Month End

      10/05/2011

      5702022

      60 Days Month End

      20/05/2011

      5702023

      90 Days Month End

      25/05/2011

      5702024

      30 Days Month End

      05/06/2011

      5702025

      30 Days Month End

      10/06/2011

      5702026

      90 Days Month End

      18/06/2011

      5702027

      60 Days Month End

      20/07/2011

      5702028

      60 Days Month End

      25/07/2011

      5702029

      120 Days Month End

      28/07/2011

      5702030

      30 Days Month End

      15/08/2011

       

      Let me explain Payment Terms first.

       

      If payment term is 30 Days Month End, due date can be calculated as below.

      Invoice Date = 05/01/2011

      Due Date = month end of invoice date (i.e. 31/01/2011) + add one full month

      So the Due Date = 28/02/2011 (i.e. end of February)

       

      If payment term is 60 Days Month End,

      Due Date = month end of invoice date + add two full months and so on.... (for above example : Due Date for 60 Days Month End is 31/03/2011)

       

      Kindly give me an expression to get due date against each invoice number.