Re: Cancelling duplicate sales order lines

Dan,

Lucky you!!!!!

'X' is the correct status.  If the line is open it will be a blank.  To know
if it is allocted you just look at the QTAL55 field.  If this is greater
then zero then it is currently allocated.  To know if a dispatch has been
made then look at field QTDS55 field.  When you cancel the line, remember to
zeroize the outstanding quantity field QTOS55 and you should really write to
the audit file OEP55A...a before and after image.  The allocations are
reflected in INP60 and if the item is Lot/Serial controlled, they are also
in INP80.

Best of Luck!!!

Mark.

----- Original Message -----
From: Dan Bale <dbale@genfast.com>
To: <JBAUSERS-L@midrange.com>
Sent: Monday, June 28, 1999 9:16 AM
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.
+---