We are on V6.04.
We added a trigger program to the ECL file to capture each addition,
update and deletion and write details of the transaction (Order #, Qty,
Price, Value etc) to a daily and a monthly transaction file. We then run
a report of daily bookings each night and clear the daily file down
ready for the following day. At monthend we run the report of the
month's bookings and clear the monthly file ready for the new month.
This method ensures we capture new orders and any changes to orders that
were raised earlier in the month or in previous months. Changes can
result in big changes to value booked. Sometimes we raise orders with
dummy items and no value and update them later with real parts and real
prices. If we only captured the order value when originally raised we
would miss a lot of value.
Because of the way BPCS inactivates orders when complete and deletes
orders, you need to be careful to differentiate between a real deletion
and the removal of completed orders from ECL (eg. if you archive
completed orders off system). But with care, it seems to work fine for
us.
If you'd like any more information on what we did, let me know.
Tom Molyneux
-----Original Message-----
From: bpcs-l-bounces+tmolyneux=mono-pumps.com@xxxxxxxxxxxx
[
mailto:bpcs-l-bounces+tmolyneux=mono-pumps.com@xxxxxxxxxxxx] On Behalf
Of DeeDee Virgei
Sent: 04 May 2007 20:10
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] Order entry values.
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
--
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: tmolyneux@xxxxxxxxxxxxxx
midrange.com
