I suggest separate reports based on:
* Corporate responsibility (shop orders vs. purchase orders) (which
* 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


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.


Les Mittman


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
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?

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.