We have auto generated POs that get created that we end up never using. We are looking for a way to create a batch job (or something) that can run to cancel these out after 30 days of not being used. As we understand it, you have to have a line to cancel the PO because we have to cancel the deliver remainder. Is there a way to have a batch job add a line then cancel the remainder for us? Or another way to accomplish out goal?
We don't want to just delete the PO, which we know is able to be done in mass. We want to actually cancel it so we still have record of it, due to other processes and functions downstream.
There is no batch job out of the box that can create a line and cancel it. You can consider creating a Power Automate Flow that will create the lines and set the delivery remainder to zero. You should know exactly the definition of "30 days note being used". Is this looking at the creation date and check if there is no lines or no confirmation posted?
If the number of POs to cancel is not that high, you can also consider a manual process. You can then use the advanced filter/query form and use the "not exists join" to check for open POs without order lines.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.