is there any other way than updating the customer ...
# ask-stanley-ai
m
is there any other way than updating the customer on a sales order to get all prices to be updated?
c
AI generated answer (using internal Slack threads):
Based on the conversations, there are a few ways to update pricing for multiple items for already-existing sales orders without updating the customer: 1. CSV Import: You can use a CSV import to update the rate for each line on the sales orders. However, this method might require you to change the price level to custom to allow you to input a new rate. 2. Transaction Search: You can perform a transaction search for all open sales orders for the item you're working on. The criteria for the search would be: - Type: Sales Order - Status: none of Pending Approval or Canceled - Closed, Main Line, Shipping Line, Tax Line: No - Item that you're working on The results would include Document Number, Date, Internal ID, Line Number, Item, Item Rate, Quantity, Amount, and Quantity Billed. You can then update the Item Rate for each line. 3. SuiteSolutions CSV Integrator: This is a free tool provided by NetSuite that allows you to perform bulk updates. You can use this tool to update a large number of sales orders efficiently. 4. submitRecord Method: If you're using SuiteScript, you can use the
submitRecord
method to update the sales orders. You would need to set the second parameter of
submitRecord
(doSourcing) to true. Please note that these methods might not be suitable for all situations. For example, if the sales orders have been partially shipped and billed at the old rate, you might need to handle them differently. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829539835
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825001121
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.824457407
Please provide your feedback on this answer.
Thank you for your feedback