Posts

Tip #1611 – Using Sales IQ and Google Maps to Help Plan for a Sales Manager Visit

/2 Comments/in /by

dynaMACS Sales IQ has a unique feature that can map the customers you want to visit with Google Maps.  The example below will show you how to filter the criteria and customize which customers you visit.

Example

First we will focus on the geographic area in the state of Illinois where the sales manager from Lee Jacob wants to visit.

  1.  From the Sales IQ screen, select the Filter button.sales-iq-screen-filter
  2. In the Customer State/Region field enter “IL” and “IL” (from and through) and select “Include This Range”.
  3. Select the Apply button to create a filtered database.filter-screen
  4. You will be back at the Sales IQ screen.  Select the Manufacturers tab.
  5. Highlight and right click on the manufacturer. In this example it is Lee Jacob Mfg.
  6. Select Show Customers from the drop down menu.sales-iq-screen-show-customers
  7. A new Sales IQ Drill Down window will open displaying all of the customers that buy from this manufacturer Lee Jacob in Illinois in descending sequence of year to date sales.
  8. Highlight the customers that you wish to map.
  9. Right click and select Launch Maps from the drop down menu.sales-iq-screen-launch-maps
  10. The selected customer locations will now appear in Google Maps.  Within Google Maps you are able to select which locations to visit and you can also re-sequence the route if desire.google-maps-screen

Tip #1610 – Understanding the Symbols and Codes on a dynaMACS Sales Analysis Report

/in /by

When reviewing your dynaMACS Sales Analysis reports there are two symbols to look for that will easily identify customers with first time sales as well as customers with no sales in 3+ months.  There are also codes that are displayed to help you identify Column Settings and Sub Totals that where selected for this report as well as filters that may have been used.

  1.  The Column Set displays the Column Set that was chosen when creating the report.  In the following example G1 was selected.
  2.  The Subtotals displays the Subtotals Code that was selected when creating this report. In the following example S1 was selected.
  3. Customers that have a Less-Than (<) sign to the right of the Last Activity date are those that have no sales in 3 months or longer.
  4. Customers that have an Asterisk (*) to the right of the Last Activity date are first time buyers.report-screen-1
  5. The Filter field at the bottom left hand corner of the report will display all of the filter    selections chosen when creating this report.  In this example we have selected Mfg Code IRC thru MNC, Rep Code is JB and Cust Type A thru Z.report-screen-2

Case Study: Maschmedt & Associates

/in /by

“With dynaMACS cloud, our data is secure, always backed-up and easily accessed from anywhere.”

Jon Edwards, Controller
Maschmedt & Associates

MaschmedtAssociates_LogoClient Challenge

Maschmedt & Associates had been using an Access database for tracking agency sales and commissions. Updating the system required outside resources, using it was time-consuming and it was too old to keep pace with the busy agency’s needs.

Maschmedt needed modern and sophisticated software. Controller Jon Edwards had a list of features that he was looking for: Software designed especially for sales agencies. A way to quickly enter invoices and reconcile manufacturer commission statements. The ability to distribute up-to-date and comprehensive reports to sales reps. A cloud-based system for security and backup. And the software must update automatically.

Maschmedt_Statistics

dynaMACS Solution

When researching solutions, Edwards learned about dynaMACS’ capabilities and scheduled a demo to see the sales agency software in action. dynaMACS checked all the boxes on his list – and had even more functionality and the potential to greatly improve efficiency.

It’s been a smooth journey from the start, when three years’ worth of data was converted and migrated from Access. Since implementation, there’s been a significant impact on operations:

*Sales and commission data is cloud-based, so it’s secure, backed-up and accessible from anywhere

*Software automatically updates

*dynaMACS’ eSi eliminates 98% of manual data entry

*Sales reps have up-to-date sales data for their territory (Previously numbers were two to three months old)

*Information can be sliced and diced in numerous ways

*Maschmedt & Associates can drill down for detailed information on manufacturers, customers and reps 

With powerful ways to analyze sales, pay reps and track commissions, Maschmedt has a 360° view of performance.

Case Study: Kitchin & Sons

/in /by

“When traveling, I use dynaMACS daily to look up customer sales, territory sales and more.  It’s extremely convenient.”

Thomas M. Kitchin, President
Kitchin & Sons

Kitchin_LogoClient Challenge

When Kitchin & Sons experienced significant growth due to an acquisition, President Tom Kitchin quickly realized his agency needed better information to manage the growing business, as well as a way to integrate the two agencies’ disparate databases






Kitchin_StatisticsdynaMACS Solution

Kitchin decided it was time to upgrade to dynaMACS, who quickly integrated the two databases.

The agency see sales and commission data in a multitude of ways: sorted by customer, manufacturer or salesperson, and drilling down to more detailed information with one click. With dynaMACS on his laptop, Kitchin has 24/7 access to up-to-date information. “When traveling, I use dynaMACS’ Sales IQ daily to look up customer sales, territory sales and more,” says Kitchin. “It is extremely convenient and keeps me in touch with what’s going on.”

Back at the office, the staff is equally thrilled with dynaMACS. Administrator Joyce Drumm says, “dynaMACS saves time in so many ways. With the SmartView feature, I type in a few letters of a customer name and instantly see all customers who buy from a manufacturer.” Her favorite upgrade: Faster commission reconciliation reports. “It used to take 3 ½ hours to calculate before the report printed. Now, within a minute of hitting print, I have a report – a tremendous time-saver.” From a data entry perspective, Drumm says, “The entry screens are simple, well laid-out, and in a logical sequence.”

As for technical support, Drumm says dynaMACS is helpful, knowledgeable and timely: “It’s nice dealing with a company where you talk to people instead of recordings and touch-tone response systems.”

Tip #1606 – How to automatically give a sales rep, that is not currently assigned to a particular customer, credit for a sales based upon the manufacturer

/in /by

dynaMACS makes it easy to automatically assign a sales rep to each entry. By default, this assignment is based on the sales rep associated with the customer.  During entry, the operator can override this sales rep, if desired.  However, there may be situations where a different sales rep always gets credit for a particular manufacturer.  This tip will show how to set-up dynaMACS to accomplish such an override.

  1.  From the main dynaMACS screen select the Viewer icon and then the Customer icon to get to the Customer Maintenance screen.
  2. From the Customer Viewer screen highlight the customer.  In this example we are selecting Adel’sDist/Cinci.
  3. Notice that the Sales Rep for this customer is JB Jim Black. Customer Viewer
  4. Select the X-Reference tab.
  5. Select the Add button.
    Customer Viewer 2
  6. Enter or search for the Mfg Code.  In this example we will select “LJM” Lee Jacob Mfg.
  7. Enter or search for the Sales Rep (1) code.  We will use the Sales Rep code of “RW” for Rick White in this example.
  8. Select the Save button.
    Mfg-Cust Cross Ref screen
  9. As you can see below in the Sales Entry screen the Sales Rep field now reflects the change to the new sales rep for this manufacturer/customer.
    Sales Entry