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.
