RE: [Emerald] project for the day

Ronnie Franklin ( (no email) )
Mon, 7 Feb 2000 17:17:26 -0600

That is an interesting report and store proc... I will study it...

However, it looks like it is incorrect as those who are just due this month
are showing up in the over 90 column and those who were due last month in
the over 60 column and etc....

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Monday, February 07, 2000 4:16 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] project for the day
>
>
> Ronnie Franklin wrote:
> >
> > I have spent several hours trying to match payments to invoices
> and come up
> > with a report... surely there is a way to link the payments table and
> > invoices table in such a fashion to come up with a report!!
>
> Its called an aging report. :) Check out the aging.sql
> in the aging.zip report. It might give you some insight on it,
> just the reverse order.

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart