Duplicate entries in report Workorder progress (Bericht Fertigungsfortschritt)

Patrick Herr

• July 13, 2021 14:51

Hello,

 

I like the report Workorder progress. For some reasons in the report I have multiple lines with the same information (see screenshot attached). Not all work orders have multiple, identical entries. 

Has anyone got an idea how to solve this? I only want to see 1 line per work order.

 

Thanks

Patrick

Vote

0

• 

  Martin Heigl

  • July 14, 2021 09:16

  Hi Patrik,

  I think, we've an issue in your database

  try to use follow sql statement
  This overwrite NULL values in the field "SortId"

  update "BEAS_FTSTL" set "SortId"=Coalesce("SortId","POS_ID") where "SortId" is null

   

  see

  http://www.beascloud.com/beasweb/tfsActivityLog.php?wid=N5052885

  regards

  Martin
• 

  Patrick Herr

  • July 15, 2021 07:09

  Dear Martin,

  thank you for the quick response. 

  I tried to implement your recommendation. I open beas SQL editor and execute the SQL statement you sent me. The execution was sucessful (no error message) but the double entries in the report remain. Restarting SAP/beas does not help either.

  Did I handle you recommendation correctly or do I have to enter/execute the SQL statement somewhere else? 

  Your support is appreciated.

  Kind regards,

  Patrick

   
• 

  Martin Heigl

  • July 15, 2021 07:18

  Hi Patrick,

  we're working on it

  alternative: Open the work order - Bill of material list

  Mouse click on Position, hold mouse key and move to another position. Then you can move it back and save. In this way the system save the correct order.

  Click on Update.

  
• 

  Patrick Herr

  • July 15, 2021 07:33

  Hello Martin,

  I tried this trick as well. Open random WO, go to BOM and change positon of 1 position on BOM as you desribed and then update WO. The duplicate entries still remain in the production improvement report, restarting SAP/beas does not help either.

  We are using beas 06.2021.

  Is there another way to solve the problem?

   thank you and regards,

  Patrick
• 

  Martin Heigl

  • July 15, 2021 07:46

  hi,

  you must do this in the work order, which has double entries

   

  regards
• 

  Patrick Herr

  • July 15, 2021 07:55

  Hello,

   

  ok, this works. Thank you. But we have too many WO to do this manually for every WO with duplicate entries.

  I assume that there will be a solution in the future that solves this issue compeltely.

  Thank you anyway for your always quick response for my problems.

   

  Patrick
• 

  Patrick Herr

  • July 15, 2021 17:46

  Hello,

   

  is it possible that the problem affects APS as well?

  

  Kind Regards,

  Patrick

Please sign in to leave a comment.