Re: Capture/Query Expedite/De-expedite - CD405

I suggest separate reports based on:
* Corporate responsibility (shop orders vs. purchase orders) (which
facility)
* Expedite vs. De-expedite vs. Cancel
* Date math . ignore if it is only a few days off

You can put these reports in a CL structured like BPCS reports . take menu
option, which puts report to JOBQ
We have a user-menu for putting MRP CAP etc. regeneration to JOBQ, which
also includes query reports we interested in, to run after MRP CAP get done.
Launch all this last thing in evening, look at the reports next morning.

-
Al Mac
20 years BPCS experience
A lot of it feels like the same year repeated 20 times
.
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of Les
Mittman - SBC
Sent: Saturday, September 25, 2010 10:59 AM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Capture/Query Expedite/De-expedite - CD405

Don,



This process is straightforward. Expedite and De-expedite messages are
issued for various type of orders. Each order type is from a specific BPCS
order file.

They are:

. Shop Order (FSO)

. Purchase Order (HPO)

. Planned Order (KFP)

. Resupply Order (ECL, where Customer Order is Order Type 9 in ECH)



The MRP Reschedule Date is a field on each of these records. So, the
Expedite Message occurs when MRP Reschedule Date is before the Due Date (or
Schedule Receive Date for RSO). De-expedite Message occurs when it is after
these dates.

If the MRP Reschedule Date is all 9's, that is a Cancel Message.

Using Query, you can identify these messages and output them to files which
can then be downloaded to EXCEL.



Please feel free to contact me offline if you have any questions.



Thanks.



Les Mittman

847-858-5235

BPCS Consultant with over 20 years experience



-----Original Message-----
From: bpcs-l-bounces+lmittman=sbcglobal.net@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lmittman=sbcglobal.net@xxxxxxxxxxxx] On Behalf Of Don
Cavaiani
Sent: Saturday, September 25, 2010 6:09 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Capture/Query Expedite/De-expedite - CD405



Has anyone ever found a way to put the Expedite/De-expedite record data

into a file which could then be simply queried by Query/400?