Re: Disappearing Order Lines

V6.1.01.  We had this issue come up and after talking with the users, I
thought it happened mostly when they used the F5 key to remove deleted
lines.  I took that function key away from them and haven't heard about any
more missing lines.  I can't say for sure that the F5 key was the problem,
because I know the whole ECHW and ECLW logic has some flaws, but the
disappearing lines problem hasn't appeared for some time ;-)
Rick Folsom
Yupo Corporation America
757-819-9230



                                                                                
               
                    Doug_McLauchlan@p                                           
               
                    lanar.com               To:     bpcs-l@xxxxxxxxxxxx         
               
                    Sent by:                cc:                                 
               
                    bpcs-l-bounces@mi       Subject:     Disappearing Order 
Lines              
                    drange.com                                                  
               
                                                                                
               
                                                                                
               
                    03/10/2004 05:24                                            
               
                    PM                                                          
               
                    Please respond to                                           
               
                    "SSA's BPCS ERP                                             
               
                    System"                                                     
               
                                                                                
               
                                                                                
               




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.