Posts

Tip #1306 – Using dynaMACS Mailing List Export

/1 Comment/in /by

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.

/in /by

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

/in /by

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?

/in /by

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

/in /by

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

Case Study: Wes Coast Marketing

/in /by

“Access to sales & commission data is instant. No waiting. dynaMACS eliminates the time lapse.”

Chris Mitchell
Operations Manager, Wes-Coast Marketing

Wes_Coast_Marketing_LogoClient Challenge

Like most agencies back in 1998, Wes-Coast Marketing was using Excel spreadsheets for sales and commission data. The agency “got by” with it, but reporting and analysis capabilities were bare-bones. A few years after launching, Wes-Coast experienced exponential growth in a relatively short period of time. Spreadsheets no longer filled the bill. The agency needed a powerful, technologically sophisticated software solution to manage and track sales and commission data, Operations Manager Chris Mitchell explains.

Wes_Coast_Marketing_StatisticsdynaMACS Solution

Wes-Coast chose dynaMACS software and was immediately impressed with the instant on-screen access to all sales information. For the first time, the agency was able to combine and analyze sales for all manufacturers in one database and provide sales reps with up-to-date sales reports. Principal Jim Marino remembers the pre-dynaMACS days. “It was an antiquated, paper-driven process that resulted in lengthy delays in getting information.”

Since switching to dynaMACS, Wes-Coast realizes the value of powerful agency software and takes advantage of the newest features as they are released.

First, the agency’s field salespeople and principal were equipped with dynaMACS Mobile on their laptops, so they had access to sales and commission information from anywhere as soon as the agency distributed it electronically. “Before dynaMACS Mobile, once a month we would mail out reports. By the time the reps saw the data, it was a month-and-a-half to 2-months old,” says Marino.

Next, the agency became an early adopter of the latest dynaMACS advancement: cloud processing. The team sees real-time data. They have the most recent figures, can get high-level sales information, drill down to detailed information, and send reports to reps – even email up-to-date reports to customers.

“Everything is instant. No printing stacks of paper. No waiting. The time lapse is eliminated,” says Mitchell.