Automation of closing delivered orders and put them in state "Closed Complete".

[ronro2]

My task is to close orders that have not received a delivery receipt. It is about 459 orders that need to be closed. I have an excel file with three columns: Invoice number, Order number and Ref number for each order. All 459 orders are there. 

These orders are from a "sc_request" table, where you can find them based on the Ref number. Is there any way to automate this job in ServiceNow by putting Request state/State to "Closed Complete" for each of these 459 orders? 

[Dr Atul G- LNG]

Hi @ronro2 

My task is to close orders that have not received a delivery receipt. It is about 459 orders that need to be closed. I have an excel file with three columns: Invoice number, Order number and Ref number for each order. All 459 orders are there. 

Atul : How you are checking that for 459 record delivery receipt not received? Is any field on form? or task is still open?

These orders are from a "sc_request" table, where you can find them based on the Ref number. Is there any way to automate this job in ServiceNow by putting Request state/State to "Closed Complete" for each of these 459 orders? 

Atul: As per process, task must closed and with the same RITM and REQ get closed automatically. 

So if you have any field to track delivery receipt, use that in Background or flow and close the Order.

[Kartik Magadum]

Hello @ronro2 

Yes, we can update the state to 'Closed Complete', please follow below steps. 

1. Navigate the sc_request table.
2. Copy the ref number from the Excel sheet.
3. Apply a filter in the sc_request table, i.e.> ref number - is one of - paste the ref number with comma separated.
4. Run the filter.
5. Right-click on the filter and copy the query.
6. Make sure to run in the Background script for a single record, if all is good then go for the FIX script and run for all records. 
7. Create a FIX Script (Make sure the RollBack checkbox should be checked) and run it. 

var sc = new GlideRecord('sc_request');
sc.addEncodedQuery('paste the query here');
sc.query();
while(sc.next()){
sc.state = closed_complete// make sure you will be giving value
sc.setWorkflow(false);
sc.autoSysFields(false);
sc.update();
}

Please Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Thanks & Regards,

Kartik Magadum