Posts

Tip #1709 – Using dynaMACS’ Sales IQ Graph to Show the difference in “House” Commission percentages for this year versus last year

In our previous tip #1708 we talked about using dynaMACS’ Sales IQ to analyze “House” commission. The following will show you how to create a graph from that information.

Using the Graphing Feature in dynaMACS

  1.  From the Sales IQ screen select the Filter button.
  2.  Select Active from the Manufacturer Status drop down list.
  3.  Select the Apply button.
  4. From the Sales IQ screen with your selections displayed, click on the down arrow to the right of the Graph button and select Graph.
  5. Check the boxes for Jan-Aug 19 and Jan-Aug 18 in the Select Columns to Graph screen.
  6. Once you have made your selections click on the Graph button in the lower left hand corner of the screen.
  7. The graph will default to a bar chart.  Select the Customize button to change the type of graph that will appear.
  8. Select the Line chart (or Pie etc.) to customize the look of your graph.
  9. When you have completed your selections select the OK button.

From the Sales IQ Graph screen you can:

  1.  Print the graph.
  2. Customize the look of the graph.
  3. Copy to Clipboard.

Tip #1706 – Are you constantly changing the “display by” search in the customer viewer?

The Display By field in the dynaMACS Viewer screens defaults to “Lookup” which lets you enter the first few characters of the Name i.e. manufacturer, customer or sales rep name in the Start field which will display a list based on that entry.

You can change this default temporarily by selecting the down arrow in the Display By field while in the Viewer screen.  This will change the Display By for the current viewing session.

You can also change the default so that every time you access the Viewer screens it will default to your personal selection.

To Change the Default Display By Field for the Viewer Screens

  1.  From the main dynaMACS screen select File>Preferences.

  2. From the User Preference(s) screen, scroll down to #19 Viewer Look-Up.
  3. Select the drop down arrow to the far right of Viewer Look-Up.
  4.  Select the field which you would like your default Viewer Look-Up to be ( i.e. City).
  5. Select the Save button.
  6. Select the Exit button.

Now when you access any of the viewer screens the Display By field will default to that selection.

Case Study: State Side Sales

 “dynaMACS uses GoogleMaps to plan efficient routes when we visit multiple customers. We spend less time in the car and more time selling.”

Joe Durbin, President
State Side Sales, Inc.

Client Challenge

State Side Sales Agency was using rudimentary sales and commission software that didn’t provide enough useful information to meet their needs. The agency chose dynaMACS and instantly had a wealth of meaningful data to analyze performance, track trends and operate proactively. As the years passed, the agency became accustomed to having all the sales and commission information they needed at their fingertips. When State Side Sales stopped using dynaMACS and tried to get by with different software, they missed many of dynaMACS’ features.

 




dynaMACS Solution

Joe Durbin, President of State Side Sales, read an article on LinkedIn about dynaMACS’ ability to map routes when visiting multiple customers, and he saw an opportunity to improve his agency’s efficiency. “We were already missing our favorite dynaMACS features. When I saw the GoogleMaps function, I knew it was time to go back to dynaMACS. We now spend less time in the car and more time selling and building relationships.”

While looking at the sales numbers, reps select the customer addresses that they want to visit. A map view of all locations is displayed, along with the most efficient routes and directions between locations. Sales reps can also re-sequence the route if they choose. “We’re increasing efficiency, reducing travel time and maximizing reps’ time.”

The agency also has the ability to select a territory and see performance data for the top 20% of manufacturer/customer relationships (using sales volume). “We use this as a performance indicator and we see trends faster. It’s another level of knowledge that we didn’t have without dynaMACS.”

dynaMACS continually adds new functionality, and the support team is on hand to show State Side Sales tips and tricks for extracting detailed information organized in meaningful ways, with just a few mouse clicks.

Tip #1705 – dynaMACS Helps Agencies get Sales & Commission Information Electronically with this Manufacturer Benefits White Paper

Electronic Sales Information (eSi) is the electronic distribution of sales information from manufacturer to sales agencies. The dynaMACS eSi module can replace hours of data entry with a quick and easy process of automatically importing sales information from manufacturers that email their sales information in a spreadsheet format.

The move to dynaMACS eSi requires a simple change in an administrative process on the part of the manufacturer.  Instead of paper reports, the manufacturer produces a spreadsheet that contains the same information and sends it via email to sales agencies. The manufacturer buys no special software, no additional hardware and actually saves money by reducing paper, postage and administrative support costs. The agency receives the information on the same day the manufacturer sends it. The agency can then process the information immediately and if desired, distribute it to sales reps in the field.

The eSi process:

  1.  The agency receives data from the manufacturer via email, CD, or Internet download. No more waiting days or months for data.
  2. Data is provided in a standard comma-delimited (.csv) format or spreadsheet, for automatic upload to the agency database. Data entry is eliminated and so are operator errors.
  3. The agency processes the file to identify new or first-time customers and to balance total sales and commission amounts. Files are updated using dynaMACS’ easy on-screen error correction and new customer lookup capabilities. Your manufacturer customer codes are automatically matched to dynaMACS codes.

It is literally that easy. Giving you instant access to vital sales analysis and commission information, dynaMACS is a fast, flexible and reliable way of managing sales and commission data.

Click Here to view the white paper

 

If you do not currently have dynaMACS eSi and would like more information about it, please visit www.dynamacs.com/products/esi.shtml or call us at 800-321-1788.

Tip #1704 – Quickly Identify New and Inactive Manufacturers in dynaMACS Sales IQ

The Sales IQ screen has been enhanced in dynaMACS Version 2016 to quickly identify new manufacturers and inactive manufacturers with a color scheme.  This is based on the Manufacturer Status in the manufacturer record.

  1.  A NEW manufacturer name will now be displayed in the color GREEN.
  2.  An INACTIVE manufacturer name will now be displayed in the color RED.

    Manufacturer Viewer Screen

Tip #1703 – Transferring a Portion of One Sales Rep Territory to Another Sales Rep

dynaMACS makes it easy when you are changing your agency territories.  Instead of moving one customer at a time, dynaMACS can move multiple customers at one time.

In the following example we will transfer all of sales rep Jim Black’s accounts in the state of Kentucky to the new sales rep Rick White.

Customer Global Update

First you must run the Customer Global Update.

  1.  From the main dynaMACS screen select Edit>File Transfer/Combine>Customer Global Update.
  2. Select the Yes button from the Restore Point? dialog box to create a restore point.
  3. In the Customer Global Change screen enter the state code “KY” in the State field.
  4. Enter the “from” sales rep code “JB in the Sales Rep field (old rep).
  5. Enter the “to” sales rep code “RW” in the next Sales Rep field to the right (new rep).
  6. Select the Update button.
  7. Select the Print button from the Printing Options dialog box to print the Audit Trail report.
  8. This report shows a list of the customers that will be transferred from sales rep “JB” (Jim Black) to sales rep “RW” (Rick White).
  9. After reviewing the Audit Report select the Yes button to continue.

    Transfer Sales and Commission History to New Rep

    1.  From the main dynaMACS screen select Edit>File Transfer/Combine>Mfg/Cst/Rep Transfer (1).

    2.  From the Manufacturer/Customer/Sales Rep Transfer/Combine (1) screen select the Wizard button at the bottom right hand corner which will redirect you to the Wizard screen.  You will be prompted to create another Restore Point.

    3.  Select Sales Rep from the drop down list for the field: I want to transfer or combine all data for a:.  Select Sales Rep and for the field: To a different.  Then select the Proceed to Selection button.
    4.  Enter the Sales Rep code that you are transferring from under Transfer Data From i.e. “JB”.
    5.  If you wish to transfer the sales rep splits, check the box Transfer Commission Splits to this Sales Rep?
    6.  Select the Proceed button.
    7.  Select the Yes button on the Please Confirm dialog box.

    8.  From the Printing Options screen select your printer and then select the Print button.

    9.  Review the report and then select the Yes button to complete the transfer.

    10.  Select the OK button after all records have been transferred.

    11.  From the main dynaMACS screen select Edit>File Transfer/Combine>Mfg/Cst/Rep Transfer (2).

    12.  Print the report when prompted by selecting the Print button.
    13.  Select the OK button on the Please Confirm dialog box to complete the transfer.