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?


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.