I haven't had a chance to convert it into a report (Crystal Reports 6) yet.
Josh
>----- Original Message -----
>From: Josh Hillman <admin-maillist@talstar.com>
>To: <emerald@iea-software.com>
>Sent: Friday, July 09, 1999 2:58 AM
>Subject: Re: [Emerald] Monthly sales report
>
>
>> From: Webmaster <webmaster@elpasopaging.com>
>> >i am looking for a report that would tell you the sales done for that
>month
>> >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
oppinions
>> 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
>my
>> 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,
>but
>> 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
>displaying
>> 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.
>In
>> your case, you may need to simply remove the sections that deal with
them.
>>
>> Josh Hillman
>> hillman@talstar.com
>>
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart