How the Pricing Hierarchy Works
When entering a sales order or invoice, the system uses the available customer and inventory information to determine the appropriate selling price. Businesses should understand which records and rules take precedence in their particular setup rather than assuming every installation follows an identical sequence. Customer-specific agreements, item pricing records, quantity breaks, and standard prices should be reviewed together to establish expected results.
For example, a distributor may normally sell an item for $100, offer a contracted customer price of $92, and provide a volume price of $88 for orders of 50 units or more. The business must verify how these rules interact in its configuration so the correct price is selected and any authorized override is recorded.
Key Pricing Components
Several data elements can influence the final selling price. Customer price levels support different commercial arrangements, while item records establish the products and units being sold. Quantity-based breaks can reward larger orders, and promotional or contract terms may apply under defined conditions. Effective setup also requires consistent units of measure, valid dates, and clear procedures for maintaining customer-specific exceptions.
- Standard item price: The baseline amount used when no more specific applicable rule takes precedence.
- Customer-specific pricing: Agreed rates for selected accounts, contracts, or customer groups.
- Quantity breaks: Prices that change when an order reaches a specified volume.
- Price overrides: Authorized adjustments made to reflect a negotiated deal or approved exception.
These components should align with the business's sales policies and its financial controls. An Approval Hierarchy can define who reviews exceptional discounts or margin reductions, while an Authorization Hierarchy establishes which roles are permitted to approve or execute particular changes.
Calculating the Effective Selling Price
The effective selling price is the amount applied to each unit after the applicable pricing rules and authorized adjustments have been considered. For a straightforward order, the extended line amount can be calculated as:
Extended line amount = Effective unit price × Quantity
Assume a customer orders 60 units. The standard price is $100 per unit, but the customer's applicable contract rate is $92. If the configured rules select that contract rate and no further discount applies, the calculation is 60 × $92 = $5,520 before taxes, freight, or other charges. If the quantity qualifies for a $88 price instead, the line amount becomes 60 × $88 = $5,280. The $240 difference shows why finance and sales teams need to verify the precedence of contract and volume pricing rules.
ERP Integration and Finance Controls
Sage 100 pricing should be considered alongside the wider ERP environment. When organizations compare platforms or extend their finance workflows, resources such as Best ERP Systems & Vendors in 2025 – Unbiased Scorecard and Best ERP for Small Manufacturing Business (2025 Guide) can help frame decisions about system fit, integration, and operational requirements. ERP Pricing Models: License, Subscription & Hidden Costs provides a separate lens for evaluating the software investment rather than the selling prices configured inside the ERP.
For finance teams extending workflows with AI, Hyperbots Platform supports company-specific configuration of ERP integrations, roles, workflows, and general ledger structures through a no-code framework. Its Process Specific Capabilities support finance automation tailored to particular workflows, while Ready to Deploy Capabilities combine pre-trained agents, ERP connectors, and configurable setup. Self Learning Capabilities allow workflows and coding suggestions to improve through feedback, and Human in the Loop processes retain human review for exceptions and approvals.
Organizations using other Sage products can also explore AI Copilots for Sage 300 to understand how AI-supported finance workflows can improve productivity and processing accuracy in that distinct ERP environment. For integration planning, Sage Intacct Integration describes the separate considerations involved in connecting Sage Intacct with other systems; it should not be confused with Sage 100 configuration itself.
Best Practices for Maintaining Pricing Accuracy
Review pricing rules whenever contracts, customer segments, product costs, or sales policies change. Test representative orders before rolling out updates, including customers with negotiated rates and orders that cross quantity thresholds. Reconcile selected order lines against approved price lists and review margin reports for unexpected changes. Document who may maintain price records, who can override prices, and which exceptions require review.
When a sales order uses an unexpected amount, check the customer record, item pricing setup, quantity break, effective dates, units of measure, and any manual override. A clear Pricing Model documents how the business determines prices, while Two Part Pricing Finance explains a different approach in which a fixed charge is combined with a usage-based charge. These concepts help teams distinguish ordinary item pricing from broader commercial pricing structures.
Summary
Sage 100 Pricing Hierarchy determines how available pricing rules interact to select a selling price for a customer order. Accurate configuration, documented overrides, and regular testing help businesses maintain consistent quotes, protect margins, and support dependable financial reporting. Because precedence can vary by setup and version, confirm the configured behavior using representative customer and item records before changing pricing policies.