What is How to Set Up Pricing in Sage 100?

Definition

Setting up pricing in Sage 100 means configuring the prices, discounts, and pricing rules used when selling products or services to customers. These settings help determine the amount charged on sales orders, quotes, and related invoices. Depending on the Sage 100 version and modules enabled, pricing can use inventory item prices, customer-specific arrangements, price levels, quantity breaks, or other supported options.

Accurate pricing keeps sales transactions aligned with approved commercial terms and helps protect margins. A consistent setup also reduces manual adjustments, supports reliable customer quotations, and gives finance teams better visibility into revenue and profitability.

Prepare Your Pricing Structure

Before changing pricing settings, define how your business determines the selling price. Consider whether prices vary by customer, item, order quantity, sales channel, or effective date. Review current price lists and customer agreements so the configuration reflects approved policies rather than individual assumptions.

  • Base prices: Establish the standard selling price for each relevant inventory item or service.
  • Customer-specific prices: Identify negotiated rates, contract pricing, or special customer arrangements supported by your setup.
  • Quantity-based pricing: Define approved price breaks where larger order quantities qualify for different unit prices.
  • Discount rules: Document which discounts are permitted and who can authorize exceptions.
  • Effective dates: Confirm when new prices begin and how your team handles existing quotes and open orders.

Keep purchasing costs and selling prices distinct. A supplier's purchase order establishes an authorized purchase, while sales pricing determines what your customer is charged. If your company is improving purchasing controls at the same time, How to Set Up a Purchase Order System Step-by-Step provides a related framework for organizing requisitions, approvals, and procurement processes.

Configure Pricing in Sage 100

The available menu paths depend on your Sage 100 release, installed modules, and company configuration. Start in the Inventory Management and Sales Order areas, then review the pricing maintenance options available in your environment. Consult your version-specific documentation if menu labels differ.

Step 1: Review inventory items. Confirm each item has the correct item number, description, unit of measure, and relevant base price. Check that prices use the intended currency and units.

Step 2: Open the applicable pricing maintenance screen. Locate the supported price maintenance or price schedule options. Determine whether the business uses standard prices, customer-specific pricing, price levels, or quantity-based schedules.

Step 3: Enter prices and rules. Add or update the relevant prices, discount conditions, quantity thresholds, and effective dates where those fields are supported. Apply the same naming and approval conventions across related price records.

Step 4: Review customer and item assignments. Verify that the intended customers and inventory items use the correct pricing arrangement. Check for overlapping or outdated rules that could produce an unexpected selling price.

Step 5: Save and test. Save the configuration and create a test quote or sales order for representative customers and items. Confirm that Sage 100 calculates the expected unit price, discount, and line total before applying the setup to live transactions.

Validate Prices and Protect Margins

After setup, compare the calculated selling price with the approved price list or customer agreement. Test ordinary orders as well as cases involving quantity breaks, customer-specific rates, discounts, and effective-date changes. Verify that the resulting totals carry through to the quote, sales order, and invoice as expected.

For example, assume an item has a standard unit price of $120 and an approved customer discount of 10%. The discounted price is $120 × (1 − 0.10) = $108 per unit. An order for 25 units would have a merchandise total of $2,700 before tax, freight, or other charges. Use a test transaction to confirm that the configured rules produce the intended result.

Pricing also needs to work with the wider ERP environment. Resources such as Best ERP Systems & Vendors in 2025 – Unbiased Scorecard and Best ERP for Small Manufacturing Business (2025 Guide) discuss ERP selection and integration considerations. For organizations connecting finance applications, Sage Intacct Integration is a related concept describing how systems exchange information and support connected business workflows.

Manage Pricing Changes and Approvals

Assign responsibility for maintaining price records and approving exceptions. Document the reason for significant price changes, the effective date, and the customer or item affected. When prices change, review open quotes and sales orders to determine whether existing commitments should retain the previously approved price or follow updated terms.

Use a consistent margin review process. Compare selling prices with current costs and applicable discounts, and investigate unexpected changes before approving transactions. Concepts such as Two Part Pricing Finance illustrate how a price structure can combine separate charges, while Private Set Intersection Finance relates to privacy-preserving data comparisons that may be relevant in selected compliance and data-sharing scenarios. Neither replaces the need to validate the actual pricing rules configured in Sage 100.

For broader finance technology initiatives, the Hyperbots Platform supports company-specific configurations for ERP integrations, workflows, roles, and general ledger structures. Its Process Specific Capabilities support finance tasks with domain-relevant AI, and Ready to Deploy Capabilities include pre-trained agents and ERP connectors. Self Learning Capabilities can use human feedback to refine supported workflows, while Human in the Loop controls keep employees involved in exceptions and approvals. When invoice validation is part of the wider process, Cut Errors & Speed Up Blanket PO Invoice Matching is relevant to matching supplier invoices against purchase order terms.

Summary

To set up pricing in Sage 100, define your pricing policy, maintain the applicable item and customer price records, configure supported discounts or quantity rules, and test representative sales transactions. Review pricing changes regularly and keep approvals documented. A controlled setup supports consistent customer quotes, accurate invoicing, and better margin visibility.