Note this Solid Know-How™ article does not apply to Solid Route Accounting™ for QuickBooks Online; please refer to Article #335 How to Create Customer Route Groups?


For mobile sales, it is usually desirable to separate your customer records into Customer Route Groups (CRG). This allows the upload of customers specific to that mobile route. To do this, Solid Route Accounting™ requires that your customers be assigned to a CRG. You may establish just one or as many Customer Route Groups as you wish.

Customer Route Groups

All supported business systems can have a CRG value added to the customer record, which is subsequently used to load information specific to those customers assigned to a mobile.

Please note that a customer or CRG can be assigned to multiple mobile computers.

Setting up CRGs is a 3 step process:

  1. In your Accounting System: In your accounting/ERP system, assign a CRG value to the customer record. See QuickBooks® specific instructions below as an example.
  2. In SolidRouteAccounting.com: update the settings as shown below.
  3. In Solid Fusion™ (located on your office computer): Click on "Sync Now". Remember, you do not have to use "Sync Now" if you allow Solid Fusion™ to run automatically.

Step 1 – Accounting System Setup: QuickBooks®

In QuickBooks® to add a CRG to your customer records, you must set up a Custom Field for your customers:

  1. Select the Customer button in the Customer Navigator window.
  2. Create a new customer or double click on an existing customer
  3. Click on the Additional Info tab.
  4. Click Define Fields.
  5. Enter "Route Group" as the name of the field in the label column.
  6. Put a checkmark on the Customers options, then click on OK.
    • Note that Define Fields needs to be done only once, on an initial basis.
  7. Proceed with inputting a CRG for each customer record you wish to send to a mobile sales unit. The CRG value generally consists of 3 digits/characters, e.g. 001 or C10.
  8. Run Solid Fusion™ so that your changes are uploaded to Solid Route Accounting™ and made available for the next step.

Step 2 – Configure SolidRouteAccounting.com

Next, log into SolidRouteAccounting.com:

  1. Select the Settings tab
  2. For the "Route Group Field", select the newly created QuickBooks® custom field from the drop-down list.

    Route Group Custom Field

  3. Click on [Save]

Now on your office computer, open Solid Fusion™ and click on [Sync Now] to import the route group data from QuickBooks®.

Step 3 – Final Configuration of SolidRouteAccounting.com

Returning to SolidRouteAccounting.com

  1. Navigate to the Mobiles tab
  2. Select a mobile record, and click [Edit]
  3. Check the Customer Route Groups that you would like to be assigned to this mobile

    Route Group Mobile Assignment

  4. Click [Save]

The last step is to synchronize your mobile(s) for these changes to take effect.

For a step-by-step guide on how to setup CRG in Solid Business Central™, please read the following Solid Know How™ article:
Article #86 What are Customer Route Groups (CRG) and how to Use, Create, and Assign Them?

QuickbooksSage 100Solid business centralSyspro

Leave a comment

All comments are moderated before being published