Before a pricing transformation: a retention timeline for special pricing agreement exception history

Short answer

Before a pricing transformation, inventory the special pricing approvals as they were, with their original validity dates, before new price structures are loaded over them. Then list the pricing requests in the quote tool, claims and rejections in supplier portals, and the configuration history of the rules that let exceptions through. For each, record the years covered, the owner and the real date it stops being reachable. The risk is less deliberate deletion than history being quietly reshaped.

Visual briefFull-size diagram
A horizontal project timeline from kickoff to old CPQ shutdown with five record lanes: original validity dates fade at the price reload, CPQ requests and configuration history fade at the CPQ shutdown, departing staff's claim portal access fades at a leaver date, while approval letters and order lines carry on; the faded lanes are marked as at risk unless preserved.
Illustrative timeline for a fictional distributor. Real dates come from the company's project plan, licenses and portal terms.

This timeline is part of the special pricing agreement exceptions hub. The system map shows how the records join; this page shows when, during a pricing project, each one is at risk.

The project timeline, from kickoff to the old CPQ switch-off

Illustrative: a fictional 390-person industrial distributor replaces its quote tool and rebuilds ERP price conditions over twelve months. The milestones are typical of such projects; the dates are invented.

MonthProject milestoneWhat happens to special pricing history
0Kickoff and scopeThe plan lists open approvals to migrate; expired ones are usually out of scope
3New condition design signed offOld condition types mapped to new ones; approval number field may or may not carry over
5Bulk price loadNew conditions loaded over old ones; overlapping records adjusted or replaced
6Go-liveNew quotes and orders run on the new structure
6 to 9HypercarePricing analysts who knew the old setup move to other work or leave
9Old CPQ license endsRequests, quote history and rule configuration no longer reachable unless kept

The window that matters is months 0 to 5. After the price load, the dates stored in the ERP describe the new world, not the one in which past orders were priced.

Why the dates go first

Documented ERP behavior explains it. SAP's documentation on validity periods says a new condition record may partially overlap an existing one, for example a special price valid for one month. A partial overlap adjusts the existing record's validity without a message, and an existing record wholly inside a new one is deleted on save after a system message. In Microsoft Dynamics 365, where trade agreements overlap, the agreement with the lowest price is selected when order lines are created.

Neither is a fault; both are how pricing engines keep current prices clean. But a bulk reload during a transformation creates exactly those overlaps at scale. The order lines from last year still show the special price and the approval number. What may no longer exist anywhere in the ERP is the start and end date that approval had on the day the order was priced, which is the fact that decides whether a rejected claim was the supplier's error or the distributor's.

How long each record class tends to last

There is no single answer; ask the company rather than assume. The table gives the usual pattern and the reason it differs by class.

Record classWhere it sitsWhat usually sets its lifeFirst thing lost
Original validity datesERP price conditionsOverwritten by later loads, not by a scheduleThe dates in force on a past order date
Pricing requests and quotesCPQ toolThe CPQ license and whether history is migratedExpired and lost quotes, never migrated
Approval lettersShared folders, emailMailbox and folder policies; staff leavingLetters in personal inboxes
Order lines with approval referenceERP order historyFinancial record retentionUsually kept; the reference field may be dropped in a redesign
Claims, rejections, resubmissionsSupplier portals, credit memos, emailSupplier portal terms and user accessPortal history tied to departed users
CPQ rule and workflow changesCPQ configuration, change ticketsTool replacementConfiguration history when the tool is retired

Financial records often have the longest life because tax rules reach them. The IRS generally ties record retention to the period of limitations, three years in most cases, with longer periods in listed situations. That keeps invoices and credits around; it does nothing to keep the quote, the letter or the old dates that explain them.

The pre-reload inventory: six facts per class

For each class in the table above, the pricing director or project lead fills one row. No records are opened or copied; this is a list for the people who decide.

  1. Record class, in the company's own words.
  2. Years covered, with the year coverage changes, for example when the current CPQ went live.
  3. System and administrator.
  4. Business owner, the person who decides what happens to the records.
  5. Real access deadline, from a document: the CPQ license end date, the price load date in the project plan, or a supplier portal's terms. "Soon" is not a date.
  6. What the project plan does with it: migrate, archive, leave behind or overwrite.

A line reading "Original validity dates; 2017 to now; ERP; ERP administrator; pricing director; price load in month 5 of the plan; overwrite" is the most useful sentence the inventory can produce. It tells the owner precisely what will change, when and on whose authority. The CPQ replacement guide covers the project side of the same moment.

Who approves keeping history the plan leaves out

Keeping something the project plan does not keep is a decision with costs and rules attached, and it belongs to the company.

  • Pricing director: confirms which classes explain exceptions and which are noise.
  • ERP or CPQ owner: says what is technically possible before the load or the license end.
  • CFO or controller: owns the retention policy and the financial records.
  • Counsel: reads supplier program terms and privacy limits, because approvals name end customers and keeping them has to have a reason.
  • COO, CEO or owner: decides if the classes are worth keeping for a possible licensing discussion.

Do not recommend keeping anything without that authority and a reason to keep it. Finance-led programs often fold this into a wider plan; see the finance transformation roadmap and finance transformation in private equity portfolio companies. Pricing projects in sponsor-backed distributors are covered in pricing value creation in private equity, and the who-can-license answer names the signer for a licensing discussion.

The introduced company needs 50+ full-time employees at peak (contractors excluded), documented operating history, rights to license and an authorized contact. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 90% of the data is in English. Partners sign the Channel Partner Agreement before submitting introductions. Buyer interest, supplier consent and the result of SourceX's rights review stay unknown until SourceX reviews the records with the company.

Next step

Refer a company. Earn up to $100,000. Default reward: 25% of Actual Supplier Payout, capped at $100,000 cumulatively per referred company. Eligibility and payment conditions apply, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If a distributor's price load is on the project plan and its original approval dates are still intact, register as a partner, check the company against who qualifies, and read the program terms before you introduce the pricing director.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardYour 25% of the actual supplier payout. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Is this about stopping the pricing project?

No. The project goes ahead on its own schedule. The inventory simply records which history the project will reshape or retire, and by when, so the people who own the records can decide what to do about it.

Should a partner suggest exporting the old CPQ before it is switched off?

No. A partner can point out the date and ask who decides; whether to keep anything, and how, is the company's call under its own retention policy and contracts.

Which record class is lost most quietly?

The original validity dates. Approval numbers and order lines usually survive, but a reload can adjust or replace the dates stored against them, so the system later cannot say which approval priced which past order.

Sources

  1. help.sap.com/docs/SAP_ERP_SPV/a428aae377ba4a1199c3ecc8b7f…
  2. learn.microsoft.com/en-us/troubleshoot/dynamics-365/supply-chain…
  3. irs.gov/businesses/small-businesses-self-employed/ho…
  4. refer.sourcex.si/terms

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 90% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment