Re: Jerk Around too many Cooks

Al Mac at Tim PC at work
____________________________________________

Question - does anyone know

Am I correct that the total invoiced should agree with the total shipped,
except when something has been shipped but not yet invoiced, so that when we
are done with the day's shipping and invoicing, any discrepancies indicate
some kind of human error, like for instance, after shipping but before
invoicing, someone does some maintenance to the order such that it is now
impossible to do the invoicing?

When there is a billing adjustment, does that write an ECL record that
minuses invoicing without touching shipping total & is there some code in
the ECL record layout that would tell me that in fact some line was created
because of that?

Al Macintyre
____________________________________________
Subject: Jerk Around my Brain

I am beginning to get a handle on how I might deal with this, and now
struggling with how to cope with the exceptions.
I am hoping to copy ECL to a user member then a week or so later match up
"address" (Order, Line, Item, Warehouse) - if due date & quantity are the
same then this requirement has not changed (except for a headache I still
have to resolve that leads to this posting).

In theory my report to manufacturing, summarizing net changes over a time
period, would only be concerned with stuff that has no corresponding
"address" within some date range or if key info in the "address" has been
jerked around.

My understanding is that my users do not care if the requirements have been
pulled this way that way the other way - they just want to see a snapshot of
the net affect of all the pulling tugging pushing kicking over some time
period.

One headache is that management has authorized ostensibly minor adjustments
to shipping total outside of BPCS, for the expressed purpose of cleaning up
errors in handling resupply orders ... I have my suspicion that this sort of
thing means some people will never need to learn how to do it right.

To check out the reality of the health of our data base, I created query
SHIN-KICK to list all ECL where shipped minus invoiced is not zero.  I
expected to find items involved in today's shipping (contents of BB* files)
and a bunch of plus values in our inter-facility customer #s.  Then with
that confirmation, use any non-zero values not active in BB* to simulate
manufacturing MRP monkey wrenches that bypass legitimate changes to customer
requirements.

I found more than I expected, when I ran my query after all invoicing was
done for the day.
Our inter-facility accounts have plus and minus both ZL and CL order lines
ie. shipping vs. invoiced total discrepancies on active & inactive order
lines.
Many outside customers have minuses, fortunately all "ZL' ID where total
invoiced is greater than total shipped.

Al Macintyre
____________________________________________
shortened earlier story on what I seeking.

>>We are a make-to-order job-shop running 405 CD mixed mode on AS/436.
>>
>>Many customers call us with very short lead times & the sales dept is
>>supposed to consult with manufacturing regarding the doability of customer
>>pull-ups, but even with consultation, doability is often considered in
>>isolation from other customer pull-ups, where they want something sooner
>>than might seem reasonable,
>>so manufacturing needs a "big picture" report to
>>monitor net changes in customer driven requirements for visibility of
where
>>MRP changed priorities came from.  Also some personnel in manufacturing do
>>not exactly trust their counterparts in customer service to properly
>>communicate changes in customer orders.
>>
>>Zero on the report = no change in the customer requirements on this
>>customer-item-facility combination
>>Plus = new business added since the prior snapshot, such as lead time
>>violated at time of customer order, and valid additions
>>Minus = Order was killed or moved away


>>I am lost on how long inactive EC* records have retention.

____________________________________________
Al Macintyre
Central Industries of Indiana, Inc.
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
+---