Beas Sub-assemblies in work order window are not visible

  • Updated

The linking between the work order positions has changed and as a result, if you are working with closed work orders and with order-related sub-assemblies, you cannot see the sub-assemblies in the work order structure window.

wo.png

Note: The database check inserts the link in all open work orders and other windows without any problem.

Execute the following SQL statement only once on the database:

update "BEAS_FTSTL" set "BEAS_FTSTL"."ZU_BELPOS_ID" = "BEAS_FTPOS"."BELPOS_ID" from "BEAS_FTPOS", "BEAS_FTSTL" 
where "BEAS_FTPOS"."BELNR_ID"="BEAS_FTSTL"."BELNR_ID" 
and "BEAS_FTPOS"."ZU_BELPOS_ID"="BEAS_FTSTL"."BELPOS_ID" 
and "BEAS_FTPOS"."ZU_POS_ID"="BEAS_FTSTL"."POS_ID" 
and coalesce("BEAS_FTSTL"."ZU_BELPOS_ID",0)=0

Was this article helpful?

6 out of 6 found this helpful

Comments

0 comments

Please sign in to leave a comment.