Use this guide when you need to set a Custom Price for an item line (for example, on a Sales Order or Invoice) using ExtendInsights for Data Management.
What You’ll Notice
When working in an ExtendInsights template, the Price (Price Level) picklist:
Does not show a Custom option, or
Does not allow you to select a custom price level from the dropdown
Why This Happens
This is a NetSuite SuiteTalk (SOAP Web Services) limitation. Certain “special” list values, such as Custom Price may not appear as selectable options in picklists even though NetSuite supports them in the UI.
ExtendInsights can still set Custom Price by using the internal ID value directly.
How to Resolve the Issue
Watch the video or follow the steps below:
Load a transaction template that includes the pricing fields you need.
Ensure your template includes these columns (names may vary slightly by record type):
Header:
Trandate,Entity, and any required header fieldsLines (Item sublist):
Item List: ItemItem List: QuantityItem List: PriceItem List: Rate
In the Item List: Price column, enter:
[[ -1 ]](no spaces recommended, use exactly:[[-1]])
This value represents the NetSuite internal ID for Custom Price.
In the Item List: Rate column, enter the custom rate you want (for example,
125.00).
Upload your changes:
Go to Upload to NetSuite
Click Upload Records
ExtendInsights will create or update the record using the Custom Price level and your provided Rate.
Verification
After upload, verify the result:
In NetSuite UI, open the transaction and confirm:
Price Level shows Custom
Rate matches the value from Excel
If you downloaded the record into Excel, you can also Reload Records to confirm the updated values are returned.
Need Help?
If you need assistance during go-live or rollout:
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat (bottom-right of the support site)
✉️ Email cloudextend-support@celigo.com