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 ...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 ...Automatically close request after successive approval reminders.
This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...