Re: Cancelling duplicate sales order lines

Why are you being tasked to do this at all?  What is causing the duplicate
sales order lines in the first place?  I think you might be better off
fixing this at the source than trying to bandaid it later on.  I know I
wouldn't consider doing this in a batch program without understanding the
cause of the problem.  There are way too many things that can go wrong, go
wrong, go wrong.  FYI, there are a LOT of files that could be affected by
this and they are all over the system.  We only do order line cancellations
using the JBA programs for this reason, and right now cancellations are not
very common as we have cleared up the processes that led to them.

My two cents.

Bruce Stern

-----Original Message-----
From: Dan Bale <dbale@genfast.com>
To: JBAUSERS-L@midrange.com <JBAUSERS-L@midrange.com>
Date: Monday, June 28, 1999 2:08 PM
Subject: Cancelling duplicate sales order lines


>
>
>I have been given the priveledge of taking hold of a small project that
involves
>writing a batch program to cancel duplicate sales order lines.  As I am new
in
>JBA, I am approaching this with extreme caution (and trepidation).  Here's
what
>little I know (and if I'm wrong about what I "know", please feel free to
correct
>my errors):
>
>The order header & detail (OEP40 & OEP55) have corresponding STATxx fields.
It
>is my understanding that the status must be blank (active) before I can
change
>it to an 'X' to cancel them.  Is this correct?
>
>I have also been told at a high level to "check for any picks" (in INP57),
to
>ensure that "the order is not yet invoiced" (in OEP65 & OEP70; how do you
tie
>back to order?), and to "verify" that the allocations in the Stock Balance
file
>(INP60) are correct.
>
>Can somebody elaborate on this?  I would be most appreciative!
>
>(Of course, if there were any worthwhile documentation ...   wait, wait, I
put
>my soapbox away!)
>
>- Dan Bale
>
>
>
>
>
>+---
>| This is the JBA Software Users Mailing List!
>| To submit a new message send your mail to JBAUSERS-L@midrange.com.
>| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: doug333@aol.com.
>+---
>

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---