Sequencing Guide
Overview
This article should be used as a standard guide to properly use the Sequencing functions within the Route Manager application.
This guide is intended for users that are on Route Manager version 8.2 6400+. If you are using this article on an older version of RMA, please contact Support@advantageroute.com to update to the latest V8 version.
In this article we will discuss the following items:
- What is Route Sequencing?
- Route Sequencing VS Mango Mapping Optimization.
- Do's/Don'ts of Sequencing.
- How to set a Sequence # on an account.
- How to Mass Sequence Accounts.
- Handheld Class Settings that affect Sequencing.
- Pre-Route Reports and Sequence Numbers.
What is Route Sequencing?
Route sequencing refers to the process of determining the most efficient or logical order in which a series of stops or destinations should be visited. It is commonly used in logistics, transportation, delivery services, and field operations.
What Route Sequencing Does:
- Optimizes the order of stops to reduce fuel consumption, mileage, or driving time.
- Improves delivery efficiency by ensuring timely arrivals and minimizing delays.
- Supports operational planning by aligning routes with business priorities (e.g., customer urgency, service levels).
- Enhances customer satisfaction by improving predictability and reliability of services.
Route Sequencing VS Mango Mapping Optimization
The RMA application has 2 separate features that can be used for routing organization.
- Route Sequencing
- Mango Mapping Optimization
Route Sequencing is a built-in RMA feature that is available to all Support package plans.
Mango Mapping Optimization is an additional module that can be purchased and added to the RMA software. For more information on the module cost/features, please reference this article: Mango Mapping.
Here is a brief chart that will break down the difference between the two applications.
Do's/Don'ts of Sequencing
Sequencing can be a very simple process when it comes to organizing a Route however, with all processes it is important to be aware of the Do's and Don'ts of the function.
This section will go over some of the main items you should DO with Sequencing and some of the main items you should NOT DO with Sequencing.
How to Set Sequence #'s on an Account
There are 2 areas on an account where a sequence number is noted.
- Permanent Sequence - This area will display the default sequence number set on the account for all future deliveries and is modifiable.
- Next Sequence - This area will display the sequence number for the next delivery day assigned to the account and is auto populated.

Before assigning a sequence number to an account, it is important to know the difference of the 2 areas.
Permanent Sequence is a modifiable field that will allow you to set the default sequence number for the account that will be used as the base sequence number for all future deliveries. (This does not mean this number is set the same for every delivery. The number can change for different deliveries depending on factors such as Delivery Orders added, additional accounts added with the same Permanent Sequence number, etc.)
Next Sequence number will display the customer's sequence number for the next delivery that is scheduled.
How to Mass Sequence Accounts
When you first start off with sequencing, it is best to use a Mass Sequencing tool to get an idea of all stops on each route.
Having a visual of all stops will make things easier to assign a permanent sequence number so that stops stay in the proper servicing order.
For this mass process, we recommend using the "Route Sequence" tool. You can find this tool under Route>Schedule>Route Sequence.

In this window, you can populate all accounts on the route selected and see the current sequence number assigned on their account under "Permanent Sequence".
This window will give you a good visual of the sequential order you currently have assigned for the accounts on the route.
Before making any major changes, you should always create a BACKUP before finalizing the changes.
To display the accounts, first you will need to select the "Sequence Entire Route" option. You will then find a prompt that will state any changes made to these accounts will apply for all future deliveries assigned to the listed accounts.

Select "Yes" on the prompt to move forward.
Next select your Route you would like to view. Then click the file folder icon with the down arrow.

The window will then display all accounts assigned to the chosen route regardless of the day label assigned.

You will then review the following columns:
Acct No. : Customer account number.
Stop: Account stop number.
Name: Customer name on route tab.
New Seq.: Newly assigned sequence number that was chosen in the Route Sequence window.
Old Seq.: Current sequence number assigned on the customer's account under the Route tab in the "Permanent Sequence" field.
City: Customer's Route tab city.
Address 1: Customer's Route tab address 1.
Address 2: Customer's Route tab address 2.
Review the current order of the listing. Any accounts that have a duplicate Old Seq.# will be organized based on alphabetical order of the Delivery name.
To change the order of the stops, you simply need to click on the stop and drag/drop it into place.
You will then notice the New Seq.# field will update depending on where you dropped it.
In this example, I have moved the A & A account to the bottom of the order which will now change it's Permanent Sequence number to 0040.

It is recommended to go through the entire list and order the stops based on your preferences.
Once the list is modified to the order you prefer, you will then select the Save icon at the bottom of the screen to permanently update the new "Permanent Sequence" number on the customer's account.

You will then be prompted that the changes have been made.

It is then recommended that you review a few of the accounts on the list to confirm the "Permanent Sequence" number on the Route tab was updated.

After confirming the change on the account, it is also recommended you look at the order of the stops for that route through MDM.
Open MDM and click on a few of the future delivery dates for that route.
Review the stops and confirm they stay in the proper order that was set.
NOTE: Please remember that there will be delivery days that may not include ALL stops assigned to the route due to the different frequencies. These delivery days will slightly adjust the order for any stops that are missing. An example of this would be Monthly deliveries. They will not appear on every delivery that Weekly or Biweekly deliveries are scheduled for so the accounts will be moved up in sequence due to that.
Handheld Class Settings that Affect Sequencing
It is important to understand that HH class settings do allow for permanent sequencing changes.
As mentioned in the beginning of this article, you should decide whether office staff will be making sequencing changes on the desktop or drivers will be making sequencing changes on the hh's.
If you allow both sides to make permanent changes, this can cause issues with the set order.
For Handheld Class changes, there are 3 options available for the drivers.
- Re-order stops on upload: When this option is enabled, every time a driver uploads their afternoon card, it will re-balance out the sequence numbers on that Route. The first stop on the route will have their sequence number updated to 0010, 2nd stop updated to 0020, and so on, until all stops have been adjusted. An Afternoon Report can also be printed to inform you of these changes showing the Old and New sequence numbers.NOTE: This will only update the specific accounts on the route that was uploaded. If you have accounts on this route, but not scheduled on this date, those customer sequence numbers will not be updated. This can cause duplicate sequence numbers between all customers assigned to the route so it is important to be careful when using this option.
- Ignore Driver Sequencing on Handheld: This option will allow the driver to use the Route Sequencing screen on the handheld to modify the order in which the stops show in the Route Listing screen, but will NOT change the sequence numbers for those customers when the handheld is uploaded.
- Use Follow Me Tracking: This option will re-order stops on the route upon uploading, based on the order in which the driver serviced each stop.NOTE: This will only update the specific accounts on the route that was uploaded. If you have accounts on this route, but not scheduled on this date, those customer sequence numbers will not be updated and can cause issues with duplicated sequence numbers for other stops on the route that were not scheduled that day.
Each of these options can be found under Lists>Route>Handheld Class>Morning/Afternoon.

Any changes that need to be made should be made to ALL Handheld Classes.

Once a setting is changed, the drivers will need to download their route again to pick up the change.