[RBG7-L] - Re: aging report

[jan johansen]

Bryan,

 

I may be speaking out of turn and someone can correct me.

I have not done this yet but it seems to me an aging report would be a good candidate for

CROSS-TAB available in the Reports Designer.

 

Jan 

-----Original Message-----
From: "Jan Barley" <[EMAIL PROTECTED]>
To: rbg7-l@rbase.com (RBG7-L Mailing List)
Date: Wed, 7 Sep 2005 08:49:32 -0400
Subject: [RBG7-L] - Re: aging report

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