RE: Cancelling duplicate sales order lines

[Dan Thomas <DThomas@xxxxxxxxxxx>]

We know JBA pretty well here, and I would not attempt to automate cancelling
order lines unless we had a huge volume of order lines to do.  Do all the
lines that need to be cancelled fit a similar profile (like they are all on
backorder)? 

Dan Thomas
Sr. VP Information Systems
Medical Distribution, Inc.
4500 Progress Blvd
Louisville, KY  40218-5058
Phone (502) 454-9013 ext 120
email  DThomas@lpw-mdi.com


-----Original Message-----
From: Dan Bale [mailto:dbale@genfast.com]
Sent: Monday, June 28, 1999 12:17 PM
To: JBAUSERS-L@midrange.com
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.
+---