Re: [Emerald] Monthly sales report

Don Barron ( (no email) )
Fri, 9 Jul 1999 03:38:57 +0930

How do I run it so it tell me what we've sold for the month. 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 ?

----------------------------------------
Don Barron
Network Administrator
World-Link Internet

Ph: (08) 8231 0999
Fax: (08) 8212 8805

don@world-link.com.au
http://www.world-link.com.au
----------------------------------------
----- 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