Sales Price Lists are the primary tool for managing customer pricing in Business Central. They allow organizations to:
- Create customer-specific pricing
- Manage quantity-based pricing
- Offer promotional pricing
- Apply discounts and contract pricing
- Centralize pricing management
The pricing engine ensures sales teams receive the correct pricing during quote and order entry while supporting a variety of pricing strategies.
Sales Price List Setup
Within the Sales & Receivables Setup page, organizations can configure pricing settings, including:
- Edit Active Prices options
- Default Price List Codes
- Customer lookup settings
If a price list is active and editing is restricted, changes cannot be made until the list is returned to Draft status.
Managing Price List Statuses
Each price list can have one of three statuses:
- Draft – Used when creating or modifying a price list
- Active – Available for pricing calculations
- Inactive – Retains historical pricing information without affecting current pricing
The draft list must be reactivated before any changes become available to users.
Building Price List Lines
Price list lines provide detailed pricing controls and can be assigned to:
- Customers
- Customer Price Groups
- Customer Discount Groups
- Campaigns
- Contacts
Organizations can define pricing at a granular level by setting effective dates, product types, discounts, and pricing rules. Available product types include:
- Items
- Item Discount Groups
- Resources
- Resource Groups
- Service Costs
- G/L Accounts
Both header and line-level date ranges must be valid, with the header taking priority.
Adding and Maintaining Pricing
Business Central offers several ways to build and maintain price lists:
- Manually enter pricing lines
- Use the Suggest Lines feature to automatically pull items into a price list
- Use Configuration Packages for bulk pricing updates through Excel
The Suggest Lines feature can significantly reduce data entry by bringing in default item pricing from item cards.
How Pricing Calculations Work
Business Central evaluates all active pricing options when determining the final sales price. Important considerations include:
- The system applies the lowest valid pricing available to the customer.
- Price discounts and line discounts can work together if both are available.
- Overlapping active price lists can create unexpected pricing results.
Because of this, organizations should carefully manage start and end dates and avoid unnecessary overlap between active price lists.
Price Verification and Troubleshooting'
Before a price list becomes active:
- Verify all pricing lines.
- Resolve duplicate or conflicting pricing entries.
- Confirm pricing changes have been activated.
The Price Overview feature is especially useful for:
- Testing new price lists
- Validating customer-specific pricing
- Researching pricing discrepancies
- Confirming which price list is driving a specific price
Additional filters make it easier to investigate pricing across customers, items, and price lists.
Important Limitations
When working with Sales Price Lists, keep the following limitations in mind:
- Negative discounts are not supported.
- Price lists work inclusively and do not support exclusions.
- It can be difficult to identify items that appear on multiple active lists without reviewing the Item Card or Price Overview.
- Exporting data to Excel can help identify duplicate pricing entries and overlapping rules.
Key Takeaways
- Sales Price Lists provide centralized control over customer pricing and discount strategies.
- Price lists should be carefully managed using Draft, Active, and Inactive statuses.
- Effective dates help prevent pricing conflicts and outdated pricing from being applied.
- The Suggest Lines feature simplifies price list creation and maintenance.
- Business Central evaluates all active pricing and generally applies the lowest valid option available.
- The Price Overview feature is a valuable tool for testing, troubleshooting, and validating pricing rules.
- Maintaining clear pricing structures with minimal overlap helps ensure accurate pricing and a better customer experience.
