Barbara,
Have you looked at the A/R summary aging report on the Onelist? The formulas
you need are going to be pretty close to the same. Here is what they are.
Current
IIF(DueDate >= TODAY(),InvoiceBal,0)
Pastinv
IIF(DueDate >= TODAY() - 30 And DueDate < TODAY(),InvoiceBal,0)
Over30inv
IIF(DueDate >= TODAY() - 60 And DueDate < TODAY() - 30,InvoiceBal,0)
Over60inv
IIF(DueDate >= TODAY() - 90 And DueDate < TODAY() - 60,InvoiceBal,0)
Over90inv
IIF(DueDate >= TODAY() - 120 And DueDate < TODAY() - 90,InvoiceBal,0)
Over120inv
IIF(DueDate < TODAY() - 120,InvoiceBal,0)
This is assuming you want to use the Due Date as opposed to invoice date. If
not replace DueDate with InvDate.
Hope this helps.
Jim Frice
Have you looked at the A/R summary aging report on the Onelist? The formulas
you need are going to be pretty close to the same. Here is what they are.
Current
IIF(DueDate >= TODAY(),InvoiceBal,0)
Pastinv
IIF(DueDate >= TODAY() - 30 And DueDate < TODAY(),InvoiceBal,0)
Over30inv
IIF(DueDate >= TODAY() - 60 And DueDate < TODAY() - 30,InvoiceBal,0)
Over60inv
IIF(DueDate >= TODAY() - 90 And DueDate < TODAY() - 60,InvoiceBal,0)
Over90inv
IIF(DueDate >= TODAY() - 120 And DueDate < TODAY() - 90,InvoiceBal,0)
Over120inv
IIF(DueDate < TODAY() - 120,InvoiceBal,0)
This is assuming you want to use the Due Date as opposed to invoice date. If
not replace DueDate with InvDate.
Hope this helps.
Jim Frice
> -----Original Message-----
> From: Barbara Grimes [mailto:bgrimes@...]
> Sent: Wednesday, September 13, 2000 3:28 PM
> To: Onelist (E-mail)
> Subject: [Vantage] Report Builder: how to set summarized A/P aging
> report?
>
> Does anyone know how to set up a summarized A/P aging report using date
> range formulas? If you do I'd appreciate a bit of advice.
> Please e-mail me
> at bgrimes@....
>
> Barbara grimes
> Knight Sign Industries, Inc.
> Tuscaloosa, AL
>