Re: [Emerald] Monthly sales report

Josh Hillman ( (no email) )
Thu, 8 Jul 1999 14:07:02 -0400

From: Don Barron <>
>does this script run as a report ?

I haven't had a chance to convert it into a report (Crystal Reports 6) yet.

>----- Original Message -----
>From: Josh Hillman <>
>To: <>
>Sent: Friday, July 09, 1999 2:58 AM
>Subject: Re: [Emerald] Monthly sales report
>> From: Webmaster <>
>> >i am looking for a report that would tell you the sales done for that
>> >and if possible the taxes on them
>> >so that we can complete our sales tax forms
>> This depends on how your bookkeeper/accountant defines a sale. Our
>> bookkeeper, accountant, general manager, and I all had differing
>> about how to correctly define this and the accountant has changed his own
>> views several times in the past about it. In other words, find out from
>> your bookkeeper/accountant the most precise definition possible for what
>> he/she wants to see at the end of every month. The one I use may not be
>> suitable for you.
>> We recently upgraded from Emerald 2.1 to 2.5, so I had to rewrite all of
>> accounting scripts (I never got a chance to convert them into Crystal
>> Reports layout). None of them include taxes, because we don't use them,
>> you could probably add them to the scripts without too much effort.
>> Anyway, the script I attached to this message is what I wrote for
>> sales (via ISQL/w). Because we have two special billing groups called
>> "Trade" and "Charity" that need to be "separated" from all other normal
>> paying billing groups, I had to make exceptions for them in the script.
>> your case, you may need to simply remove the sections that deal with
>> Josh Hillman
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: