Tip #1405 – Maximize the dynaMACS State/Region Zip Code Feature

dynaMACS has a powerful feature that automatically populates the State/Region field based on the Zip Code entered when adding or updating customer records (provided a valid 5 digit zip code is used).  The use of the State/Region code is beneficial when generating reports in either Sales IQ or a Sales Analysis report.  The following instructions show you how to activate this feature.

***IMPORTANT!  PLEASE create a restore point before activating this feature and running the utilities!***

Example of a State/Region Report printed from Sales Analysis Rpt Generator:

Report Sample

Step 1:  Turn on the Auto Build State/Region Feature in System Information Setup

  1. From the dynaMACS main screen select Other Functions>Administration>System Information Setup.dynaMACS Main Screen 1
  2. Select the System Options tab.
  3. Check the box Automatically build State/Region upon Zip Code Change?
  4. Select the Save button.Sys Info Setup Screen

Step 2:  Run System Utility 1007 (Creates Customer State/Region codes table)

  1. From the dynaMACS main screen select Other Functions>Utilities>System UtilitiesdynaMACS Main Screen 3
  2. Select Utility #1007
  3. Select the Run buttonSys Utilities Screen 1
  4. Select the Yes button on the Confirmation dialog box.Confirmation Dialog Box  Delete Confirmation Box

Step 3:  Run System Utility 1008 (Replaces Customer State/Region codes in customer records)

  1. From the dynaMACS main screen select Other Functions>Utilities>System UtilitiesdynaMACS Main Screen 2
  2. Select Utility #1008
  3. Select the Run button to complete the update.Sys Utilities Screen 2

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

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


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

“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.


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.

Tip #1402 – Using Sales IQ to Identify New Customers for a Manufacturer

Sales IQ has a unique feature that will allow you to identify new customers by identifying those that had no sales activity in the previous year but have purchased in the current year.  This can be accomplished by using Display New Sales YTD or MTD.

To Identify This Year’s New Customers for a Manufacturer:

  1. From the Sales IQ screen select the Manufacturer tab.
  2. Right click on a manufacturer and select Show Customers. Sales IQ Home
  3. Select This YTD from the Display New Sales drop down list.
  4. Select the Refresh button.Sales IQ Home 2
  5. You will notice that the list has been filtered to display only customers with YTD sales that had NO sales in the previous year for this manufacturer.Sales IQ Home 3

Tip #1401 – dynaMACS File Transfer/Combine Wizard

The Mfg/Cst/Rep Transfer (1)screen has been modified to include a “wizard” button which when selected will help make the transfer process easier for you.

Old Screen . . .

Transfer Combine Screen - Old

New Screen . . .

Transfer Combine Screen - New

When selecting the Wizard button the File Transfer Wizard screen will open. This screen is designed to help ease you through the File Transfer/Combine process.

Wizard Screen


In the following example we will transfer all data from a customer to a new sales rep.

  1. From the File Transfer Wizard screen select the Customer option from the drop down list in the I Want to Transfer or Combine all data for a: Wizard Screen 2
  2. Select the SalesRep option from the drop down list in the To a different:field.
  3. Select the Proceed To Selection button.Wizard Screen 3
  4. You will notice that after selecting the Proceed To Selection button, the Customer field and the Sales Rep field have been activated in the Transfer Data From and Transfer Data To section of the screen.This screen is very similar to the regular File Transfer/Combine (1) screen, only it will take the guess work out of it by allowing you to only enter data into the fields that have been activated based on your selections in the upper portion of the screen.Wizard_Step4
  5. Enter the Customer Code or use the Search button to find the code.In this example we will use Adel’s Dist ADED00 location Cincinnati>CI.
  6. For the Sales Rep we will use BG for Bill Grey.
  7. Select the Proceed button.At this point the file transfer process will proceed as normal.Wizard_Step567

Case Study: J & K Sales Associates

“The software is so flexible. We can see data in so many different ways and drill down for more details. It gives us a deeper understanding of the agency’s performance.”

Helen Degli-Angeli, Operations Manager
J & K Sales Associates

J_&_K_Sales_LogoClient Challenge

dynaMACS takes reporting capabilities to new levels. J & K Sales Associates was using custom-built reporting software to track agency sales and commissions in conjunction with their distributor software. But the two didn’t play well together.

“Running reports took forever,” says Operations Manager Helen Degli-Angeli. In addition, there was a limited selection of reports available. Slowing processes more, any new reports or report changes required a programmer.

J_&_K_Sales_StatisticsdynaMACS Solution

While the custom software drained agency resources, dynaMACS freed up time. Degli-Angeli sums up dynaMACS in two words: faster and easier.

Degli-Angeli discussed other benefits of dynaMACS:


Processes like report generation and importing manufacturer sales and commission information are streamlined. The powerful software does the heavy lifting, reducing the agency’s administrative tasks.


From one complete database users can see buy-sell sales, rep commissions and more, for a complete view of the agency’s performance.


The flexibility to select data by manufacturer, customer or rep is key Degli-Angeli says, “The flexibility to see data in so many different ways and drill down for more information gives us a deeper level of understanding into our agency’s performance.”


dynaMACS reduces the human error involved with manually re-typing data to transfer it from one system to another. Importing information with dynaMACS eSi is automatic and instantaneous.