[RBG7-L] - Re: aging report

[Jan Barley]

Bryan, At last, there's something on this list that I can help with!  I run an aging report by customer.  My breakdown is Current, 31-60, 61-90, 91-120, and Over 120 Days.  I created a report that first allows the user to define the ending date for the report.  These variables are calculated on the Detail:           (first, define ending date for the report) = .vpe         vage = (.vpe-idate)         viamt = iamt           v1 = (iflt(vage,31,(.v1+.viamt),.v1))         v2 = (iflt(vage,61,(ifgt(vage,30,(.v2+.viamt),.v2)),.v2))         v3 = (iflt(vage,91,(ifgt(vage,60,(.v3+.viamt),.v3)),.v3))         v4 = (iflt(vage,121,(ifgt(vage,90,(.v4+.viamt),.v4)),.v4))         v5 = (ifgt(vage,120,(.v5+.viamt),.v5))         v6 = sum of viamt   Next, I convert the invoice values to a text field to suppress all zeros.  These variables are calculated on the F1 break:           vt1 = (ifeq(.v1,0,' ',(ctxt(.v1))))         vt2 = (ifeq(.v2,0,' ',(ctxt(.v2))))         vt3 = (ifeq(.v3,0,' ',(ctxt(.v3))))         vt4 = (ifeq(.v4,0,' ',(ctxt(.v4))))         vt5 = (ifeq(.v5,0,' ',(ctxt(.v5))))         vt6 = (ifeq(.v6,0,' ',(ctxt(.v6))))   Break 1 on the report is set to the customer ID. My report layout looks like this:                                                   Current        31-60        61-90        91-120        Over 120        Total (F1)Customer Name                        vt1            vt2            vt3            vt4                vt5                vt6                  (I also calculate totals by aging and print that on the RF section)   I hope this helps you!   Jan Barley                                 ----- Original Message ----- From: Bryan Bornstein To: RBG7-L Mailing List Sent: Tuesday, September 06, 2005 11:32 PM 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