4 Replies Latest reply on May 28, 2019 5:55 AM by Bommi

    Script/Query to Cancel SO's multiple lines for multiple Sales Order

    Elango Venkat

      Hi

       

      I have 500+ Sales Orders having multiple Lines (Items) and only a few of the lines in each Sales Order needs to be Cancelled.

       

      Can any please share the Query or Script to do it at the Backend level which saves time, currently I am doing it one by one

       

      PFB sample list of Lines to be canceled,

       

          

      ORDER_NUMBERHEADER_IDLINE_IDREQUEST_DATESEGMENT1(ITEM)
      100200519-JUN-1410005001
      100200719-JUN-1410005002
      500600919-JUN-1410005005