× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.