Tip #1301 – Power of eSi Mapping

If you receive sales information from manufacturers electronically, you can replace hours of data entry by importing that information directly into dynaMACS using the optional Electronic Sales Input (eSi) module. eSi includes the Reformat Utility which translates the information from your manufacturer into a file that dynaMACS recognizes. Once you have shown dynaMACS how to translate a manufacturer’s file the first time, dynaMACS remembers the translation, or map, for any future sales information files received from that manufacturer. Below are just a couple of eSi features that show the power of eSi mapping.

Auto Duplicate Feature

The Advanced feature #11 says Auto Duplicate any fields in the import file if the row is blank. This will apply to all dynaMACS fields in Column 3 that have an “*” next to them.

Electronic Sales Information Mapping with the auto duplication field checked for importing manufacturer commission statements into dynaMACS Software

The spreadsheet example shown below is a primary example of where this can be used. Notice the first entry for each invoice has the permanent information but each subsequent row is left blank. By selecting the Auto Field Duplication option, the blank fields will be populated with the preceding data. This eliminates the need to manually modify the spreadsheet prior to processing it in dynaMACS.


Append Feature

With the Append feature you can combine two fields from your import file to map to a dynaMACS field. This is useful in identifying multiple Ship-to locations for a customer where the Ship-to location is in a different field from the Sold-to customer code. In the following example we will append the Code field with the Zip Code field.

  1. First highlight a field in box (2) Selected.
  2. Next highlight a field in box (1) Fields from the source file which will be appended to the field selected in step 1 and select the Append button.
  3. The field Code is now appended with the field Zip Code. The combined field is “mapped” to the Mfg’s Customer Code used to identify the correct customer.Electronic Sales Information Mapping with the results of appending 2 fields together for the importing manufacturer commission statements into dynaMACS Software

If you are interested in the dynaMACS eSi module and you currently do not have access to it, please contact the dynaMACS sales office @ 800-321-1788 to learn more.

Case Study: Head Contract Solutions, Inc.

“We used our old software for a year and realized we had made a mistake. dynaMACS is much easier to use, and relevant information is easily accessible.”

Liz Head, Owner and Manager
Head Contract Solutions, LLC

Head_Contract_Solutions_LogoClient Challenge

Head Contract Solutions was expanding, hiring new sales reps, and trying to use Excel for sales and commission data. The agency needed deeper information than Excel could provide. So a hunt for new software commenced. Although hindsight is 20/20, the agency based its software decision mostly on price. It turned out to be a case of “you get you pay for.” Liz Head, owner and manager of Head Contract Solutions, described the software as “grueling.” It was not easy to learn or to use and the agency still wasn’t getting the in-depth data they sought. Using the software was making the agency less productive, instead of more.

Head_Contract_Solutions_StatisticsdynaMACS Solution

And so a second software search began. This time, Head Contract asked colleagues at other sales agencies what software they used. One name came up time and again: dynaMACS.

Head said what the agency saw in dynaMACS was, “a fast, flexible and reliable way to manage all of our sales and commission data.”

Head says dynaMACS makes it easier to pay sales reps, and she finds being able to access a 5-year sales history with a few mouse clicks extremely useful.

One of the biggest benefits for Head is the ability to import manufacturer sales and commission reports without manual entry. “We’ve pretty much eliminated data entry. We receive manufacturers’ sales invoices and commission statements electronically. It literally saves hours. For just one manufacturer a month, there are up to 400 lines items to cover each brand and every dealer. Before dynaMACS, stacks of paper would arrive and all the information had to be inputted by hand.”

Head says dynaMACS lives up to its reputation of a powerful performance analysis tool. “Our productivity and accuracy has grown exponentially, and we have only scratched the surface of what dynaMACS can do.”