one can write a query on file kfp and extract the necessary fields for download into excel or using odbc on the output file directly.to be interrogated by other tools like crystal.
this is much easier to sort and act on.
best regards
--- On Mon, 27/9/10, bpcs-l-request@xxxxxxxxxxxx <bpcs-l-request@xxxxxxxxxxxx> wrote:
From: bpcs-l-request@xxxxxxxxxxxx <bpcs-l-request@xxxxxxxxxxxx>
Subject: BPCS-L Digest, Vol 8, Issue 161
To: bpcs-l@xxxxxxxxxxxx
Date: Monday, 27 September, 2010, 1:00 AM
Send BPCS-L mailing list submissions to
bpcs-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
bpcs-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
bpcs-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. Fw: Query-- Expedite/De-expedite -- Exception Messages in
BPCS + ERP LX (Milt Habeck)
2. Re: Capture/Query Expedite/De-expedite - CD405 (Al)
----------------------------------------------------------------------
message: 1
date: Sat, 25 Sep 2010 15:14:21 -0500
from: "Milt Habeck" <mhabeck@xxxxxxxxxx>
subject: [BPCS-L] Fw: Query-- Expedite/De-expedite -- Exception
Messages in BPCS + ERP LX
<vendor>
Unless they are handled intelligently, exception messages out of BPCS and ERP LX arrive on
a very thick of stack paper. If you've got a large record count in your item master file,
there's so much paper that the useful information becomes invisible.
PaperSaver Exception Report software not only sorts but it also weeds out messages that
aren't worth looking at in the first place. We recently added a new exception message
that points to POs that have excessive order quantities. That very constructive
information isn't available from any BPCS or ERP LX version.
News release about the new "PO Quantity too high" exception message:
www.unbeatenpath.com/news/PaperSaver-newsSept10.pdf
PaperSaver software description:
www.unbeatenpath.com/software/ps/PaperSaver.pdf
Warm regards,
Milt Habeck
Unbeaten Path
(888) 874-8008
+262-681-3151
</vendor>
From: Don Cavaiani
To: bpcs-l@xxxxxxxxxxxx
Sent: Saturday, September 25, 2010 6:08 AM
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?
------------------------------
message: 2
date: Sat, 25 Sep 2010 17:02:01 -0500
from: "Al" <macwheel99@xxxxxxxxxx>
subject: Re: [BPCS-L] 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?
midrange.com
