Customer Item Price

Question

Hi NetSuite Community,

I have a Transaction Saved Search (Estimate/Quote) that shows all quote line items. I am looking to add one additional column that shows the customer-specific price for each item — i.e., the price we have set for that particular customer in their price list (Item Pricing under the customer's Financial tab).

Here is my scenario:

* We use Customer Item Pricing, where each customer has specific prices set per item
* When a quote is created, the system automatically populates the correct price
* Salespeople can manually override the rate, which is sometimes lower than the agreed customer price
* I want to compare the entered Rate vs the original Customer Item Price side by side in the saved search.

Thank you in advance!

Alex Joves -Oracle · Accepted Answer

Hi @Nissam CP

Thank you for posting here in the NetSuite Support Community!

Hello everyone! One of our fellow members could use a hand. Please feel free to join this thread and share your knowledge, ideas, or tips. Your contributions are always valued and truly appreciated!

Tigran Shahnazaryan · Accepted Answer

Hey @Nissam CP,

You need a script to populate the customer-specific price for the item dynamically on transaction lines.

What you are trying to do makes a lot of sense, and some of our customers request similar features to ensure the pricing on Quotes is set correctly and within the approved price range.