RE: IFM account payable processing problem

We converted from the mapics Accounting Management modules to the IFM module in 
June of 2002 and we have been through a lot of matching problems.  I don't know 
how long you have been on IFM or if you are new to it, but here is my thoughts. 
 

The RP can be missing from the matching screen for various reasons that you can 
determine with some queries and a little detective work.  I created 3 queries 
to analyze the data.  
·       One selects the PO# in POMAST and ties to the POITEM and POBLKT for 
information.  Use this one to see the receipt required flags,  whether it is a 
blanket and what releases are out there, etc.  
·       The second query lists the IMHIST for that PO#, part and warehouse.  
Use this one to see the qty, completion code, match flag, S number, blanket 
seq#, update date and time.  
·       The third query lists the IFM matching information by reading UARNCPP 
(Charge Line file containing PO#) selecting the PO# and warehouse, and tie to 
the UAD0CPP (Charge Receipt Matches file) and YAARREP (transaction file) using 
transaction ID.

Based on the information from these queries, you can determine if the data is 
correct or corrupt, matchable or not.  I will be happy to talk off-list to you 
or anyone else with matching problems regarding these queries or analyzing the 
data.

To determine why a quantity comes up for an incorrect amount,  add up the RP's 
for a particular release, then add up the matches made to that same release.  
Subtract the RP total from the match total and that should be the amount 
remaining that you see in the matching screen.

Another thing I have found is that if the user tries to match using GRN and 
they get "booted out" of the transaction (I have yet to understand this), they 
cannot see that RP transaction when they go back in.  We have found that in the 
UAD0CPP file, records can be written with a negative 9 in the Transaction ID 
field.   We delete these negative 9 ID records out of UAD0CPP, and the user 
will be able to see their RP transaction again, but not matching GRN, they have 
to match to the PO.

On the flip side of not seeing RP's, after we were live with IFM for some time, 
we had too many users saying they are seeing old transactions on the screen. So 
we had to mass update the IMHIST.  For any RP with an update date less than our 
IFM go-live date, we updated the match flag as matched.    

We also had a problem where the user could see the RP's and select them for 
matching, but the programs were not generating all the charge lines.   Take a 
look at PTF SH63005 ptf level 04169 which corrects this problem.

I hope something here helps.  Again, I will be happy to talk off-list regarding 
the above information.

Lenore Emhoff
MTD Products Inc
P.O. Box 368022
Cleveland, Ohio  44136-97222
Phone  (330)558-3501



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Bill Mongan
Sent: Monday, January 26, 2004 5:39 PM
To: mapics-l@xxxxxxxxxxxx
Subject: IFM account payable processing problem


My accounts payable people recently brought this issue to my attention:

A part number has had multiple receipts on a blanket purchase order, and has
already been partially invoiced for these receipts.  However, when they go
to process an additional invoice for the remaining quantity, when they are
in transaction header and use the F10 key to assign PO, they enter the
purchase order number but the part number does not appear for selection. We
use IFM and we process payable invoices through IFM, accounts payable tasks,
work with transactions.

In this example, we can see the receipt quantity of 441 in IM transaction
history inquiry, and we have previously been invoiced for 269 which we can
see in the purchase order, but when they F10 to assign PO, this part number
does not appear for selection.

Also, they showed me an example where there is one inventory receipt, and
they are trying to process the first and only invoice for this PO/part, but
when they F10 to assign PO, the part does not appear for selection.

Any ideas? this has worked in the past, and this problem does not occur on
all invoices.  We are confused!


Bill Mongan, CPA
Controller
Generac Power Systems, Inc.
(262) 544-4811 x2097
bmongan@xxxxxxxxxxx

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