Discussions – Business Central / NAV UG – Dynamics Communities

Tariffs – Refresh Open Sales Order Prices

Business Central / NAV UG

Tariffs – Refresh Open Sales Order Prices

Posted by Marcella Affonso on April 8, 2025 at 8:59 am

Hi Everyone,

We recently updated our Item Sales Price Lists with new tariffs effective April 1st.

We need to update the item prices on over 100 lines of open sales orders to reflect the new pricing.

What is the best way to accomplish this without manually updating each order?

Thank you

Jonathan Delfraisse replied 2 weeks, 5 days ago 3 Members · 2 Replies
2 Replies

Lewis Rosenberg

Member
April 9, 2025 at 4:51 pm

Up
0
Down
::
I’ve never tried on a sales order, but you may be able to use a (RapidStart) Configuration package to export sales lines to Excel, update there and then import back into BC.

I would try this in a sandbox environment first.
Jonathan Delfraisse

Member
April 10, 2025 at 10:33 am

Up
0
Down
::
As a developer, I would recommend creating a Codeunit to iterate through all the sales order lines, retrieve the correct sales price for each, and update accordingly. This function could be reused for any future mass price updates affecting current sales orders in the future. Lewis has the non-developer idea, once in excel you could use a vlookup for the new price then update all of the sales line at once.

Log In to Reply

Log in to reply.