Connectors

/

Salesforce

/

Salesforce quote discount audit
Report

See where Salesforce quotes are giving margin away

For sales leaders and deal desks who want heavy discounts and inconsistent pricing across quotes found, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Salesforce quote discount audit
Audit discounting on Salesforce quotes from the last 30 days and flag anything over 20 percent.
I reviewed 86 quotes and 412 lines, with an average discount of 14 percent. - Over 20 percent: 37 lines, the deepest 42 percent on Q-1042 for Contoso Ltd - Inconsistent: X200 Scanner quoted from 780 to 1,150 USD - Over list: 3 lines - Heaviest account: Fabrikam Inc, 26 percent on average Want the flagged line table?
Salesforce
Sample figures. Your results come from your own account.
salesforce-get-quote
salesforce-get-quote-line-item
salesforce-get-price-book-entry

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Salesforce

Salesforce
Run it on your own Salesforce data.

Connect Salesforce, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Discounts creeping up one quote at a time

Discounting creeps up one quote at a time. Without checking every Salesforce quote line against list price, nobody sees a rep giving away 40 percent, the same product quoted at wildly different prices or lines above list by mistake.

Without PopdockAI

  • Export quote lines and list prices
  • Work out each line's discount in a spreadsheet
  • Compare prices for the same product by hand
  • Notice the margin loss after deals close

With PopdockAI

  • Each line's discount is worked out against list price
  • Missing list prices are looked up in the price book
  • Heavy, inconsistent and above list pricing is flagged
  • Read only, with the heaviest discounting by product and account

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Audit discounting on quotes created in the last `{lookback-days}` days (default 30), flagging lines discounted more than `{max-discount-percent}` percent (default 20).

**Step 1: Pull quotes**

Call `salesforce-get-quote` with `created-date.from` set to today minus `{lookback-days}` days and `max-records` 200.

**Step 2: Check lines**

For each quote, call `salesforce-get-quote-line-item` with `quote-id`. For each line, the discount is 1 minus sales-price divided by list-price (or the discount field when present). When list-price is missing, call `salesforce-get-price-book-entry` with `product-id` and `active` true to find it.

Flag:

* lines discounted more than `{max-discount-percent}` percent
* the same product quoted at very different prices across quotes
* lines priced above list
* products with no active price book entry

**Step 3: Report**

* Quotes reviewed, lines reviewed, average discount.
* A table of flagged lines: quote number, account, product, list price, sales price, discount percent, flag.
* The products and accounts with the heaviest average discount.

**Rules & Guidelines:**

* This prompt is read-only. Do not call any write tool: `salesforce-add-account`, `salesforce-add-contact`, `salesforce-add-lead`, `salesforce-add-opportunity`, `salesforce-add-case`, `salesforce-add-task`, `salesforce-add-asset`, `salesforce-add-campaign`, `salesforce-update-account`, `salesforce-update-contact`, `salesforce-update-lead`, `salesforce-update-opportunity`, `salesforce-update-case`, `salesforce-update-task` or `salesforce-update-asset`.

**Validation:**

* If no quotes were created in the window, say so and stop.

Who it's for

One answer, three teams that use it

Sales leaders

Protect margin before deals close

See which products and accounts carry the heaviest discounts while there is still time to step in.

Which Salesforce quotes this month have discounts over 30 percent?

Deal desk

Catch inconsistent pricing

Spot the same product quoted at very different prices and lines priced above list by mistake.

Audit quote discounts from the last 60 days and show products quoted at inconsistent prices.

Finance business partners

Track average discount over time

Get totals and the average discount across quotes for a margin review.

What was the average discount on Salesforce quotes last quarter, and which accounts got the most?

How it works

What PopdockAI does when you ask

You optionally set a window and a threshold, and your AI assistant audits recent quote lines for discounting. It only reads, so no quote is changed.

01

Ask

You optionally set a lookback window and a discount threshold.

Your AI tool

02

Read

It reads recent quotes and their lines, finding list price where it is missing.

salesforce-get-quote
salesforce-get-quote-line-item
salesforce-get-price-book-entry

03

Flag

It flags heavy discounts, inconsistent prices, lines over list and unpriced products.

No items found.

04

Report

You get totals, flagged lines and the heaviest discounting by product and account.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Salesforce and one secure connection to your AI tool. No code, no exports.

get-data

salesforce-get-quote

Returns Salesforce quotes with their opportunity, account, contact, status, subtotal, discount and expiration date. Filter by name, quote number, opportunity, account, status, grand total, expiration date and created date.
get-data

salesforce-get-quote-line-item

Returns the lines of Salesforce quotes, with product, quantity, list and sales price, discount and total. Filter by quote, product and total price.
get-data

salesforce-get-price-book-entry

Returns the list prices of products in Salesforce price books, and whether each entry is active or uses the standard price. Filter by price book, product, product code, list price and active flag.
Read only.Nothing in Salesforce Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

See where margin is given away, and by whom

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation