Posts

Tip #1307 – Analyzing Top and Bottom Performing Accounts

The Sales Analysis Report Generator is a powerful feature of dynaMACS that provides you with virtually limitless possibilities for generating vital sales and commission reports.

Using the Sales Analysis Report Generator we will demonstrate how you can create a sales and commission report that will summarize total agency performance and identify the top and bottom 20 customers based on year-to-date sales increase/decrease.

  1. From the dynaMACS main screen select the Reporticon and then the Sales Analysis icon.Main Screen
  2. Select Shipment for the Source of Data.
  3. Select the Column Set of Sales and Agency Commission then highlight G4.
  4. Select Sub-Totals Group of Customer then highlight C1
  5. Check the Descend By box
  6. Select Option 9 – Sales-Comp YTDs from the Descend By Options List.Sales Analysis Reports Screen 1
  7. In the Select Range or Top/Bottom dialog box select the Select Top/Bottom Range radio button.
  8. Enter 20 in the Top field and in the Bottom field and select the OK button.Select Range Dialog Box Note
  9. Check the Summarize Locations box.  This will combine individual locations into a total for the headquarters for customers with multiple locations.Sales Analysis Reports Screen 2
  10. Select the Print button.Sales Analysis Reports Screen 3
  11. The Top 20 customers are displayed with the greatest Y-T-D sales increase.
  12. A Summary of “All Other” customers is displayed
  13. The Bottom 20 customers are displayed with the greatest Y-T-D sales decrease.Sample Report

Tip #1306 – Using dynaMACS Mailing List Export

The dynaMACS Mailing List Export is a simple feature that allows you to create a customer list that can be exported for use in another program. This feature lets you target specific customers by filtering on data fields from the customer records in dynaMACS. You can also include or exclude customers that purchase from certain manufacturers.

The following example explains how to select the mailing list options in dynaMACS and export the file. In this example we will create a list of all customers in sales rep Jim Blacks territory.

Creating a List from the Mailing List Export Screen

  1. From the dynaMACS main screen select Tools>Mailing List ExportdynaMACS Main Screen
  2. In the Mailing List Export screen enter JB in the Rep field.
  3. Select the Proceed button.Mail List Export Screen
  4. The following dialog box will appear providing you with the export file location and the details of the records in the file.Export Complete Dialog Box  Note_Revised
  5. Next a Printing Options dialog box will appear. This is a confirmation of the file location and details which was displayed in the previous dialog box. You can select the Preview button to preview the details, the Print button to print the details or the Exit button to close the dialog box. Printing Options Screen
  6. To retrieve your file go to the file location which will be in the DYNAMACS/WORKING directory called DM_EXP.Filter_List

Case Study: Industrial Component Sales, Inc.

“dynaMACS is a big time-saver. To process manufacturer files electronically, all I do is press a button. dynaMACS eSi does the work for me.”

Chris Mattis, Operator
Industrial Component Sales, Inc.

Industrial_Components_LogoClient Challenge

When Industrial Component Sales, Inc. was founded, the agency did not use sales and commission software. As the agency grew, they needed a way to track commissions and easily view information on manufacturers, customers and reps.




Industrial_Components_StatisticsdynaMACS Solution

The agency chose dynaMACS, and was blown away by how much sales and commission data was available at their fingertips. Industrial Components can calculate commissions, choose how they want to view information, analyze sales trends, view sales histories and much more.

Industrial Components found that the longer they have dynaMACS, the better it gets. dynaMACS constantly improves the software to enhance automation and efficiency.

For example, Industrial Components Operator Chris Mattis uses dynaMACS eSi to process files from manufacturers electronically (like Excel spreadsheets). The newest release of dynaMACS includes an enhancement that saves Mattis hours of time each month because she is able to process manufacturer files even if they have missing information. The “auto dupe” feature automatically populates data that is missing from spreadsheets. “I’m amazed at how quickly I can process files. All I do is press a button and eSi does the work for me.”

Another enhanced feature is “sales rep zip code range,” which speeds up the process of entering new customers. Sometimes, when adding new customers, operators spend too much time figuring out who the sales rep is for that customer’s territory. Now the operator simply defines the sales rep’s territories by zip code ranges just one time. After that, dynaMACS automatically fills in the sales rep, city and state for every new customer.

These are just a few examples of how dynaMACS constantly improves, to save agencies time and money, letting them work more efficiently and focus on their core business of selling.

Tip #1305 – Did you know that you can add your company logo to your dynaMACS Reports?

By using the Preferences utility in dynaMACS you can set your logo to print on your reports. The logo file must be a bitmap (.BMP) and it is suggested that the bitmap format is 160 x 80 pixels.

Example of a report with your logo:

Example Report

  1. From the dynaMACS main screen select File>Preferences.Main DM Screen
  2. From the User Preference(s) screen with the Preferences field selected for #5 Default Bitmap to print on Reports, select the Browse button at the bottom of the screen to find the location and file name of the .bmp file for your logo. User Preferences Screen 1
  3. From the dialog box select the .bmp file (in this example we are using YourLogo.BMP.
  4. Select the Open button.File Manager Screen
  5. You will see the path and file name appear in preference field #5.
  6. Select the Save button and then select the Exit button.User Preferences Screen 2Note

Tip #1304 – Have you ever gotten stuck during sales entry not knowing where a sales rep override is coming from?

Overrides button during sales entry to view the hierarchy of sales rep overrides for the selected customer and then continue with your sales entry.  Sales rep overrides are generated from the X-Reference records.  An established “hierarchy” is used to determine which X-Reference record overrides another. The sales rep override screen shows all the X-Reference records used to determine the final override results.

To View Overrides During Sales Entry:

  1. During the sales entry process you can view the source of a sales rep override if present. To do so, simply select the Overrides look up button in the Sales Entry screen.

    NoteSales Entry Screen

  2. When this button is selected, the Sales Rep Hierarchy (or Overrides) screen is shown. This screen will display the order in which the existing overrides are processed from top to bottom.
  3. The bottom value in each column (being the final override results) is summarized in the Results row in this screen.
  4. Select the Exit  button to return to the Sales Entry screen where you left off and so you can continue with your sales entry.Sales Rep Overrides Screen 1

To View Overrides From the Main dynaMACS Screen:

  1. To view the Sales Rep Overrides, from the dynaMACS main screen select Edit>Mfg>Cust X-Reference>Display OverridesdynaMACS Main Screen
  2. The Sales Rep Hierarchy (or Overrides) screen is shown. This screen will display the order in which the existing overrides are processed from top to bottom.
  3. The bottom value in each column (being the final override results) is summarized in the Results row in this screen.
  4. Select the Exit button to close the Sales Rep Overrides screen.Sales Rep Overrides Screen 2

Case Study: Texas Reps

“I can’t explain how different life is with dynaMACS eSi. Data entry time went from countless hours a month to just a few minutes. It’s like night and day.”

Ava Sewell, Office Manager/Operator
Texas Reps

Texas_Reps_LogoClient Challenge

Texas Reps sales agency implemented dynaMACS software over a decade ago and has been a loyal customer ever since, touting the benefits of the easy-to-use software that quickly provides sales and commission data with the ability to perform in-depth analysis.
When Ava Sewell, office manager and operator, joined Texas Reps a year ago, she too began using the software. But she was spending several hours every month manually entering sales and commission information from manufacturer reports. However, while exploring dynaMACS, she came upon a module that her predessor in the office did not utilize: eSi (electronic sales information).

Texas_Reps_StatisticsdynaMACS Solution

eSi electronically and automatically processes files (like excel spreadsheets) provided by manufacturers. Manual data entry from paper or emailed reports is virtually eliminated. Sewell quickly realized the possibilities and benefits of using eSi.

As with any new software feature, Sewell was at first a bit intimidated by eSi’s powerful capabilities. She called dynaMACS support, who she says “walked me through using eSi and helped me every step of the way.”

Once she began using eSi, her job changed forever – for the better. Now that she is up and running, Sewell reports, “I can’t explain how different life is with dynaMACS’ eSi. Importing data into our system is so easy now. I used to spend countless hours a month on data entry. With eSi, it literally takes just a few minutes. All I do is click a few buttons, and eSi takes over. It does what it needs to do automatically. It’s a night and day difference.”

Once she imports the data and updates dynaMACS, she emails the information to sales managers. They have current sales and commission data in minutes and with a few mouse clicks, can perform in-depth sales analysis.

Even now, when Sewell has a question, the dynaMACS support team is there to help. In fact, she says, “agencies who don’t utilize dynaCARE support might not use the software to its full potential.”