RoadNet Export

This option is only available with the RoadNet Plugin. This screen exports files to RoadNet. For an employee’s route information to be exported to RoadNet, the check box Driver’s deliveries will be exported to RoadNet must be checked on the Records>Employee>Records Interfaces Panel.

In order for employees to access this screen, the “May Export Orders to Roadnet” checkbox on the Plugins Panel must be checked.

The checkbox Use Special Fix for Zero-Case Lines on the setup was added in September 2009. This checkbox correlates to the fact that Fleetloader has the ability to route on only one package type at a time. For invoices that had both Cases and Kegs, Fleetloader was able to function properly. The issue raised when an invoice had zero cases and only kegs in it. Since, the Keg column is the second column RoadNet assumed that the order was zero. If this checkbox is checked than we will populate the Case column of the export file with the Keg Qty for invoices that have only Kegs.

The checkbox Include Product Returns in Export on the setup was added in January 2010. This checkbox is a user-configurable setting which determines whether product returns are exported or not in the RoadNet export.

The option to choose “all warehouses” only appears when there are exports from multiple warehouses.

How-To Setup the RoadNet Export

  1. Go to Orders>RoadNet Export.
  2. Click the hyperlink Setup.
  3. To change the import or export folder, click the hyperlink Change Import/Export Folder.
  4. To change the export format, use the drop down arrow.
  5. Check or un-check the checkbox Use Special Fix for Zero-Case Lines.
  6. When finished, click the X to exit the setup box.

How-To Export Information to RoadNet

  1. Go to Orders>RoadNet Export.
  2. Use the drop down arrows to select the warehouse(s) and accounts.
  3. Click the command button Load Current Data.
  4. Select the drivers from the list by checking the check box, or to select the entire list click Select All.
  5. Click the command button Export to RoadNet.

How-To Export Masterfiles

  1. Go to Orders>RoadNet Export.
  2. Click the command button Export Masterfiles.
  3. Use the drop down arrows to select the warehouse(s) and accounts.
  4. Click the command button Export Now.

Roadnet Export Formats

There are specific formats for each of the Roadnet file exports.

Brands

Brands Format

Employees

Employees Format

Drivers

Drivers Format

Items

Items Format

Locations: Multiple Formats

Locations Formats

Packages

Packages Format

Orders: Multiple Formats

Orders Formats

Here are the available formats, click a format’s link to download a spreadsheet containing the file structure for that format:

  1. Default Formats
    • This file structure is used for 10 different formats, click here for a list.
  2. RoadNet Anywhere Format
  3. Extended With Ship Dates Format
Updated on May 10, 2019

Was this article helpful?

Related Articles