Make sure you go through and edit out the Trade/Charity sections if you
don't need them.
Open up ISQL/w (in the Microsoft SQL Server 6.5 group).
Load the "Monthly Sales.sql" script into it.
Click on the green arrow or hit ^e
>Also is there a
>way I can tell who has sold or edited an account at anytime during a
working
>day and done what to the account ?
To some degree. The LastModifyUser and LastModifyDate are updated when
someone goes in and changes something via Emerald. If you simply modify
stuff using ISQL (and don't update the two above fields), then there's no
way to track it that I know of.
Josh
>----- Original Message -----
>From: Josh Hillman <admin-maillist@talstar.com>
>To: <emerald@iea-software.com>
>Sent: Friday, July 09, 1999 3:37 AM
>Subject: Re: [Emerald] Monthly sales report
>
>
>> From: Don Barron <don@world-link.com.au>
>> >does this script run as a report ?
>>
>> 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
>
>
>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