This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is it possible to use a workflow to set a custom column on a sales order to be a value from a Price Level matrix?

I have a custom column on the sales order form named Retail Price, and whenever a line item is added to a sales order, I want that custom column to be set with the value from the "Retail Price" custom Price Level of Qty 0 for that item.

Is this possible without scripting?

<@U01S5FPFTSL> Is this what you are referring to? <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/subsect_159197528898.html#Set-Customer-Price-Level>

<@U02LU41R47Q> this would be possible but not exactly how you are describing it. First you would need to source the Retail price value onto the header of each item record using a scheduled saved WF. Like this
<https://www.mavencloud.tech/blogs/post/dynamically-source-field-values-from-saved-search-results|https://www.mavencloud.tech/blogs/post/dynamically-source-field-values-from-saved-search-results>



Then once the retail price is on the header of the item you could use native field sourcing to apply it to the custom column field