Jeff,
Sorry for the confusion. If the invoice is not paid, you can reverse the
invoice (delete it) which will reset the matching quantity.
Unfortunately, AM only matches against a "summary total" and not against the
individual RP transactions as does IFM. I would assume that this total was
900 and is now overstated by 100 pcs. As such , the line is "closed"
automatically by the invoice process so there is no easy mechanism to undo
the overmatch.
If the invoice has been paid, the only other corrective action would be to
deviate the PO to reflect the 100 pc addition. This will give a false
picture of 1100 having been ordered, but will allow for a subsequent match
if the 100 pcs are due in. You will then have to force close the PO line
item.
A "non-system" method would be to DFU the quantity remaining in the file. I
don't recommend this as it obliterates an audit trail.
Kevin
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jeff Snyder
Sent: Monday, February 11, 2008 12:06 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] A/P 3- way match
Kevin,
It is the 'Invoice qty' not received qty , im trying to correct.... once
we post the invoice for 1000 , how does one adjust that figure back to 900
?
Thanks for your thoughts .....
Jeff
From: kdfox@xxxxxxxxxxxxx> To: mapics-l@xxxxxxxxxxxx> Date: Mon, 11 Feb
2008 11:21:51 -0800> Subject: Re: [MAPICS-L] A/P 3- way match> > Jeff,> >
The correct transaction is to perform a negative RP transaction for the>
1000, then a correct RP for the 900.> > Kevin Fox> > -----Original
Message-----> From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]> On Behalf Of Jeff Snyder> Sent:
Monday, February 11, 2008 10:45 AM> To: midrange, mapics> Subject:
[MAPICS-L] A/P 3- way match> > > List,> > We are running rel 6.0 and the old
GLAPPR A/P, A/R, G/L (Not IFM)> We have the interface on for the RP and the
CA. (PPV)> > > We have a glitch in the A/P process , Id like to see if
others have solved.> > If we open a PO line item for 1000, RP 1000 and get
Invoiced for 1000 > the line item closes and the all is well.> > Except ,
some one later find we only really received 900. At this point> purchasing
is reopening the line item, and receiving is performing a> negati
ve 100 receipt. We process a DM directly into A/P and await our 100>
(short).> > When they arrive we RP the 100 (same PO) but the invoice qty is
still> sitting at 1000, never gets adjusted. So we cannot perform the 3 way
match> on the follow up Invoice.> > We are thinking of developing code to
allow for an Invoice qty adjustment,> but before we do wondered what others
may be doing ?> > Any thoughts, comments, experience would be welcome> >
Thanks> > Jeff Snyder, CPIM> Guide Technologies, LLC> > >
_______________________________________________> 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.> > > >
_______________________________________________> This is the M
APICS 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.>
_______________________________________________
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.
midrange.com
