Bulk close Purchase Orders - Python
Requirement: Delete older Purchase Orders.
UseCase: Closing Purchase Orders from a external CSV.
Please follow the below steps.
- Extract the attached scripts in a folder.
- Update the URL and integration key in the script.
- You can get the integration key under Admin > Integrations > Integration Key > New
- Please use an integration key with admin privilege, as there wont be any role related permission issues.
- Update the integration key in the python script.
- Since this is a one time activity we can invoke the script from command prompt.
- Open command prompt as administrator in the folder location and invoke the script.
- Update the CSV file name as per your instance. In my instance, it is 1671028684384.csv
New to ADSelfService Plus?
Related Articles
How to add Resolution and Close Requests using Custom Trigger (Python)
We can achieve it by using the custom trigger feature along with a python script. We can set a trigger based on which the script will execute, the script will add the resolution and set the status to 'Closed' You can modify the condition for the ...Purchase details
SELECT po.POCUSTOMID "PO Number", max(po.PONAME) "PO Name", max(po.TERMS) "PO Terms", LONGTODATE(max(po.DATEORDERED)) "Ordered Date", max(pos.STATUSNAME) "PO Status", max(poa.FIRST_NAME) "Purchase Requester", max(po.SHIPTO) "Ship To", max(paao.NAME) ...Python Troubleshooting steps
Here we are listing the troubleshooting steps for the python script to be executed 1. Check whether python is installed or not in the sever where SDP is installed 2. If it's installed check the version of python ( Preferable version should be above ...How to setup Python on the Server
This article explains how to set up the ServiceDesk plus server to run python scripts. 1. The first step is to install python on the application server and you can download it from here . Any version above 3.4.1 should work fine. Once you've ...Script to bulk close change using deluge script based on the status
The following script will help you bulk close changes based on the status of change using custom schedules 1. Go to Reports tab --> New query report --> copy the query to the query editor and run the report. Save the report in the folder. The query ...