RE: Disappearing Order Lines

Regards,
Jose J. Torres - MS, PMP, CISA

From: Doug_McLauchlan@xxxxxxxxxx
Reply-To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
To: bpcs-l@xxxxxxxxxxxx
Subject: Disappearing Order Lines
Date: Wed, 10 Mar 2004 14:24:41 -0800

We have an occasional issue with order lines disappearing in BPCS.

We have triggers on ECL for Insert, Update and Delete that records details
of the change in a log file. The update should show a before and after
image.

In the case of the missing lines, the user is usually updating the
quantity and request date on the last line of the order and adding a new
line at the same time. The result, on some occasions only, is that the
existing line no longer exists in ECL and the new line does. The log file
in those cases shows a before and after update record for the change to
the existing line, but instead of an insert of the new line it shows that
BPCS updated the existing line to be the new line !

As an example and order has lines 1,2 & 3 all for some quantity of the
same product on different release dates. Line 3 has the quantity reduced
and line 4 is added for that quantity a new release date. The result
should be an order with lines 1,2,3 & 4. When the probelm occurs is that
the order now has line 1,2 & 4, no line 3. The log shows line 3 being
updated with the reduced quantity, then shows line 3 being updated to be
line 4 with its quantity !

Has anyone seen anything like this ?

SSA Global Support have no record of a similar problem.

Any clues would be helpful.

Thanks.

Doug McLauchlan
Office: (503) 748-5988
Cell: (503) 706-7525
_______________________________________________
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.