Salesforce AP-223 - CPQ and Billing Consultant Accredited Professional

Scenario SummaryUniversal Containers sells a bundle “Corporate IT Solutions.”

Inside it is a product option: Hardware Firewall.

Requirement:

If the customer previously purchased that Hardware Firewall (historical purchase),

Then hide the product option inside the bundle during configuration.

This is a Configuration Rule

Using Selection/Filter logic to hide options

The rule must trigger as soon as the bundle loads, because the product option must be hidden before the user interacts with the bundle.

What type of Product Rule?Which Evaluation Event is Correct?Salesforce CPQ Product Rule Evaluation Events:

Event

When it Fires

Typical Use

Load

When the configuration page loads the first time

Hide/show options, preselect options, set initial values

Edit

On any user modification

Rerun rules based on changes

Load and Edit

Both events above

When both initial setup and change handling are required

Save

When the quote line editor is saved

Validation rules that block save

We need the product option to be hidden immediately when configuring the bundle.

It is not dependent on user edits.

It uses historical purchase data (Opportunity Product / Asset / Subscriptions).

In this requirementTherefore, the rule should fire at initial load only, not waiting for user interaction.

Always → not a valid Product Rule Event type in CPQ.

Save → too late; user would see the option before it's hidden.

Load and Edit → unnecessary; we do not need edits to trigger this rule.

Edit → would fail because hiding must occur before user interaction.

Why Not the Others?Salesforce CPQ Documentation AlignmentCPQ Product Rules documentation states:

Use Load when you want the rule to evaluate immediately when the configurator opens, typically for hiding, filtering, or preselecting options.

This matches the required behavior perfectly.

This use case describes a three-dimensional pricing model where the price of a product is determined by length × width × height. These values are user selections (likely stored on Quote Line fields), and CPQ must determine the correct price based on a matrix of dimensions.

Salesforce CPQ documentation identifies Lookup Tables used with Price Rules as the standard method for implementing matrix or multi-attribute pricing.

✔ Why Price Rule with Lookup Table is the correct answerSalesforce CPQ Lookup Tables allow you to store pricing data externally from the product record and return the correct price based on multiple inputs.

Lookup tables can key off of multiple dimensions, e.g.:

Length

Width

Height

A price rule performs the lookup at calculation time and sets:

List Price, or

Custom price field

Create custom fields on Quote Line:

Length__c

Width__c

Height__c

Build a Lookup Table with key columns:

Length range

Width range

Height range

Resulting price

Build a Price Rule that uses:

Price Conditions → to map entered dimensions

Lookup Query → to fetch matching price

Price Action → to set the Quote Line's Unit Price

Relevant capabilities:Typical CPQ design for dimensional pricing:This is exactly the pattern Salesforce recommends for multi-attribute pricing.

❌ Why the other options are incorrectA. Percent of TotalUsed for:

Support fees

Add-on fees based on parent productsNot for dimensional pricing.

B. Multi-Dimensional Quoting (MDQ)Used for:

Term-based pricing (Year 1, Year 2, Year 3)

Usage tiers over time

MDQ does not support 3-dimensional physical attributes.

C. Discount ScheduleSupports:

Volume tiering

Quantity-based pricing

Does not support multi-attribute dimensional pricing.

A Revenue Cloud consultant leading scoping must have:

A – Excellent communication: Key for translating technical and business requirements.

B – Planning/monitoring/review skills: Required to drive structured discovery workshops.

E – Awareness of design pitfalls & mitigation: Ensures a scalable CPQ/Billing architecture.

Options C and D are irrelevant: competitor knowledge or sales quota experience are not key skills for scoping a CPQ/Billing project.

The CPQ Quote Calculator runs in a designated Service Region. Performance increases significantly when:

The service region is geographically close to the Salesforce org.

Since the org is hosted in the EU:

✔ D — Europeis the correct service region, which reduces latency and speeds calculation.

Why the others are wrong:Option

Why Incorrect

A — No performance impact

100% incorrect; region affects latency heavily.

B — North America

Far from EU, adds latency.

C — Japan

Even slower.

E — Australia

Worst possible latency option.

Thus D is correct.

Universal Containers wants:

ARR__c on Opportunity Line Item (Opportunity Product)

But ARR is currently on SBQQ__QuoteLine__c

They want ARR captured in pipeline reports without adding automation.

Salesforce CPQ Behavior:During Quote → Opportunity sync, CPQ automatically maps fields only if:

The same API name exists on both objects

The field types match

The field-level security is correct

If these conditions are met, CPQ automatically handles field synchronization.

Therefore:

✔ C. Create ARR__c on Opportunity Line Item with matching field configurationThis leverages native CPQ field mapping, requires zero automation, and is the recommended Salesforce approach.

Why the other options are incorrect:Option

Why Incorrect

A. Price Rule to copy value

Price rules do not run on Opportunity Products; rules run only on Quote Line Editor.

B. Flow

Extra overhead and maintenance—unnecessary when CPQ already supports native field sync.

D. Cross-object formula

Opportunity Line Item cannot reference Quote Line fields (different object trees). Salesforce prevents this.

Thus, C is the only correct and efficient solution.

The three core principles of scoping a Revenue Cloud (CPQ + Billing) project are:

✔ A — Alignment with customer on CPQ & Billing terminologyCPQ/Billing have specific terms (bundles, subscriptions, MRR, usage, amendments).

Shared vocabulary is essential for project success.

✔ C — Lead with business requirements and processSalesforce methodology stresses understanding:

Selling motions

Billing processes

Amendment/renewal lifecycle… before discussing configuration or technology.

✔ D — Think transformation before customizationRevenue Cloud succeeds when customers improve processes rather than recreating legacy systems.

Why the incorrect options fail:Option

Why Incorrect

B. Add new technology to existing process

Bad practice. Revenue Cloud encourages redesigning outdated processes, not replicating them.

E. Interview customer first before knowledge sharing

Opposite of best practice. Discovery is collaborative; knowledge sharing happens early.

User Story“As a pricing manager, bulk discounts must include previously purchased quantities for pricing calculations on the quote to reward loyal customers.”

This refers to historical purchases influencing tiered or volume discounts.

In Salesforce CPQ, the only native feature that supports “include prior purchases when calculating discount tiers” is:

✔ Discount Schedules with Cross Orders enabledThis setting tells CPQ to:

Look at existing subscriptions, assets, orders, and previous quote lines

Aggregate prior quantities

Apply tiered volume discount based on the total owned quantity + new quantity

But for Cross Orders functionality to work…

✔ Historical Subscriptions / Assets must existSo you must migrate historical:

Contracts

Subscriptions

Assets (if asset-based ordering)

Without that data, CPQ cannot aggregate historical quantities.

Correct answer: B and E✔ B — Populate Contracts, Subscriptions, and Assets with historical dataCPQ needs these to calculate previously purchased quantities.

✔ E — Discount Schedules with Cross Orders checkedThis is the actual feature that uses prior purchased amounts to determine discount tiers.

Why the other options are not correct:Option

Why Incorrect

A — Custom Action

Unnecessary. CPQ has native Cross Orders behavior.

C — Summary Variable

Summary variables do not summarize external historical purchases.

D — Migrate Orders & Invoices

Not required for CPQ pricing. Only Subscriptions/Assets matter.