Re: Queries

["Paul M" <paulm44@xxxxxxxxxxx>]

itembl or itemas would be the files


From: "Lance Mason" <lance@mgelectronic.com>
Reply-To: MAPICS-L@midrange.com
To: <MAPICS-L@midrange.com>
Subject: Queries
Date: Tue, 2 May 2000 10:30:13 -0400

Question about a query.  We want to count certain types of sales and have
set up the "Accounting Class" in Item Master and want to total each "Class"
of sales.  Can somebody tell me which file I can query that will have the
total sales of each "Class" at the end of each month.  We picked that field
since it was not being used for anything else.

Any help is appreciated.  Our programmer left us (He had the query working
where all we had to do was change the date range each month - but there
seems to be a problem this month) and our new guy is still learning Mapics
(He knows the AS400) - so he is not much help right now with queries.

Thanks-----

+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---