1. SCM (Supply Chain Management)
  2. Item Record Management
  3. Advanced Pricing
  4. Managing Potential Conflicts in Advanced Pricing

Managing Potential Conflicts in Advanced Pricing

Use the Price to Use if Multiple Prices Found for an Item preference to control which price NetSuite selects when more than one qualifying price applies to the same item on the same day.

In a single-currency account, this preference works as a tie-breaker (highest or lowest). In a multi-currency account, currency availability can affect which prices NetSuite can compare.

How NetSuite Chooses a Price

When more than one price qualifies for the same item and date, NetSuite checks in this order:

  • Customer-specific pricing comes first. If NetSuite finds a customer-specific price and another price, it uses the customer-specific price.

  • Rule configurations are considered next. If more than one customer-specific price qualifies, NetSuite checks the price rules to see if one is preferred.

  • Then NetSuite uses your preference. If more than one qualifying price still remains, NetSuite uses Price to Use if Multiple Prices Found for an Item to choose the highest or lowest price.

How Multi-currency Can Change the Result

In a multi-currency account, NetSuite may need to confirm that a price exists in the transaction currency before it can select between multiple qualifying prices.

This conflict is most noticeable when:

  • You have more than one qualifying price (or price rule), and

  • One or more of those prices isn't available in the transaction currency.

In this case, NetSuite can only choose from prices that exist for the relevant price level in the transaction currency. If only one qualifying option has a price in the transaction currency, NetSuite uses it. The tie-breaker preference won't apply because there's no longer a tie.

If there isn't a price for an item in the transaction currency, NetSuite checks for a subsidiary primary currency. If there still isn't a price, the price for that item is left blank.

Choosing a Price in a Multi-currency account

You have a sales order in GBP and two qualifying prices for the item:

  • Price A exists in GBP

  • Price B exists in USD only

NetSuite uses Price A because it's the only qualifying price available in GBP. The highest/lowest preference doesn't apply in this case.

Best Practices for Predictable Results

To make sure the preference works as you expect across currencies:

  • Set up item prices in each currency you use for transactions.

  • Make sure you set prices for every price level your price rules can return.

  • If you want the preference to decide the result, ensure the competing prices exist in the same transaction currency.

To set the tie-breaker preference:

  1. Go to Setup > Accounting > Accounting Preferences.

  2. On the Items/Transactions subtab, scroll down to the Sales & Pricing section.

  3. For the Price To Use if Multiple Prices Found For an Item preference, select your preferred option:

    • Highest Price

    • Lowest Price

General Notices