To prepare a supplier price protection claim, establish the agreed coverage, preserve inventory at the agreed cutoff, and calculate the supported price difference only for eligible units. Reconcile previous credits and overlapping claims before submitting. Then track supplier acceptance, the issued credit, and finance-confirmed application separately.
A lower supplier price does not automatically create an entitlement on stock you already hold. The agreement or specific accepted price protection offer must establish whether that inventory is covered. This guide focuses on that inventory claim; changing prices on future orders is a separate action.
Download the price protection inventory and claim worksheet (Excel) to record coverage, the cutoff population, and the reconciliation.
Read the coverage before counting stock
Capture the supplier's announcement reference and the agreement or accepted offer that creates coverage. Record the exact item, supplier part number, revision, buying entity, covered locations, old and new price basis, and currency. A change to a list price might not change a negotiated purchase price by the same amount.
Make the eligibility rules explicit:
- The effective date, cutoff time, and time zone used for the claim.
- The covered receipt period, if the agreement restricts inventory by age.
- Whether stock in transit, consignment, customer locations, or third-party warehouses qualifies.
- The required ownership, condition, and availability of the inventory.
- Whether prior rebates, special pricing, returns, or earlier price protection affect coverage.
- The submission deadline, evidence requirements, and permitted correction process.
If the offer gives a date but no cutoff convention, request clarification before choosing the most favourable interpretation. Record the buyer's commercial decision and supplier clarification. The inventory analyst establishes facts; they do not expand the supplier's coverage.
Separate the inventory claim from other price work
A single announcement can trigger several jobs: checking held inventory, changing purchasing records, reviewing open POs, and assessing downstream customer commitments. Give each a distinct reference and owner. An open PO price reduction is not an issued supplier credit on held stock.
Existing ERP capabilities can support these jobs. Oracle's E-Business Suite 12.2 price protection guide describes covered-inventory calculations, supplier claims, approvals, and price-update processes. Its configuration describes that product; your agreement determines what is claimable.
Keep customer-facing commitments separate too. If your business has promised price protection to a customer, the commercial owner must establish that obligation independently. Do not assume the supplier's acceptance of your inventory claim automatically approves a customer claim, or that you can count both as retained benefit.
Preserve a cutoff snapshot that can be reproduced
Record the source system, extraction timestamp, cutoff represented, filters, and inventory locations. Retain an unchanged copy of the extract alongside the working calculation. Include the internal and supplier item identifiers, location, quantity, unit, ownership status, condition, lot or receipt references, and relevant purchase document.
Distinguish a current stock report from stock at the agreed cutoff. If the report is produced later, ask the inventory owner to reconstruct the cutoff using verified movements. Record the movement window and treatment of late postings. A receipt posted today may represent goods physically received yesterday; the rule defining the qualifying event matters.
For example, a warehouse has 520 units at the cutoff. Subsequently it receives 80 units and ships 150, leaving 450 in the later report. A reconstruction is 450 minus 80 plus 150, giving 520. This only works if all relevant movements are included and there are no unreviewed adjustments. Preserve the underlying movement references rather than submitting the arithmetic alone.
Classify every candidate quantity exactly once
Give each inventory segment a disposition: eligible, excluded with a reason, or unresolved. Use mutually exclusive categories in the total reconciliation. A unit that is both too old and damaged should not be subtracted twice.
Check transfers between your warehouses. A transfer dispatch and receiving record can describe the same units at different stages. Use the inventory owner's reconciliation to avoid counting them in the sending location, transit, and destination simultaneously. Likewise, distinguish your owned stock from supplier-owned material physically present at your site.
Keep uncertain quantities outside the submitted supported amount unless the supplier's process explicitly allows a provisional claim. Assign an owner and decision date to the uncertainty. “Not included pending ownership confirmation” is a defensible status; quietly classifying every physical unit as yours is not.
Calculate the amount by supported price basis
For a simple agreement covering a fixed reduction per eligible unit, calculate eligible quantity multiplied by the agreed reduction. Preserve any price-unit conversion. A $20 reduction per hundred units is $0.20 per unit, not $20 per unit.
Where receipts carry different protected prices, calculate separate segments using the applicable receipt or agreement basis. Do not substitute the warehouse's average inventory cost unless the agreement explicitly uses it. Finance validates the monetary calculation and handles any accounting consequences; this claim worksheet is not an instruction to change inventory valuation.
Check overlaps by supplier, price-change event, item, and covered stock or receipt segment. Another claim may use a different title or come from another site. Link earlier credits to the units they covered, and document how related rebate or special-price programmes interact under the agreement.
Work through a complete inventory-to-credit example
The following example is illustrative. The accepted offer covers buyer-owned, saleable units on hand at the specified cutoff, received within the named coverage period. It excludes in-transit stock and damaged stock. The protected unit price falls from $20 to $18; freight and taxes are outside this calculation.
Warehouse A reports 1,300 physical units, including 150 supplier-owned consignment units. Warehouse B reports 900 units, including 100 received outside the coverage period and 50 damaged units. These exclusion groups are distinct. Another 200 units are in transit and excluded under this offer.
Warehouse A physical stock 1,300
Less supplier-owned consignment 150
Eligible Warehouse A 1,150
Warehouse B physical stock 900
Less receipts outside coverage 100
Less damaged units 50
Eligible Warehouse B 750
Total eligible units 1,900
Agreed reduction per unit $2
Supported amount before previous credits $3,800
Earlier credit for 40 of these units $80
New amount requested $3,720
The supplier accepts $3,600 and disputes $120 relating to 60 units whose receipt date it questions. The owner provides the receipt evidence and tracks the $120 separately. Two credits arrive for the accepted portion: $2,400 and $1,200. Finance confirms application of the $2,400 credit; the $1,200 remains unapplied.
The full $3,800 supported amount now reconciles to $80 previously credited, $2,400 newly applied, $1,200 issued but unapplied, and $120 disputed. The earlier $80 still requires its own finance status if that has not been verified. Do not report $3,720 as settled simply because it was submitted, or add the accepted amount to its subsequent credits.
Submit the coverage evidence with the request
Lead with the price-change event, agreement reference, inventory cutoff, requested amount, and currency. Attach the eligible inventory reconciliation, receipt evidence needed to establish coverage, old and new price evidence, and previous credit references. Use the supplier's required form and channel, retaining the exact version submitted.
Ask for acceptance or a line-level explanation of differences. Save the supplier claim reference and proof of receipt. If the upload fails or is rejected for format reasons, the claim is not successfully submitted. Correct the format without quietly changing the underlying population.
Use the supplier claim evidence checklist to check that every requested amount leads back to a coverage rule and an inventory record.
Resolve cutoff disputes and late adjustments
If the supplier accepts fewer units, identify the exact segment and reason. A receipt-date disagreement needs receipt and movement evidence. A material mapping issue needs the supplier and internal item cross-reference. A disagreement about ownership or covered locations requires the commercial owner to determine whether the agreement supports the claim.
If a late correction reduces eligible stock after submission, preserve both versions and notify the supplier through its correction process. If additional supported stock is discovered, check whether an amendment or supplemental claim is allowed and link it to the original. Neither event justifies submitting a second full inventory population.
If stock is returned after the cutoff, check the offer's adjustment rules with the buyer and finance. The return may affect the claim, but its effect is not universal. Record the related return reference and the decision so a later credit does not duplicate or contradict the protection payment.
Assign the next action to the owner who can complete it
The buyer owns coverage interpretation and commercial exceptions. Inventory operations owns the cutoff and movement reconciliation. Quality confirms condition where eligibility depends on saleable or accepted stock. The claim owner coordinates submission and supplier follow-up. Finance approves the amount and confirms application or refund.
An escalation should include the disputed quantity, money at issue, evidence, and decision needed. “Approve inclusion of 60 units received before cutoff but posted later” gives the buyer a concrete choice. “Price protection blocked” does not.
Choose internal dates that leave room for the agreement's submission deadline. If an unresolved question threatens that deadline, ask the buyer whether a supported partial submission is permitted. An internal reminder or unsigned reservation does not extend supplier terms.
Close the event and measure what remains
Close the inventory claim when every submitted segment has an accepted, rejected, or otherwise approved disposition, and finance confirms the required financial follow-through. Track purchasing-record changes separately so financial closure does not hide an outdated price on the next PO. Use the supplier price-list change guide for that work.
For a defined set of covered price-change events, measure events submitted by deadline divided by events due. Report events with unresolved eligibility separately. Measure supplier-accepted amount divided by submitted amount by currency, with open disputes visible. These measures describe known events; they do not prove your team detected every supplier price change.
For financial results, retain the credit and application references and show unsettled amounts alongside settled ones. Mandel's claims and entitlements workflow helps carry the evidence, supplier follow-up, and closing records through those handoffs within your team's authority.
