Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Cancel POs without lines

(0) ShareShare
ReportReport
Posted on by 124
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.  
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,111 Super User 2025 Season 1 on at
    Cancel POs without lines
    Hi Ferguson,
     
    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.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans