Business Central Fixed Ranges: A Practical Guide
This practical guide explains how to use fixed ranges in Microsoft Dynamics 365 Business Central to restrict products available for sale, ensuring sales teams adhere to approved item lists and improving order accuracy; by the end of this article, you’ll understand what fixed ranges are, how they solve common challenges, and how Sysco Software’s Fixed Ranges app can streamline their implementation.
The Challenge: Uncontrolled Sales Transactions
In many businesses, particularly those dealing with a diverse product range or serving distinct customer segments, the freedom to add any item to a sales order can lead to problems.
Common Problems with Unrestricted Sales
Several issues arise when sales transactions lack controlled product selection:
- Sales representatives might offer items that are discontinued or unavailable.
- Offering the wrong products can lead to incorrect pricing.
How Sysco’s Fixed Ranges App Provides a Solution
Sysco Software’s Fixed Ranges app addresses these challenges by providing a structured way to control which products can be added to sales transactions based on customer or customer group. It builds upon the standard Business Central functionality, offering enhanced flexibility and ease of management.
What are Fixed Ranges?
Fixed ranges in Microsoft Dynamics 365 Business Central define lists of approved items that specific customers or customer groups can purchase. When enabled, sales users can only select products from these predefined lists when creating sales orders or quotations for those customers.
Key Features and Benefits of the Fixed Ranges App
The Sysco Software Fixed Ranges app extends Business Central’s core functionality with several key features that enhance usability and control:
- Define approved item ranges for individual customers.
- Apply fixed range restrictions to entire customer groups.
- Add individual items or item groups to a fixed range.
- Easily copy existing fixed ranges to create new ones.
- Facilitates structured range management for both head office operations and individual customer account requirements.
Benefits of Using Fixed Ranges
- Reduce errors by restricting product selection to approved lists.
- Ensure sales teams offer only appropriate products, aligning with business strategies.
- Minimize manual intervention and accelerate order processing times.
- Prevent the sale of unavailable items, maintaining accurate stock levels.
Implementing Fixed Ranges: A Step-by-Step Guide
Setting up fixed ranges in Business Central involves several steps.
1. Defining Item Groups
Start by defining item groups to categorize your products.
2. Creating Fixed Ranges
Create fixed ranges for each customer or customer group, specifying the approved items or item groups that can be added to sales transactions.
3. Assigning Fixed Ranges to Customers/Customer Groups
Assign the created fixed ranges to individual customers or customer groups within Business Central.
4. Utilizing Copy Functionality (Sysco App Feature)
Leverage the copy functionality within the Sysco Software app to quickly create new fixed ranges based on existing ones, saving time and ensuring consistency.
5. Testing and Validation
Thoroughly test the setup by creating sales orders for customers with assigned fixed ranges to ensure products are correctly restricted and approved items are available.
Optimising Your Fixed Range Setup for Head Office and Customer Accounts
To maximise the effectiveness of your fixed range implementation, consider these optimisation strategies:
Head Office Control
- Maintain a central repository of fixed ranges managed by head office to ensure consistency across all customer accounts.
- Use standardised item groups for consistent product categorization and easier range management.
Customer Account Customisation
- Create tailored fixed ranges for individual customers with unique product requirements or contractual agreements.
- Regularly review and update fixed ranges to reflect changes in product availability, customer needs, or business strategies.
Leveraging the Sysco Software App
The Sysco Software Fixed Ranges app streamlines these processes by providing user-friendly tools for range creation, copying, and management, reducing administrative overhead and ensuring accuracy.
Sysco Software Essentials: More Apps to Enhance Business Central
The Fixed Ranges app is just one example of how Sysco Software Essentials can enhance your Microsoft Dynamics 365 Business Central experience. We offer a suite of quick-start applications designed to address common business challenges and improve operational efficiency.
- BACS Payment Processing App: Simplify supplier payments with automated bank file generation.
- Batch Emailing App: Automate customer communication with batch email routines.
- Close Prices App: Prevent overlapping price lists and maintain pricing governance.
- Credit Control App: Enforce credit limits and protect cash flow.
- Direct Debits App: Streamline direct debit processing for improved accounts receivable management.
Explore our full range of Essential Apps and discover how Sysco Software can help you unlock the full potential of your Business Central investment. Learn more about our Microsoft Dynamics 365 Business Central Essential Apps here.


