Re: [Emerald] SQL Querry Assistance

Dale E. Reed Jr. ( (no email) )
Thu, 04 Mar 1999 12:03:33 -0800

Michael Whisenant wrote:
>
> I am trying to isolate a beginning AR balance as of a given date. To
> accomplish this I have the intital querry that is:

Are you trying to find your AR balance, or unpaid invoices?

The AR Balance would simply be the sum of the payments for that month.
However, you might want to look at the defrev reoprt to see a more
laid out report for AR and deferred AR.

-- 

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html