Why would the error message "Cannot amend lines with zero
quantity outstanding unless a blanket order" be displayed? The PO is
definitely a blanket one. I heard one explanation that the line item was
completely received and matched. But blanket PO line items are
received and matched regularly. What could be so
different about this particular line item? Please advice.
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of
system21-request@xxxxxxxxxxxx
Sent: Wednesday, December 20, 2006 1:00 PM
To: system21@xxxxxxxxxxxx
Subject: SYSTEM21 Digest, Vol 4, Issue 125
Send SYSTEM21 mailing list submissions to
system21@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/system21
or, via email, send a message with subject or body 'help' to
system21-request@xxxxxxxxxxxx
You can reach the person managing the list at
system21-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of SYSTEM21 digest..."
Today's Topics:
1. [SYSTEM21] AP Standalone Match Reversal (Ellsworth, Bob)
2. Re: [SYSTEM21] AP Standalone Match Reversal
(jroesch@xxxxxxxxxxxxxxx)
3. [SYSTEM21] How can I eliminate hand written requisitions?
(Plunkett, Bob)
4. Re: [SYSTEM21] How can I eliminate hand written requisitions?
(rhearl@xxxxxxx)
----------------------------------------------------------------------
message: 1
date: Tue, 19 Dec 2006 14:33:38 -0500
from: "Ellsworth, Bob" <Bob.Ellsworth@xxxxxxxxxx>
subject: [SYSTEM21] AP Standalone Match Reversal
Has anyone written a utility to reverse a System21 Standalone Match
transaction?
It looks like it might be as simple as -
update PMP09 set IUOM09 = ' ', INVD09 = 0, IPRC09 = 0, CRTI09 = 0,
INVN09 =' ', INVT09 = ' ', INVU09 = ' 'where CONO09='xx' and
INVN09='xxxxxx' and GRNO09=xxxxxx and ORDN09='xxxxxx'
update PMP03 set QINV03 = QINV03-xxxxx where CONO03=CONO09 and
ORDN03=ORDN09 and LINE03=LINE09 and BOSN03=BRSN09
But if it were, wouldn't System21 come with a reversal option?
We get requests from AP to undo 'em on occasion. I'd be interested to
see what others do.
Thanks!
-BobE
Pollak Engineered Products
V3.5.2b SP3 on V5R2
This electronic mail transmission contains confidential information
intended only for the person(s) and/or organization named. Any use,
distribution, copying or disclosure by or to any other person
outside your organization is strictly prohibited. If you received
this transmission in error, please send an electronic mail message
to postmaster@xxxxxxxxxx so we may instruct you regarding its
disposition.
------------------------------
message: 2
date: Tue, 19 Dec 2006 15:19:28 -0500
from: jroesch@xxxxxxxxxxxxxxx
subject: Re: [SYSTEM21] AP Standalone Match Reversal
I'm not saying your logic is correct, but if you are joining to PMP03
you
will need the following condition DTLC03 = 9999999 other wise you will
encounter duplicates.
Standalone match was originally considered part of a poorman's 4-Way
Match:
PO + Receipt + Direct Post + Standalone match.
For those of us that use it to clear out old receivers, a reversal would
be
nice when mistakes are made but like Standalone Match be highly
restricted.
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Ellsworth, Bob
Sent: Tuesday, December 19, 2006 2:34 PM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] AP Standalone Match Reversal
Has anyone written a utility to reverse a System21 Standalone Match
transaction?
It looks like it might be as simple as -
update PMP09 set IUOM09 = ' ', INVD09 = 0, IPRC09 = 0, CRTI09 = 0,
INVN09 =' ', INVT09 = ' ', INVU09 = ' 'where CONO09='xx' and
INVN09='xxxxxx' and GRNO09=xxxxxx and ORDN09='xxxxxx'
update PMP03 set QINV03 = QINV03-xxxxx where CONO03=CONO09 and
ORDN03=ORDN09 and LINE03=LINE09 and BOSN03=BRSN09
But if it were, wouldn't System21 come with a reversal option?
We get requests from AP to undo 'em on occasion. I'd be interested to
see what others do.
Thanks!
-BobE
Pollak Engineered Products
V3.5.2b SP3 on V5R2
This electronic mail transmission contains confidential information
intended only for the person(s) and/or organization named. Any use,
distribution, copying or disclosure by or to any other person
outside your organization is strictly prohibited. If you received
this transmission in error, please send an electronic mail message
to postmaster@xxxxxxxxxx so we may instruct you regarding its
disposition.
midrange.com
