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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Canceling multiple lin...
Finance | Project Operations, Human Resources, ...
Suggested answer

Canceling multiple lines in SO (but not all)

(0) ShareShare
ReportReport
Posted on by BCC 18

Hello.

If I have a Back-Sales Order of 100 lines ( items) and I want to cancel 20 lines in one go, how can I do it in the easiest way?

The items is not on a Picking list yet and have status "None".

(The items to be canceled, are items that are blocked for purchase).

- If I write several article numbers in the column "Item number" and cancel all those with the button "Cancel" (tab "Sales order" in SO), then ALL lines in the order will be canceled (even those that are not written there and which I am looking for ).

- And if I take "Update Line" and "Deliver remainder", I can only take one line at a time, which takes a very long time and we have 30 orders a day to handle in a similar way.

- I would rather not enter the AOT either if needed.

Any suggestions:)?

regards / BCC

I have the same question (0)
  • Suggested answer
    Hussien Ahmed Profile Picture
    Hussien Ahmed 110 on at
    RE: Canceling multiple lines in SO (but not all)

    Hi BCC

    You can do it according to the standards by do it line by line through deliver reminder as you said, The other option is to do it by code in AOT through the sales line table by updating the remain qty fields and the status of the line .

    Regards,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Canceling multiple lines in SO (but not all)

    Hi BCC,

    If the lines have just been created, can't you simply delete / remove those 20 lines?

    Best regards,

    Ludwig

  • BCC Profile Picture
    BCC 18 on at
    RE: Canceling multiple lines in SO (but not all)

    Hello Ludwig

    The orders are integrated with another company, so they will be "Open" in their IO in their company-system if they are deleted from our SO. If we cancel them instead in the SO, the lines will be "closed" in their system as well.

    // Regards BCC

  • BCC Profile Picture
    BCC 18 on at
    RE: Canceling multiple lines in SO (but not all)

    As I also wrote :), for various reasons we prefer not to go into the AOT to cancel these. So we are looking for if there is another way without taking line by line.

    / BCC

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Canceling multiple lines in SO (but not all)

    Hi BCC,

    Do I understand you correctly that you refer to an intercompany Sales Order where you have an Intercompany Purchase order in one of your other companies?

    Best regards,

    Ludwig

  • BCC Profile Picture
    BCC 18 on at
    RE: Canceling multiple lines in SO (but not all)

    No, they use their own system, where they create purchase orders that come to our AX2012 as Sales orders. And when we handle a line in the Sales orders, it is linked to their Purchase order in their system (like an IC order).

    /  regards, BCC

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Canceling multiple lines in SO (but not all)

    Hi BCC,

    So, its an intergration that creates the Sales orders, right?

    How is this integration made?

    Is is it a one way simple import of the SOs or do you also sync changes from AX back to their 'own system'?

    Best regards,

    Ludwig

  • BCC Profile Picture
    BCC 18 on at
    RE: Canceling multiple lines in SO (but not all)

    it syncs from AX back to their 'own system'..

    In "old" cases where we have deleted lines from the SO, the lines in their Purchase Order were "Open".

    So we would like, in a easy way, cancel several lines in SO, so it syncs to their system and is canceled / closed there.

  • BCC Profile Picture
    BCC 18 on at
    RE: Canceling multiple lines in SO (but not all)

    Any suggerstions  to do that without entering the AOT or delete lines  :)?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Canceling multiple lines in SO (but not all)

    Hi BCC,

    I think you need to talk to the one who created this integration.

    If you simply delete things in AX things might go wrong in the other system and the process might get stuck.

    Best regards,

    Ludwig

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,100

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 890 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 633 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans