Loading

Salesforce CPQ Error: 'Price Rule [ID]: Multiple Results Returned from the Query' in Quote Line Editor

Дата публикации: Jun 26, 2026
Описание

When a Price Rule is configured to use a Lookup Object, the lookup query must return exactly one record for each targeted quote line, quote, or product option. If the query returns multiple records, Salesforce CPQ cannot determine which value to apply and throws the following error:

"Price Rule [ID]: Multiple results returned from the query. Please contact your Salesforce CPQ administrator"

The ID in the error message is the record ID of the Price Rule causing the issue. This can occur in two scenarios:

- Duplicate records exist in the Lookup Object that match the query criteria

- A numeric value in the Lookup Query contains a comma (for example, 300,000 instead of 300000), which causes CPQ to misparse the value and match unintended records, even when no true duplicates exist

Решение

Identify whether duplicates or a comma-formatted value are causing the multiple results, then apply the appropriate fix below.

**Identify the affected Price Rule and records:**

1. Locate the Price Rule record using the ID shown in the error message.

2. Review the Lookup Query criteria configured on the Price Rule.

3. Compare the quote line, quote, or product option field values against the Lookup Object table to identify which records are being returned.

 

**Remove duplicate records:**

1. Query the Lookup Object for records matching the criteria from Step 3.

2. Identify and delete duplicate entries so only one record matches the query for any given set of input values.

**Add filters to restrict results:**

1. Open the Price Rule record and navigate to the related Lookup Query records.

2. Add additional Lookup Query filter conditions to narrow results to a single matching record.

3. Save and re-test the Price Rule in the Quote Line Editor.

**Fix comma-formatted numeric values:**

1. Open the Lookup Object records associated with the Price Rule.

2. Locate any numeric values in lookup fields that contain commas (for example, 300,000).

3. Remove all commas from numeric values (for example, change 300,000 to 300000).

4. Save the records and re-test the Price Rule in the Quote Line Editor.

Commas within numeric lookup values cause CPQ to misinterpret the value during query comparison, returning unexpected results even when no duplicate records exist.

For additional guidance, review the Salesforce CPQ documentation on Lookup Price Rule query considerations.

Номер статьи базы знаний

000383686

 
Загрузка
Salesforce Help | Article