0 Replies Latest reply: Jan 31, 2018 12:44 PM by Hans kleijnen RSS

    cash collection prognoses

    Hans kleijnen

      Hi all,

       

      I need to create an overview in which:

      1. all payments received in the reporting month are listed in one column

      2. expected future payments in monthly columns

       

      Invoicenumberpaid 2018-01 (reporting month)2018-022018-03etcetc

       

      Please see attached file

       

      The reasoning is to allocate a (future) payment to a column by defining an additional date. The logic could be something like

      IF(Pay_date<>0 than Pay_date = Payment_Date,

            Elseif(Rep_Date>Due_date than Rep_Date+45= Payment_date ;

                 Else (Due_date+15= Payment_date)

       

      How should I do this?