web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Cancellation of PO

(4) ShareShare
ReportReport
Posted on by 336
Dear Members,

We have a requirement on cancelling a PO. For example, I created a PO with 10 Quantity but while receiving I received only 5 qty and rest 5 I need to cancel it without changing the Original Qty field in business central. How to cancel it? Please help me with this.

Thanks in advance,
Sneha
I have the same question (0)
  • Suggested answer
    Sagar Dangar, MCP Profile Picture
    799 Super User 2025 Season 2 on at
    Hi,
     
     
    1. Click on archive document button on PO .
     
    2. After archive, you can delete PO.
     
    Note: Archive PO used to keep historical data. If historical data not needed for PO, you can directly delete PO.
     
    Second way to enable "Archive Orders" boolean on Purchase setup and delete PO. it would automatically archive POs.
  • Suggested answer
    Ben Baxter Profile Picture
    6,620 Super User 2025 Season 2 on at
    Sneha,
    In base Business Central, you can't delete the PO until the Quantity, Quantity Received and Quantity Invoiced all match.
     
    A simple extension is to create an "Original Quantity" field that has the value updated upon validation of the Quantity field.  Be sure to either only insert if the value is blank OR build a question that asks if you want to change the "Original Quantity" if a value exists and the Quantity is changed.
     
    This way you can change the Quantity down to what has been received/invoiced, allowing you to delete the PO, but keeps the "Original Quantity" for any future analysis of Purchase Lines.  Be sure the value passes to the Posted Purchase Lines or else the value will be lost when the PO is deleted.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    RockwithNav Profile Picture
    8,637 Super User 2025 Season 2 on at
    We do have a functionality of Over Receiving but no under receiving :)
     
    So a standard a process we have to take care if all the quantity or else your PO will stay open forever. So easiest way out is to create new field as Original Quantity and push that 10 into this and then change the quantity to 5 and complete your PO.
     
    Make sure to make the same column on Posted Invoice side so that you can go and check even after posting.
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,750 Super User 2025 Season 2 on at
    I totally agree with Sagar's approach. There is no order cancellation function in BC Standard, only deletion. If you want to keep the archive, please use the Archive function.
     
    Thanks.
    ZHU
  • Gerardo Rentería García Profile Picture
    25,384 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Deleting Old Purchase Orders

    How to delete Purchase Orders with Backlogs? - Dynamics 365 Business Central

    Best Regards
    Gerardo

  • Suggested answer
    Mansi Soni Profile Picture
    8,909 Super User 2025 Season 2 on at
    Hii Sneha,

    Your requirement doesn't align in standard functionality, I agree with Ben Baxter's approach for that you required customization into the system if you are facing this type of transactions regularly!

    Regards,
    Mansi Soni
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,838 Super User 2025 Season 2 on at
  • Suggested answer
    Sohail Ahmed Profile Picture
    11,150 Super User 2025 Season 2 on at
    Maybe this will help clarify.
     
    In standard Business Central, there's no direct way to cancel the remaining quantity on a Purchase Order without adjusting the original Quantity field.
     
    Why?
     
    BC expects the remaining quantity to be either:
     
    Received later, or
     
    Manually reduced in the PO line.
     
     
    Your Option:
     
    To meet your requirement without changing the original Qty, you'll need a customization. A developer or your Microsoft Partner can create logic (in AL) to:
     
    Mark the remaining quantity as "cancelled"
     
    Preserve the original Qty for audit/reference
     
    Stop it from showing up in planning/suggestions
     
     
    Mark below checkbox to make this answer Verified if it helps you.
     
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans