In one of our recent Sage CRM and Sage 100 integration projects, the client faced an issue where inactive salespersons were still visible and selectable in CRM during transaction processing.

This led to incorrect assignments in quotes and orders, impacting reporting and overall data accuracy.

To resolve this, we implemented a “Sync Only Active Salesperson” enhancement, ensuring that only active salespersons from Sage 100 are available in Sage CRM.

Business Requirement

The client required a solution that would:
– Prevent inactive salespersons from appearing in Sage CRM
– Ensure only valid users are assigned in quotes and orders
– Maintain consistency between Sage 100 and CRM
– Eliminate manual effort to manage inactive records

 What’s New: Key Enhancement Introduced

1. Restricting Inactive Salespersons in CRM

The system now validates salesperson status from Sage 100 during synchronization.

– If a salesperson is marked as Inactive in Sage 100
– That salesperson will not be visible in Sage CRM

This ensures that CRM always reflects only active and valid salespersons.

2. Impact on Quote and Order Creation

This enhancement directly affects transaction screens in Sage CRM.

– While creating Quotes or Orders
– Users will not see inactive salespersons in the selection list

This prevents incorrect salesperson assignment and use of outdated records.

3. Sage 100 as the Source of Truth

The control of salesperson availability is fully driven by Sage 100.

– Any status change (Active/Inactive) in Sage 100
– Is automatically reflected in CRM during sync

This ensures no manual cleanup is required in CRM.

How This Enhancement Helps Businesses

– Accurate Sales Assignment
– Cleaner CRM Data
– Reduced Manual Effort
– Improved Reporting Accuracy

The Sync Only Active Salesperson enhancement ensures that Sage CRM always stays aligned with Sage 100 by allowing only active salespersons to be used in transactions. By preventing inactive users from appearing in quote and order screens, this solution improves data accuracy, reduces errors, and enhances overall system reliability.