custom price level using the custom field in the item record

create the custom price level using the custom field in the item record

Use Price Levels Feature

• The Price Levels feature in NetSuite allows to set multiple price levels for the items. We can create new price levels and then use our custom field to set the prices for each level.
• To use our custom field as a price level, We would need to create a new price level and then update the Price Level record on the basis of the custom field in the item record using the custom script.
• Once we have created the price levels based on the custom field value, then we can assign them to our items.

Use Saved Searches

• Saved Searches in NetSuite allow to create a custom search for our items based on specific criteria.
• To use our custom field as a price level, we would need to create a Saved Search that includes the custom field value for each item. We can then export the search results to Excel and use a formula to calculate the price based on the custom field value. Once we have calculated the prices, we can use a CSV import to update the prices for each item.
• The Saved Search can be saved for future use and scheduled to run on a regular basis to ensure that the prices are up to date.

Use Item Pricing Records

• Item Pricing records in NetSuite allow you to set the price for each item individually.
• To use our custom field as a price level for an item, we would need to create an Item Pricing record for each item and then use our custom field to set the price for that item. We can also create a script that automatically creates or updates Item Pricing records based on the custom field.
• Once we have created the Item Pricing records, the price will be automatically used when the item is added to a transaction.

In summary, the best solution for using a custom field as a price level in an item record in NetSuite will depend on the complexity of pricing strategy. The Price Levels feature is the most straightforward solution, but it may not be sufficient for complex pricing structures. Item pricing records and Saved Searches offer more flexibility but require more setup and maintenance.

Best fit solution

The combination of Item Pricing records and SuiteScript would likely be the best fit solution to implement a custom pricing strategy.

1. Create a custom field for the price level in the item record.
2. Create an Item Pricing record for each item and set the price for each price level using a formula that references the custom field. We can use SuiteScript to automatically create or update Item Pricing records based on the custom field.
3. Use SuiteScript to calculate the price for each item based on the selected price level and any other relevant factors such as quantity discounts or customer-specific pricing.
4. Use the calculated price in transactions such as sales orders and invoices.

Using SuiteScript allows for a high degree of customization and flexibility in implementing complex pricing strategies. We can create scripts that automatically update prices based on changes to the custom field or other relevant factors.