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

    accounts receivable aging



      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)


      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

          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)


          =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