D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Mass cancellation of Purchase Orders

  • 1.  Mass cancellation of Purchase Orders

    Posted 24 days ago
    Hi all,

    we are running Dynamics AX2012 R3 and we have a lot of purchase orders (from 2012 to 2015) that have been approved and confirm.
    They have not been delivered and we want to cancel them.
    It's too tedious to cancel them one by one.
    Is there a way to have bulk / batch cancellation of these PO?
    in the future, can is there a setup to cancel PO not delivered after a certain time?

    ------------------------------
    Regards,
    Serge

    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Mass cancellation of Purchase Orders

    Posted 23 days ago
    I would also be interested to know if this functionality is available in D365FO.

    ------------------------------
    JoAnne Weathers
    Applications Manager
    AAA Cooper Transportation
    Dothan AL
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Mass cancellation of Purchase Orders

    GOLD CONTRIBUTOR
    Posted 23 days ago
    @JoAnne Weathers - I have not done this in D365, but this reference may help you with cleaning up delivery remainders on POs: http://www.atomicax.com/article/clean-purchase-lines-bulk

    @Serge Yao - I am working on a project now to mass cancel POs in R3, if you do not find any answers while I am actively working on this, I can circle back with you once completed to share some insight.

    My only recommendation is to run a few SQL queries to confirm none of these POs are partially delivered. If they are, you need to consider your costing method and confirm the best way to back out the product receipts.

    ------------------------------
    Ian Gorman, PMP, MCSE
    Senior Consultant
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Mass cancellation of Purchase Orders

    Posted 23 days ago

    Hi,

    We have checked and removed the one partially received. The focus is on the one not yet received.

    Thanks

     

    Best regards,

    Serge

     

     




    Conference-AXUG_200x200


  • 5.  RE: Mass cancellation of Purchase Orders

    Posted 23 days ago
    I dont think any set up exist in standard for cancelling PO after certain time if they are not delivered. You can create you own customize process , for example, batch job process which looks for all PO's which are fully open  and cancel those.

    ------------------------------
    Sukrut Parab
    Hitachi Solutions America, Ltd.
    Irvine
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Mass cancellation of Purchase Orders

    TOP CONTRIBUTOR
    Posted 22 days ago
    There is no mass cancellation feature in standard. You should review the process with buyers and receivers about how and why certain quantities should be cancelled. One option  that may help limit the amount of small quantities remaining open is when you post a Product receipt on a PO, you can select the "Close" checkbox on the PO line which will attempt to cancel any quantity of that line  that you are not receiving. Many of my clients (and myself when I was an end user) use that regularly to cancel small remainders that we do not want or expect the vendor to ship when we receive their goods.

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC Technology
    GA
    ------------------------------

    Conference-AXUG_200x200


  • 7.  RE: Mass cancellation of Purchase Orders

    Posted 9 days ago
    Hi Serge,

    We have the same issue and I raised the question at the Medic booth at last user summit in Orlando. I received confirmation that there is no out-of-the-box functionality but learned that it's fairly easy to address via code, and the code was written and published on Github - see below. (Thank you, Nathan!)

    He put the code here: https://github.com/NathanClouseAX/AAXPOCloseHelper and also wrote a short walkthrough for the functionality here: http://www.atomicax.com/article/clean-purchase-lines-bulk.

    I work for a retail company so we're very busy at the moment (and have a code freeze) but will look at this after the holidays.

    ------------------------------
    Beth Zapadka
    ERP Functional Expert
    Glentel Inc.
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role