Report Builder: how to set summarized A/P aging repor

Yahoo Archive
1
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
> -----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
>
2
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
3
At 04:28 PM 9/13/2000 , you wrote:
>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

There's one uploaded to EGroups that is a good starting point. You might
want to change it to use InvoiceBal instead of InvoiceAmt. One version
that was floating around the list also had a total erroneously summing
VendorNum instead of InvoiceAmt.

-Wayne Cox