2 Replies Latest reply: Jan 19, 2017 8:30 AM by Виталий Чуприна RSS

    Open Receivables and Receivables Age

    Виталий Чуприна

      Hi,

       

      Did someone done such scenario:

      Open Receivables is defined as invoiced Sales less any payments. Open receivables

      does not trend over time as it is a point in time metric and only exists at the moment

      it is calculated. Open receivables should be displayed in 30-brackets depending upon

      how old the receivable is. Any receivable less than one day old is considered current

      and current is a bucket that must be displayed. The BILL and AMTPAID field

      should be used for this metric.

       

       

      I have a table with billing table and want to calculate open receivables, but didn't understand how I can do this and wich formula I should use

       

       

      MEDNOACCTNUMINVOICEBILLDATEAMTPAID
      14627AA5555216511/6/19960
      20514AA568971301/2/19970
      29102AA569701551/6/19970
      23955AA9700500553/18/19970