Duplicate entries in report Workorder progress (Bericht Fertigungsfortschritt)
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
Comments
7 comments
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
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
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.
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
hi,
you must do this in the work order, which has double entries
regards
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
Hello,
is it possible that the problem affects APS as well?
Kind Regards,
Patrick
Please sign in to leave a comment.