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

# accounts receivable aging

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

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