Re: 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. 
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.