1 Reply Latest reply: May 15, 2014 5:06 PM by Olga Avramenko RSS

    accounts receivable aging

    Olga Avramenko

      Hi,

       

      Can anyone please help me to figure out how to calculate accounts receivable aging using set analysis?

      I am using the following syntax but it is not working.

      =Sum({<isAccountInvoiced={'1'},rDate = {">=$(=Date(max(rDate)-121)<=$(=Date(max(rDate)-150)"} >}Sales - Costs)


      where


      isAccountInvoiced={'1'} -  selects all accounts invoiced (all accounts invoiced have a value of 1)

      rDate - is the date MM/DD/YYYY

      rDate = {">=$(=Date(max(rDate)-121)<=$(=Date(max(rDate)-150)"} - syntax used for accounts receivable age between 121-150 days


      Thank you


       

       

       

       

       

        • Re: accounts receivable aging
          Olga Avramenko

          The following syntax can be used to calculate accounts receivable aging

          1-30 days

          =Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-1)<=$(=DateMax(rDate)-30)"} >}Sales - AmountPaid)

          31-60 days

          =Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-31)<=$(=DateMax(rDate)-60)"} >}Sales - AmountPaid)

          91-120

          =Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-91)<=$(=DateMax(rDate)-120)"} >}Sales - AmountPaid)

          121-150 days

          =Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-121)<=$(=DateMax(rDate)-150)"} >}Sales - AmountPaid)


          I used DateMax(rDate) instead of Date(Max(rDate)) and it worked