6-dimensional price lookup
Customer + region + channel + currency + date + quantity-tier. The lookup picks the most specific match.
Item Master Software | Price Lists & Discount Engine
Customer, region, channel, currency, date and quantity-tier dimensions. The right rate selects automatically at quote, sales order and invoice time. Date-effective overrides for promotions. Approval-routed customer-specific overrides. Audit trail per change.
How it works
Customer + region + channel + currency + date + quantity-tier. The lookup picks the most specific match.
Promotional pricing for a specific date range overlays the base list. End-date enforced; the list reverts cleanly when the promotion ends.
Per-customer rate overrides on top of the regional or channel base. Approval-routed where the override is below cost or above the policy threshold.
Every price-list change captures the user, timestamp, before-after rate and reason. The CFO sees price-list activity on a dashboard.
What the system does
| Capability | Input | Output |
|---|---|---|
| 6-dimensional lookup | Customer + region + channel + currency + date + qty | Most-specific rate per line |
| Date-effective overrides | Promotion start + end + delta | Overlay on base list during window |
| Customer overrides | Customer + item + rate + approver | Per-customer rate with approval |
| Quantity tiers | Quantity break + tier rate | Tiered pricing applied at order |
| Multi-currency lists | Currency-specific base list | Native currency rate with FX fallback |
6-dimensional lookup
Date-effective overrides
Customer overrides
Quantity tiers
Multi-currency lists
Compliance + integrations
Price-list changes are revenue events. The audit trail captures the change, the approver and the rationale. Below-cost or above-policy overrides require explicit approval.
Regulations we work within
AS-9 / Ind-AS 18 (Revenue)
Price-list rate at invoice posts as gross revenue; discounts as deduction.
Section 92, Income Tax Act (Transfer Pricing)
Inter-company prices captured per the TP policy.
Rule 11(g), Companies Act
Price-list edit trail.
Connects to
Price Lists & Discount Engine FAQ
Most-specific wins. Customer-specific override beats regional list; date-effective promotion beats base list; quantity-tier beats single rate. Where two equally-specific rules exist, an explicit ranking is configurable per organisation.
Yes, with approval. Below-cost or below-policy rates trigger an approval workflow. The discount, the approver and the reason are captured. The CFO sees discount approvals on a daily dashboard.
Inter-company price lists carry the TP markup (e.g., cost + 5%). The TP policy is documented per inter-company pair. Form 3CEB drafts from the tagged inter-company transactions.
The native-currency rate from the price list is the base. Conversion to INR uses the rate at the transaction date (RBI reference rate by default; pinned forward rates supported for groups with treasury hedging).
More in Item Master Software
Per-customer overrides on master price lists. Approval-routed; audit-trailed.
See Customer-Specific PricingGoods, services, fixed assets, defined once with internal SKU, vendor SKU and lifecycle status.
See Items & SKUsHierarchical groups for analytics, GL mapping and approval routing. Bulk edits roll down.
See Item Groups & CategoriesConnect one entity, free. Upload your existing price-list spreadsheet. The system maps it to the 6-dimensional model and runs auto-rate-selection on a sample of last quarter's invoices.