RE: CO/CM - Accounting Class

[DaleGindlesperger@xxxxxxxxxxx]

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.