[RBG7-L] - RE: aging report

[Dawn Oakes]

Bryan, This is what I would suggest; it has worked for me in the past:   As Razzak suggested, create a view that calculates the number of days from the invoice date.  One of my views looks like this:   View: InvAging select invnum,Amount,InvDate,(.#date-invdate) as AgeDays from billhistory   In your report, create variables for each grouping by checking the AgeDays column and using the amount of the invoice:   vcurrent = (iflt(agedays,31,amount,0)) v3145 = (ifgt(agedays,30,(iflt(agedays,46,amount,0)),0))   etc. etc.    Create your column headings in the report and place the variables under the appropriate headings.  I always right-click on the variable and choose 'Blank when Zero'.  If not you'll end up with 0.00 values in each column that does not apply to that invoice.   My groupings are current (0-30 days), 31-45 days, 46-60 days and over 60.  But you can choose your own.   Hope this helps. Dawn   From: Bryan Bornstein [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 06, 2005 11:32 PM To: RBG7-L Mailing List Subject: [RBG7-L] - aging report Hello everyone, I am fairly new to R:Base, but I am very impressed so far. I am getting along pretty well so far, only I need to add an accounts receivable (A/R) aging report to my program. Is there a way to take the Date and invoice amount and "move" them over to an aging report(such as 0-15 days, 16-30, 31-45, 46-60, over 60)? Thank you in advance for any help offered.   Bryan B