Does anyone know how to quickly update pricing for multiple items for already-existing sales orders? I have updated the item pricing, but that does not trigger an update of open sales orders with future ship dates. I can use a CSV import to update from “wholesale price” price level to “custom” price level with a $-value, but it will not allow me to update only the Rate on the line item on a sales order. Is there a way to trigger an update across open sales orders from the old wholesale price level to the new wholesale price level?

You can just search for all open sales orders for that item

Thank you very much for the reply! I believe thats exactly what I did, but I was not able to do a CSV import of just the new rate for each line. I had to change the price level to custom to allow me to input a new rate, even though the price level on the order line (“wholesale price”) had already been updated on the item record. It’s just another column on a CSV so its not a big deal to do this, I was just wondering if there was a “update pricing on sales orders” function, i.e. push a button and sales orders entered within a specified date range are updated price on each line item. I guess not! Maybe another way to approach this is to eliminate the problem entirely: is there a best-practice for how to take future orders at a different price than you are selling the same item today? example, item A sells for $100 today, but on August 1 Item A will go up to $110. I want to enter sales orders today to ship on september 1 that come up with a wholesale price of $110, while at the same time I am taking at-once orders to ship now that come up with the current price. Is there a native function in netsuite to have seasonal or future pricelists for an item that are auto-populated on the sales order lines based on the order type or the requested ship date?

Ah gotcha, no I don't think that exists, would be nice though