• Subject: Re: Queries
  • From: "Paul M" <paulm44@xxxxxxxxxxx>
  • Date: Wed, 03 May 2000 05:22:59 CDT

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
+---


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].