This is written for Oracle SQL SELECT * FROM workorder WHERE EXISTS (SELECT 1 FROM WOSTATUS ws WHERE wonum = workorder.wonum AND ws.siteid = workorder.siteid AND status = 'COMP' and CAST(changedate AS DATE) BETWEEN CAST(sysdate - 7 AS DATE) AND CAST(sysdate AS DATE)) AND (woclass = 'WORKORDER'...
Thanks Craig,
Check with your vendor regarding a "Q & A" or "Sandbox" environment, we have both at our organization and we use them for testing and training. There is also a "Q & A" environment for report writing (IBM Cognos). Regards
Thanks Craig, I have tried the suggested approaches but it is not possible to return tools in the Actual tab of the work order or through Inventory Usage application.
It is exactly the same. Return by adding an actual material and changing the issue type to RETURN, or use the Inventory Usage application and create a document of type return or if mixed then on the row change the transaction type to return or use the button Select Items for Return, or use the...
What are the steps to return a stocked tool (rotating item) back to the storeroom after it has been issued to a work order? Additionally, besides having a custom report to show all the issued tools, is there an OOB mechanism to see which tools are issued against work orders.
Thank you for your response Steven Shull
Query the REPORTJOB table to determine which JVM(s) the report is running on. Stop the JVM(s) and delete the entries from the table. I'd also recommend deleting files in the WebSphere temp directory since these files could be quite large. Anything running that long won't be able to be canceled...
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use