How Customer Pricing Works
Customer pricing starts with defining the customer's standard terms and any applicable exceptions. A business may maintain standard prices for all customers, discounted prices for selected accounts, or separate pricing arrangements for wholesale, retail, and contract customers. During sales order entry, Sage 100 uses the configured pricing setup to determine the applicable price for the item and transaction.
For example, a supplier may list a product at $250 per unit but offer an approved customer a contract price of $225. When the customer orders 40 units, the expected merchandise value is 40 × $225 = $9,000 before tax, freight, or other adjustments. The sales team should verify the price on the order and resulting invoice against the agreement.
A customer's purchase order may specify agreed quantities, item references, or contracted prices. Comparing these details with the sales order helps both parties confirm that the transaction reflects the intended commercial terms.
Key Pricing Components and Controls
Customer pricing is most effective when each rule has a clear purpose and can be traced to an approved business agreement. Important elements include:
- Customer eligibility: Identify the customer or customer group entitled to a particular price.
- Inventory item: Confirm that the rule applies to the correct item and unit of measure.
- Price and discount: Maintain the approved selling price or discount method and verify how it interacts with other pricing rules.
- Quantity breaks: Where configured, apply different prices based on the quantity purchased.
- Effective period: Keep promotional or contract prices aligned with their approved start and end dates when date-based rules are available.
- Change approval: Record who authorized price changes and when they become effective.
Price reviews should consider product cost, expected margin, customer commitments, and market conditions. For cross-entity transactions, Transfer Pricing For Cash Pooling provides related context on pricing arrangements within broader treasury and intercompany finance practices; it is distinct from ordinary customer selling-price maintenance.
Customer Pricing and Revenue Collection
Correct pricing supports accurate invoicing, but it also affects the amount customers are expected to pay. When invoices contain a price that differs from the agreed amount, the customer may raise a dispute or delay payment. Reviewing quotes, orders, shipment records, and invoices helps teams resolve discrepancies and protect collection timelines.
After billing, collections activities can include reminders, dispute follow-ups, and recording promises to pay. The Order-to-Cash Process: Complete Guide to O2C Automation explains how these activities fit into the broader cycle of converting sales into collected cash. Strong collections practices complement customer pricing controls because a correctly priced invoice still needs timely follow-up and settlement.
Businesses may use collections tools to prioritize overdue accounts and coordinate customer communications. AR Automation Software supports collection follow-ups and payment-to-invoice matching, while the collections process focuses on securing payment rather than deciding the original selling price. The term receivables describes amounts customers owe the business and helps finance teams track the outstanding balance generated by invoiced sales.
Pricing Data, Reconciliation, and ERP Integration
Customer master data, inventory records, sales orders, and invoices should remain aligned so that the correct pricing information flows through the transaction. Customer Reconciliation is the process of comparing customer account records with supporting transaction or payment information to identify differences and confirm account accuracy.
For organizations using more than one financial application, integrations can help synchronize relevant records across systems. The Hyperbots Platform supports finance and accounting automation with document processing and ERP integration, while Sage 100 pricing rules still need to be maintained and validated within the appropriate system configuration. Before changing a connection or data flow, confirm which application is authoritative for customer terms and item prices.
For the broader receivables workflow, cash application matches incoming payments to open invoices and records the settlement against the appropriate customer balance. This process helps distinguish a pricing dispute from an invoice that has been paid but not yet applied.
Best Practices for Managing Customer Prices
Review customer pricing whenever a contract changes, a promotion ends, a product cost shifts materially, or a customer moves to a different commercial tier. Test representative customer-item combinations after updates and compare sample quotes, orders, and invoices with approved price lists. Monitor discounts and gross margins by customer to identify arrangements that no longer meet business objectives.
Document exceptions and communicate effective dates to sales, customer service, and finance teams. Keep pricing access aligned with employee responsibilities, and retain supporting approval records. If automation is introduced around related finance workflows, define the data fields and approval points that must remain consistent with Sage 100 records.
Summary
Sage 100 Customer Pricing helps businesses apply customer-specific selling prices and discounts consistently across sales transactions. Well-maintained customer and item data, clear pricing rules, controlled changes, and regular invoice checks support accurate billing, stronger margin visibility, reliable financial reporting, and timely cash collection.