Re: IFM/COM QUESTION

Lloyd, You can use the Transaction Number (not Transaction ID) in the IFM
Transaction Header (YAAFREP) file to link to the Invoice Number in the
Invoice Header (MBF9REP) file. Then, you can use either the Invoice-to or
Sold-to Customer Number in that file to link to CUSMAS.

Bob Tenney
Bob Tenney Solutions, LLC
MAPICS - FRx - Crystal Reports
828-526-8976
www.tenneypubs.com
----- Original Message -----
From: "LLOYD DEGNON" <ldegnon@email.com>
To: <mapics-l@midrange.com>
Sent: Thursday, September 26, 2002 3:48 PM
Subject: IFM/COM QUESTION


> [ Converted text/html to text/plain ]
> Has anyone out there figured out a clever way to relate the IFM file
> YAAFREP(entity master-bill to info) to the COM file CUSMAS(ship to
info)??? No
> common keyed fields, MAPICS insiders say that internal code handles the
> linking relationship between the two in IFM.
> This is a Real big problem for those of us who need to use things like IWP
to
> write reports! Kinda funny that using a report writer from MAPICS can't
get me
> what I need!
> It would be sooo simple for MAPICS to add a keyed field in both files to
allow
> joins! Oh well, go figure...
> Anyhow, has anyone else out there solved this?
> Thanks,
> Lloyd H. Degnon
> I. S. Manager
> Ampro Computers Inc.
> 5215 Hellyer Ave
> San Jose, CA 95138
> 408.360.4365
> Ldegnon@ampro.com
> http://www.ampro.com[1] --
>
> _______________________________________________
> Sign-up for your own FREE Personalized E-mail at Mail.com[2]
>
> ===References:===
>   1. http://WWW.AMPRO.COM
>   2. http://www.mail.com/?sr=signup
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>