Re: IFM Question

Thanks Richard! Thanks Vanessa! I have been working on this ALL day! I
cannot thank you enough!

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard McCracken
Sent: Tuesday, July 17, 2007 3:52 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] IFM Question

The file UAQNCPP has the detail behind the IFM transaction that was
contained in INVTXN before the entry was created. This file has up to
three records for each INVTXN record (1 each for charge, offset,
variance amounts) and are linked to the IFM G/L lines file YAA7REP. To
get quantities, these records can be linked to IMHIST by the 5 key
fields: Item number, Warehouse, Update Date, Update Time, and Token.

Rich McCracken
LeTourneau Technologies, Inc.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Tuesday, July 17, 2007 4:00 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] IFM Question

Unfortunately INVTXN appears to get cleared on month end close...

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Spears, Raymond
Sent: Tuesday, July 17, 2007 1:24 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] IFM Question

Lloyd you could start with INVTXN in AMFLIB.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Tuesday, July 17, 2007 4:14 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] IFM Question

I need to create a report of all Inventory related transactions that hit
GL for a specified time period. I need to include the Item Number, the
Quantity, the Cost used, and the resulting dollar amount. Any Ideas
where to start? I would like to build this in Query, the recreate in
IWP (Info Workplace) I tried to use the supplied report, Translist, but
could not get it to produce any output.

Thanks,


Lloyd H. Degnon
I.S. Manager
Ampro Computers, Inc.
5215 Hellyer Ave. Bldg 110
San Jose, CA 95138
408.360.4365
www.ampro.com