Re: PPV

Lloyd, Good News and Bad News.

Good News! The INVTXN file has PPV amounts in the Variance Amount field.
Most users are tailored to calculate PPV when they process invoices in IFM.
If this is so, the PPV amount is in the CA transactions. If you calculate
PPV amounts based on the PO, then the PPV is in the RP or RQ transactions.

Bad News! MAPICS deletes the INVTXN file when you create IFM transactions.
You will need a procedure to copy the INVTXN file before you create the IFM
transactions.

Alternative News! IFM lets you drill down from IFM transactions to IMHIST.
You select your PPV GL lines and then use the drill-down joins to get the
info. Sorry, I don't recall the exact files but I do remember that the joins
involve the IFM Transaction ID, Token field in IMHIST and an intermediate
file that has both of these fields.

Bob Tenney
Bob Tenney Solutions, LLC
828-645-6829 / Cell 828-342-8570

Visit www.tenneypubs.com for books about
MAPICS and FRx
----- Original Message -----
From: "Lloyd Degnon" <ldegnon@xxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Sent: Friday, June 22, 2007 6:09 PM
Subject: [MAPICS-L] PPV

Trying to write a PPV report in Version 6 MAPICS with IFM. What File(s)
is this information written to?

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