Re: Deleting Ship Confirm Orders in BPCS 6.1.01 -- BPCS-L

We have an infinity of queries, some run daily, weekly, monthly, that list 
various things that we have found creep in errors to our data base in need of 
repairs ... rate of running them is related to frequency of the error 
conditions.

We have a list of items on customer orders for NO PRICE.

We have a list of items in which the LIST PRICE and the SALES PRICE disagree.
Perhaps some of this is legitimate, but the customer service department 
should know what the story is & see any on the list that are not right.
Usually it is a case of a price change in which all the files did not get 
updated.

By running these lists daily, the customer service department usually has 
several days to make repairs before the shipments are due.  Prior to us doing 
this we had a whole lot of problems with shipment oops that today are 
extremely rare.

We have a list of customer orders that got DELETED when inside the lead times 
for production & thus lets make sure the factory was consulted on this.

We used to muck with the data but upper management put a stop to it.
Reason ... various documents HAVE ALREADY BEEN PRINTED & SENT THE CUSTOMER 
THAT ARE WRONG such as the documents that go with the shipment ... if the 
customer then gets a corrected invoice they can have trouble reconciling the 
corrected invoice dcoument number with the wrong document number on the 
shipment

Immediately before the billing, we run a shipping report that lists the data 
that will be billed.  This query lists many of the fields that are at risk of 
being in error, such as suspicious price, suspicious shipment method, two 
different stories on the identical item #, overshipment of order line, 
quantity mismatch.

This is then highlighted for repairs.

I have been informed that errors on invoices are much more difficult to spot 
than from this kind of report.

We used to have this problem in which the Billing Clerk could not bill some 
shipment because some unknown person was updating one or more of the orders 
involved.
She would go around to the suspects most obvious to her & they would all deny 
that they were in that order.
OS/400 LCK options not really user friendly & management would not authorize 
the purchase of the $500.00 add on "Display BPCS Activity"

So now MIS does the billing & THAT problem gone away, because I able to work 
the LCK functions, clumsy as they are, but along the way I see what the 
problems are with the data for today.

Also, after billing, our PC guru sends some e-mail to selected customers 
which contains a query report on what we billed them today, so he is anxious 
to know whether the billing has been completed & there are other specialist 
interests like that, so I use the API for SNDMSG to multiple users (I not 
remember now what that is, I put it on a BPCS User Menu because I did not 
want end users on GO ASSIST) to notify relevant persons 
a) Billing completed for today & number invoices involved & other totals
b) How many of which kinds of problems exist in today's data
This way the end users need not come to us saying this or thak kind of 
problem because Al Msg said we already know

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode @ 
http://www.cen-elec.com 

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