Posts

“With my old software, the reporting format was less intuitive and more cumbersome. dynaMACS flows easily and has already resulted in more profitability.”

Dan Beaudet, President
Dan Beaudet Co.

Client Challenge

With Dan Beaudet’s old sales agency software, RPMS, getting timely data was an issue. Printed reports provided by the data entry person at month-end was the only access Beaudet had to sales data. During the month, he often felt he was in the dark.

Furthermore, Beaudet says, “There was no way to manipulate the data, no way to review the information in different ways, such as looking at a particular customer’s sales figures. With my old software, the reporting format was less intuitive and cumbersome. dynaMACS flows easily and has already resulted in more profitability.”

dynaMACS Solution

When the agency switched to dynaMACS, Beaudet saw an immediate difference. “dynaMACS’ Sales IQ tells me everything I need to know quickly. It cross-references everything, so no matter what screen I’m on, I can click and filter the data in many different ways. It is so easy to get the information you want.”

Because Beaudet purchased eSi, a feature that enables him to import sales and commission information that his manufacturers send electronically, data entry is a thing of the past – as is waiting for month-end to see sales figures.

Beaudet now spends less time managing invoices and commission statements and more time with his customers. In fact, his sales information enhances his meeting with customers.

“It’s very impressive to a customer when you can pull up sales information at his desk, on your laptop. I bring up data on the lines I represent, and show how each did year-to-date this year versus last. Then with a mouse click, I show a graph illustrating that data. The response is always a “wow.” They know that I am on top of what’s happening and that’s very reassuring to them.”

When asked to rate his old software with dynaMACS, Beaudet says, “It doesn’t compare.”

dynaMACS has made a world of difference in how efficiently our agency operates.

Jim Warner, Sales Manager
Gulf Atlantic Marketing, Inc.

Client Challenge

Gulf Atlantic Marketing battled with a custom software program for years. “Getting information was always a chore; the reports were clumsy and hard to format. Every week, we ran into things the system couldn’t do,” says Sales Manager Jim Warner. Another big frustration: the many hours spent manually keying in thousands of sales invoices from factories. “With paper invoices, we always had a stack that was a foot high waiting to be entered.”

dynaMACS Solution

dynaMACS changed all that. “When it comes to getting factories’ sales information into the computer with no manual keying, nothing beats eSi,” Warner says. “It’s quick and easy and there are no errors.” The agency receives the information electronically on the same day that the manufacturer sends it and can process the information immediately – taking just minutes and requiring no manual entry.

Warner says the transition to dynaMACS couldn’t have been easier. “dynaMACS moved five years worth of data with no errors and no problems. We had a very useable tool instantly.” The agency has comprehensive sales and commission data at their fingertips – no more struggling with formatting reports. “Everything we need is right there on the screen. We can instantly find the answers we need.” Warner says he is quickly able to answer day-to-day questions and is that come up, such as “where can a prospect buy in Tennessee; did a customer purchase from a certain factory last year; or what invoices haven’t been paid and how old are they?”

Warner goes on to say, “Today, we operate in a proactive mode, whereas before, everything was reactive. dynaMACS has made a world of difference in how efficiently our sales agency operates.”

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.

From the dynaMACS main screen select the Reporticon and then the Sales Analysis icon.

Select Shipment for the Source of Data.

Select the Column Set of Sales and Agency Commission then highlight G4.

Select Sub-Totals Group of Customer then highlight C1

Check the Descend By box

Select Option 9 – Sales-Comp YTDs from the Descend By Options List.

In the Select Range or Top/Bottom dialog box select the Select Top/Bottom Range radio button.

Enter 20 in the Top field and in the Bottom field and select the OK button.

Check the Summarize Locations box. This will combine individual locations into a total for the headquarters for customers with multiple locations.

Select the Print button.

The Top 20 customers are displayed with the greatest Y-T-D sales increase.

A Summary of “All Other” customers is displayed

The Bottom 20 customers are displayed with the greatest Y-T-D sales decrease.

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

From the dynaMACS main screen select Tools>Mailing List Export

In the Mailing List Export screen enter JB in the Rep field.

Select the Proceed button.

The following dialog box will appear providing you with the export file location and the details of the records in the file.

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.

To retrieve your file go to the file location which will be in the DYNAMACS/WORKING directory called DM_EXP.

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

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

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

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:

From the dynaMACS main screen select File>Preferences.

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.

From the dialog box select the .bmp file (in this example we are using YourLogo.BMP.

Select the Open button.

You will see the path and file name appear in preference field #5.

Select the Save button and then select the Exit button.

/wp-content/uploads/2011-logo.gif00dynaMACS Software/wp-content/uploads/2011-logo.gifdynaMACS Software2013-05-20 11:25:172017-07-25 15:25:24Tip #1305 - Did you know that you can add your company logo to your dynaMACS Reports?