Download Vehicle Template
Vehicles are used to transport your products to your customers.
To make the initial entry of the vehicles easier, a spreadsheet is provided.
From the Integration menu, click on Download Vehicle Template. Then click on the Download button.
Load Vehicle Data
Use Excel to open the VehicleUploadTemplate spreadsheet.
Enter the vehicle data into the spreadsheet.
Then delete the first line and save the file.
Field List
| Name | The vehicle’s identification, usually the number painted on the side of the vehicle. (Required) |
| Description | An additional description. (Optional) |
| VIN | The vehicle identification number. (Optional. If specified the Year, Make and Model may be omitted.) |
| State | The state issuing the license plate. (Optional) |
| Plate | The license plate number. |
| Year | The vehicle’s year of manufacture. (Required, but may be omitted of the VIN is specified.) |
| Make | The vehicle’s make. (Required, but may be omitted of the VIN is specified.) |
| Model | The vehicle’s model. (Required, but may be omitted of the VIN is specified.) |
| $/Use | The cost of using this vehicle on any given day. This includes the cost of fueling, safety inspection, manifest processing, etc. (Optional. If omitted, the default entered above will be used.) |
| $/Mile | The cost per mile. This includes the cost of fueling, and regular maintenance. (Optional. If omitted, the default entered above will be used.,) |
| Max Weight | The vehicle’s maximum weight capacity, in pounds. (Optional. If omitted, the default entered above will be used.) |
Upload Vehicles
From the Resources menu, click on Vehicles.
Click on the Upload Vehicles link.
Click on the Select File button to select the VehicleUploadTemplate file that you saved and then click on the Open button.
Click on the Upload button.
The number of vehicles added will be displayed.
Click the Close button and the vehicles from the spreadsheet will be displayed.
Run Vehicle List Report
Click the Report button on the top of the screen.
The Run Report ‘Vehicle List’ form will be displayed. This form is displayed for all report to give you the opportunity to exit without running the report. Click the OK button.
Click the View button to view the report and then click the Download button to save the worker list. This will be sent to the Brewery Routing support team later.