What version of BPCS? In version 4.05 CD, if you query or sql the ECL
file, extract all LID="ZL" and NOT LSTAT IN("C","4","8"), then multiply
LQORD-LQSHP by LNET (or by cost)...
The only thing is you may pick up a lot of orders that were simply
entered wrong then re-entered... If you select lines where the
maintenance date is greater then the entry date, you may get a closer
measurement to orders cancelled due to missed shipments...
It w/b nice if users were able to maintain reason codes, when canceling
orders ~which might be the case in newer releases of BPCS/LX...
Hope this helps.
Regards,
DeeDee Virgei
Project Leader
Nelson Stud Welding, Inc.
-----Original Message-----
From: bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx
[
mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx] On
Behalf Of William Couch
Sent: Friday, May 04, 2007 2:29 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Order entry values.
Does anyone know a way to capture the value of the orders entered and
cancelled for a select month?
Bill
--
This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a
message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.
Delivered-To: deedee.virgei@xxxxxxxxxxxxxx
midrange.com
