Tip #1404 – Using Sales IQ Filters in Versions 2013 and Above

/in /by

The Sales IQ Filters screen has been redesigned to include or exclude “ranges” of selection criteria.  For example, instead of selecting one State/Region code you can now enter a range of State/Region codes to filter on and then include them or exclude them from the list.  The new features include:

  • Selection Criteria field with options Starts With, Contains, or Does Not Contain
  • Value fields to be used in conjunction with the Selection Criteria fields
  • Include or Exclude This Range field

Example:

In the following example we will filter all customers in the State/Region range of OH439 thru OH440.

  1. In the Customer section of the Filters screen select Starts With from the drop down box in the State/Region field.
  2. Enter OH439 in the lookup field directly to the right of Starts With.
  3. Enter OH440 in the lookup field directly to the left of Include/Exclude This Range.
  4. SelectInclude this Range from the range drop down box.
  5. Select the Apply Button.Filters Screen
  6. After selecting Apply, you will be returned to the Sales IQ screen and only customers in State/Region code range OH439 thru OH440 appear in the Customer list.
  7. To clear the filter select Normal Data from the Filter drop down list.SIQ Screen

Case Study: Bowerman Marketing Group

/in /by

“dynaMACS takes reporting capabilities to new levels.”

Judy Tingley, Office Manager
Jane Janosik, Customer Service
Bowerman Marketing Group

Bowerman_Marketing_Group_LogoClient Challenge

In 2004, Bowerman Marketing Group learned that the sales agency software they had been using was discontinued. The software had been sufficient and provided the agency with good information about sales and commissions. When seeking new software, Office Manager Judy Tingley visited dynaMACS at a trade show. She quickly realized that dynaMACS provided everything that their old software did and much more.

Bowerman_Marketing_Group_Statistics

dynaMACS Solution

“I was pleased with the reporting capabilities. The number of choices to sort sales and commission information was greatly enhanced,” she says. “dynaMACS provides the flexibility in reporting that we need. Our sales force benefits from territorial reports by salesman. The specific agency reports provide valuable overall information by manufacturers and customers. It enables us to view where the most activity is, where we need to improve our efforts and to cover our territory more effectively and efficiently”.

Jane Janosik, primary user of dynaMACS, provides the owner with weekly and monthly reports. She notes, “The software helps us run the business.”Janosik likes the monthly and year-to-year comparison data and uses this to assess reports from the manufacturers.

Tingley recalls the process of transferring data from the old software to dynaMACS. “dynaMACS customer service helped us every step of the way and nothing was lost in the process.”

Now, years later, dynaMACS is there whenever the agency needs assistance. “We always get a timely response and the representatives are very helpful and patient. They answer our questions, resolve our issues and continue to make improvements to the software.