Skip to main content

Historic Set Works Orders still appearing on the WIP Costs Report

I have noticed that a Set Sub-Works Order is still appearing on the WIP Costs Report although it is historic.

B
Written by Bogdan Branetiu
Updated this week


First we must identify if the sub-works order is considered open in SQL. We can run the following script to identify this.

SELECT WOHEAD.Complete, * FROM WOHEAD WHERE WOHEAD.Ultimate_Parent = [Parent WO number]


Once we have identified the line that is still showing as open (this appears as a 0 in the 'Complete' field) we can run the following script to manually set it to historic.

Update WOHEAD Set Complete = 1 where Works_Order = [Works Order number identified in the first script]


​


​

Did this answer your question?