Skip to Content

Mass Updating the Price in Existing Sales Orders using DTW


We as a distributor, take orders from our network of retailers who take advantage of booking seasons. Manufactures offer large incentives to pre-book product for future deliveries. IE: We accept booking orders in October for delivery to take place in May the following year. Here is the scenario. We as a company face exchange rate fluctuation and price increases handed down to us from the manufactures due to high demand with commodities. It is very common in our industry to see price changes often. I am asking the question. How can I simply, Mass Update existing sales orders to the new price we have re-calculated due to price increases?

I have tried RDR1 and failed due to the row numbers not matching correctly. (This happens when a line is deleted off an order, and is common practice for us to delete lines from sales orders) I am also aware that any lines from a sales order that has partial delivery cannot be updated and my file is prepared accordingly. I also managed to try a line query using script that was written by a member on here which was helpful, but the row numbers were still not aligning correctly which hindered my attempt. Link is here -

Price fluctuations are common in my industry and I need to be able to update sales orders quickly and often throughout the year.

We work on SAP B1 - Hana 9.3 and I am looking forward to solving this with your help. Please let me know if you need any more clarity on my question.

Thank you,


Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on 3 days ago

    Hi Warren,

    Of course everything depends on the scale of the work this dynamic scenario is causing you. I see the following solutions, in order of how much easier they would possibly make your life vs. investment:

    1. Use the DTW with a well built query, the result of which, when exported to Excel, will give you a ready import file for the DTW, including the correct line numbers.
    2. Create (or have created for you) an addon that uses the DI API to automatically update changes to prices in open Sales Orders, according to any rules, and considerations your scenario requires.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on 2 days ago

    Hi Johan,

    Thank you for the reply. I have build a very strong query file used to upload to DTW, however because we delete rows from Sales orders, the row numbers are out of sync and do not match up correctly which causes DTW to throw an error message. I have run out of real options using DTW due to us deleting lines from orders. I was hoping for a different approach. DI API is a new term for me. I will research further and try and get a better understanding on how that works.

    I am taken by surprise that this is not a feature in SAP B1. I surely cannot be the only business on planet earth that needs to change prices on sales orders? My quest shall continue. Hoping to see some more feedback on here from other users as well. Please chime in! :)



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on 2 days ago

    Warren Pickard,

    You may look into this tool as well.

    Thank You.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.