MIDRANGE dot COM Mailing List Archive



Home » MAPICS-L » October 2003

RE: COM Invoice file name



fixed

ERLCOM6 will show you the file names and descriptions and allow you to look
up either way, it also has an F-key that will show you basic relationships -
open orders and history.  The "6" in ERLCOM6 is for XA Rel 6, it also exists
as separate downloads for Rel 4 & 5.

I have also heard of displaying all physical files in AMFLIB to an output
file (use DSPFD), saving it, and querying that file to find the names.  If
specify only the PF's, then you don't get the thousands of logical (LF)
files. 

btw: ERLIFM6 is also a downloadable for IFM.


Did I just say query?  I meant write an IWP report...

Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
 
Making Information Work for your Business
www.intuator.com



-----Original Message-----
From: Garcia, Josue [mailto:Josue.Garcia@xxxxxxx] 
Sent: Friday, October 24, 2003 3:44 PM
To: 'MAPICS ERP System Discussion'
Subject: RE: COM Invoice file name


Download a ptf from Mapics do a search on ERLCOM6. That will show you all
the files relationships.

Josué

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of sjones@xxxxxxxxxxxxxx
Sent: Friday, October 24, 2003 4:02 PM
To: MAPICS ERP System Discussion
Subject: Re: COM Invoice file name






List:

I do have them in MS-Word format.  If you want them I can send them to you.
Would probably be best if you send me an email off the list & directly to
me. sjones@xxxxxxxxxxxxxx


Steve Jones


                                                                           
             DaleGindlesperger                                             
             @fft-inc.com                                                  
             Sent by:                                                   To 
             mapics-l-bounces@         MAPICS ERP System Discussion        
             midrange.com              <mapics-l@xxxxxxxxxxxx>             
                                                                        cc 
                                                                           
             10/24/2003 01:27                                       Fax to 
             PM                                                            
                                                                   Subject 
                                       Re: COM Invoice file name           
             Please respond to                                             
             MAPICS ERP System                                             
                Discussion                                                 
             <mapics-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           





Steve,

If you'd scan your flowchart (unless it's in electronic format), and make it
available, I'd bet you'll have a LOT of friends on this thread asking you
for a copy (me, for example).  You'd probably never have to buy a beer
at another conference again.....   :)

Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
Somerset, PA




                      sjones@hpproducts.

                      net                       To:       MAPICS ERP System
Discussion <mapics-l@xxxxxxxxxxxx>
                      Sent by:                  cc:

                      mapics-l-bounces@m        Subject:  Re: COM Invoice
file name
                      idrange.com



                      10/24/2003 08:31

                      AM

                      Please respond to

                      MAPICS ERP System

                      Discussion











You can thank Synon for the file/field names is what I have been told.  The
only good thing about the field names is that the same field in one file is
named the same in another with just the first two characters different. Like
customer number in MBC6REP is C6CANB & in file MBBWCPP it is BWCANB.

We have a flowchart showing the COM files and how they relate to each other,
we would be LOST without it.

Steve Jones



             "James Staber II"
             <jstaber@xxxxxxxx
             om>                                                        To
             Sent by:                  <mapics-l@xxxxxxxxxxxx>
             mapics-l-bounces@                                          cc
             midrange.com
                                                                    Fax to

             10/24/2003 08:22                                      Subject
             AM                        Re: COM Invoice file name


             Please respond to
             MAPICS ERP System
                Discussion
             <mapics-l@midrang
                  e.com>






Found it in the mentioned MBF9CPP file.  Thanks to everyone's reply /
suggestions. Don't you just love COM's file naming conventions (if there are
any)!


message: 3
date: Thu, 23 Oct 2003 12:24:41 -0500
from: "Mike Bennett" <mbennett@xxxxxxxxxx>
subject: Re: COM Invoice file name

You might try AMFLIBx/MBF9CPP Invoice History Special Charges Mike Bennett -
Information Services Manager Kimray Inc. 52 NW 42nd Street Oklahoma City, OK
73118 405-525-6601 www.kimray.com
----- Original Message -----
From: "James Staber II" <jstaber@xxxxxxxxxx>
To: <mapics-l@xxxxxxxxxxxx>
Sent: Thursday, October 23, 2003 11:26 AM
Subject: COM Invoice file name


> I'm trying to write a simple query to summarize all the freight 
> charges
invoiced during a specific time interval.
>
> I thought the field could be found in an AR history file. If it is I
couldn't find it.  Next try was in one of the the myriad COM files.  In
reviewing the file descriptions I didn't see one that looked like it would
contain a 'freight' field.
>
> Any help in pointing me to the correct file/field would be greatly
appreciated.
>
> TIA,
> Jim
>
>


_______________________________________________
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.



_______________________________________________
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.










Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact