Work Order Closure Script

Question

Hi, 
 Was asked by a user but don't think this is possible. Is there a way to set up a script to automate the Work Order closure process? The users would like to get a list of open work orders, then select particular WO's and then the closure process would be automated. Any ideas would be unexpected but very appreciated.

David Speck · Answer

If you are referring to legacy work order, the easiest way to do this is to create a tailored lookup view for the work order entry's lookup so it contains all the columns needed for a user to decide whether to close a given work order or not, they can either filter the records in the lookup or export it to excel and filter and remove the work orders that should not be closed. 
 Then have them save the results as a CSV or TAB delimited file and select it as the source file for an import into the work order transaction entry table (you would have to set this VI job up though). 
 After running the VI import, they would then need to process the work order transaction register to finalize the closing of the work orders.

Sage 100

Work Order Closure Script

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING