|
midrange.com
Item accounting class code (ITACIM) is in the ITEMASA (or ITMRVA) record.
Do you have the MTHACT (Monthly Activity Reporting) enhancement from
MAPICS? It's a great tool to pull reports like what it sounds like you are
doing. You get records in 3 files for invoices that you can easily query
for reporting of sales. TONS easier than going through all the COM
"normalized" database files. (What academic genius came up with the name
"normalized" for that sort of database design? It's anything but normal to
me!)
MTHACTX (Invoice Header)
MTHACTY (Invoice Item Detail)
MTHACTZ (Special Charge Lines)
I think there's a MTHACTY for bookings, too, but we don't do that. You
could very easily write a query over MTHACTX and ITEMASA/ITMRVA to get the
report you are looking for.
Dale @ Fleetwood
"Nandagopal
Padmanabhan" To: "MAPICS ERP System
Discussion" <mapics-l@xxxxxxxxxxxx>
<npadmanabhan@xxxx cc:
as-awt.com> Subject: RE: CO/CM -
Accounting Class
Sent by:
mapics-l-bounces@x
idrange.com
05/15/2003 04:22
PM
Please respond to
MAPICS ERP System
Discussion
But I suppose ITCLS is the item class and not the accounting class.
-----Original Message-----
From: Strange, Tim [mailto:TStrange@xxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, May 15, 2003 1:16 PM
To: MAPICS ERP System Discussion
Subject: RE: CO/CM - Accounting Class
It's in the ITEMASA and ITEMBL files - ITCLS is the field name.
-----Original Message-----
From: Nandagopal Padmanabhan [mailto:npadmanabhan@xxxxxxxxxxxxxx]
Sent: Thursday, May 15, 2003 4:08 PM
To: mapics-l@xxxxxxxxxxxx
Subject: CO/CM - Accounting Class
Hello Group,
Does anyone know which file contains the 'accounting class' field that is
available while doing customer orders/credit memos? On the browser, I had a
look at all available fields for 'CO History Line Item' and I could not
find
any field pertaining to accounting class.
Essentially, I would like to run a report that lists the CM#, item#,
accounting class for all YTD credit memos. I would like to know if this can
be done on the browser? If not, what are the files and field names I need
to
use for my AS/400 query. Look forward to responses.
Regards,
Nandu
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
