Posts

Offering more options for your business

 

SalesAnalysis (Sales, Commission and Order Management):

  1. Line Item Details. Import a part number spreadsheet from your principal so it’s easy to add line item details.
  2. Order Tracking. Keep track of what items your customers buy and the quantities.
  3. Electronic Data Imports. Imports saves time and money.

Keep an eye out for more in our upcoming blog:

AccountManager Office 365 (CRM from your In-box)

If you can’t wait contact us today!

Tip #1712 – How to Delete a Customer from the dynaMACS Database

Follow the steps below to delete a customer that has merged with another customer or is no longer in business.

Move the history to another customer

  1. Go to Edit drop-down menu.
  2. Select File Transfer/Combine.
  3. Choose Mfr/Cst/Rep Transfer (1).
  4. The Manufacturer/Customer/Sales Rep Transfer/Combine window will appear.
  5. Type in the customer that you want to delete on the left side (Example:  Abbott Health Products) and the customer that you want the history to go to on the right side (American Instruments).
  6. Select the Proceed.
  7. Choose Yes at the prompt for Are these correct?
  8. Select the printer and print out the audit trail.
  9. Please confirm … choose Yes.
  10. The FYI window will appear, select OK.
  11. At the 2nd FYI, choose OK.
  12. Follow steps 1-11 until you are done will moving the customers.
  13. Then select Cancel to exit this screen.
  14. Go to Edit drop-down menu.
  15. Select File Transfer/Combine.
  16. Choose Mfr/Cst/Rep Transfer (2).
  17. The Manufacturer/Customer/Sales Rep Transfer/Combine (2) screen will appear.
  18. Select your printer and print the audit trail.
  19. Choose OK at the Please confirm window.
  20. Go to Edit drop-down menu.
  21. Select File Transfer/Combine.
  22. Make Customer Deletable
  23. Select Range of Records.  Leave the from field blank and type in zzzz in the To field. Then choose OK.
  24. Select Yes at the next window.
  25. At the end you will get a message that tells you how many customers were deletable. Choose OK.
  26. Select Exit when done.
  27. Go into the Customer Maintenance screen and select one of the customers that you transferred the history for and select the Delete button.

Tip #1711 – Import your Sales Goals Quickly with the dynaMACS Optional Module – eSi

Save hours of manual entry by exporting your sales data out of Sales IQ, manipulate the annual number and simply import your sales goals for the next year back into dynaMACS.

Export your sales numbers out of Sales IQ

  1. From the Sales IQ screen enter in a sales rep that you would like to create goals for.
  2. Select the GlobalView Tab.
  3. Select ALL from the Selector drop-down list.
  4. Wait for dynaMACS to process your request.
  5. Select the Export button.
  6. Name the file and place it in a directory that you will remember where it is located.
  7. Exit out of Sales IQ.
  8. Find the file that you just saved. Double click on it and the file will open in Excel.
  9. Insert a column next to the Sales Jan-Dec 17 column (F) and name it Goals.
  10. Create the formula with the percent that you would like to change. (Example shows 15%).
  11. Copy the formula down the spreadsheet and save it as a csv file.
  12. Go into the eSi reformat screen for dynaMACS.
  13. Map the Goals.
  14. Process through the rest of the eSi steps.
  15. NOTE: Make sure that you are posting the session to January of the year that you want the goals to go into. (Example:  01/2018)

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.

Tip #1702 – Organizing Your Agency Workflow to Accommodate all the Various Manufacturers

One of the many challenges sales agencies face is dealing with the many forms and documents received from each of the manufacturers that the agency represents. Whether a document gets entered into dynaMACS, QuickBooks or just filed, it is helpful to document the process for each unique manufacturer document received.  We suggest that you create a binder with a tab for each manufacturer and use the form below (or something similar) for each document.

Create a Binder

  1. Set up a binder with a tab for each manufacturer.
  2. Behind each tab you should have the dynaMACS Manufacturer Document Workflow Worksheet (example below) and examples of all other documents you receive from the manufacturer.
    Example:
    To obtain copies of this worksheet and all other dynaMACS worksheets go to Help>Learning Center from the dynaMACS Main Screen.  You will also find them in the dynaMACS Implementation Kit that you receive upon purchasing your software.

Tip #1611 – Using Sales IQ and Google Maps to Help Plan for a Sales Manager Visit

dynaMACS Sales IQ has a unique feature that can map the customers you want to visit with Google Maps.  The example below will show you how to filter the criteria and customize which customers you visit.

Example

First we will focus on the geographic area in the state of Illinois where the sales manager from Lee Jacob wants to visit.

  1.  From the Sales IQ screen, select the Filter button.sales-iq-screen-filter
  2. In the Customer State/Region field enter “IL” and “IL” (from and through) and select “Include This Range”.
  3. Select the Apply button to create a filtered database.filter-screen
  4. You will be back at the Sales IQ screen.  Select the Manufacturers tab.
  5. Highlight and right click on the manufacturer. In this example it is Lee Jacob Mfg.
  6. Select Show Customers from the drop down menu.sales-iq-screen-show-customers
  7. A new Sales IQ Drill Down window will open displaying all of the customers that buy from this manufacturer Lee Jacob in Illinois in descending sequence of year to date sales.
  8. Highlight the customers that you wish to map.
  9. Right click and select Launch Maps from the drop down menu.sales-iq-screen-launch-maps
  10. The selected customer locations will now appear in Google Maps.  Within Google Maps you are able to select which locations to visit and you can also re-sequence the route if desire.google-maps-screen