Roadnet Donation Pickup Exports (v5.0)

Modified on Wed, 20 Sep, 2023 at 9:28 AM

Purpose of this document

This document outlines the Donation Pickup portion of the Roadnet Export.

Ceres Object release 5.00.00 is required for the functionality described in this document.

Table of Contents

Enabling Roadnet Integration
Exporting Pickups
Related Topics

Enabling Roadnet Integration

Food banks may choose if the Roadnet integration is enabled for deliveries, pickups, or both depending on their routing needs. Enabling the functionality for donation pickups allows users the ability to route and schedule donation pickups.

1. The Roadnet Setup can be accessed from Departments à Roadnet à Setup à Administration à Roadnet

Setup.

2. To enable Roadnet for Donors, place a checkmark in the Enable Roadnet field on the Donors FastTab.

Note: The General Tab setup options do not apply to the Roadnet export of donation order information. The export process will include the Order Type, Date Added, and Special Instructions and is not configurable.

3. When Roadnet is enabled, any changes to the Donor Card will cause Ceres to show a warning informing you

that you need to update the corresponding record in Roadnet. Currently, Ceres does not export the master

Donor record change to Roadnet.

Roadnet Donor Pickup Batches

Donor Pickups are managed in batches prior to creating Donation Orders. Only one batch is necessary but creating multiple batches may help to separate orders for exporting.

1. The Roadnet Donor Pickup Batches can be accessed from

Departments à Roadnet à Setup à Administration à Roadnet Donor Pickup Batches.

2. Select Home à New to create a new Roadnet Donor Pickup Batch. Specify a name and description for each

batch you wish to create.

Roadnet Location Types

Roadnet Location Types are optional fields that can assist your food bank with filtering donors. This can help with reporting or other informational purposes. When the actual donation pickup export is generated, the Location Type will show as DON to comply with Roadnet formatting standards.

1. Roadnet Location Types can be accessed from Departments à Roadnet à Setup à Roadnet Location

Types.

2. Select Home à New to create a new Roadnet Location Types. Create as many Codes for the Roadnet

Location Types that are applicable to your food bank.

Note: Roadnet Location Types are also available for Transfer Orders and Agency Orders that are sent to Roadnet for dynamic routing.

Preparing Donors

To reduce data input, users can setup pickup information and Roadnet Location Types on the donor records, which flows to new donation orders.

1. The Donor Card can be accessed from Departments à Donation à Planning à Lists à Donors.

2. Select and open a donor that will be routed by Roadnet.

3. On the Receiving FastTab, select a Roadnet Location Type by doing a lookup on the field. In the Special

Instructions field, enter any special instructions that need to be mentioned.

Donor Pickup Specification

Donation pickups that are being routed through Roadnet utilize the Roadnet Donor Pickup Journal as a starting template for dynamic routing. Users are able to schedule expected pickups for each donor by model day and time, and then track status for the actual day once routed. Once the information is sent to Roadnet and the pickup is complete, users are able to generate Donation Order Headers from the journal.

1. The Roadnet Donor Pickup Journal can be accessed from Departments à Roadnet à Periodic

Activities à Roadnet Donor Pickup Journal.

2. Click on the Batch Name field. Select the desired batch and click OK

3. Move to the lines of the Journal. Here you specify the preferred information for the donation pickups.

4. In the Donor No. field, enter the donor number or use the lookup to select the donor from a list. The

Donor’s Name and Special Instructions will flow to the line.

5. In the Pickup Day of Week field, set the day of the week the pickup is requested to occur.

6. In the Pickup Time field, set the time the pickup is requested to occur.

7. In the Special Instructions field, review the instructions that flowed from the Donor Card. You may edit the

field if necessary.

8. In the Order Date for Export field, set the date the pickup will occur. The Pickup Day of Week will adjust to

match the date specified.

9. Repeat the steps above for each additional planned pickup.

Exporting Pickups

Once donation pickups have been prepared in the journal, users will submit the information to Roadnet for routing. Ceres provides a report where users can review the information, and then export the data to a tab delimited text file for uploading.

1. From the Roadnet Donor Pickup Journal, select Home à Process à Export to Roadnet.

2, The Export to Roadnet Pickups Request Page will display.

3. On the Options Tab, place a checkmark in the Export to File field in order to create an export file or leave it

blank to preview the report first. In the Export File Name field, use the ellipses button to set the name and

path for the export file. If Export to File is unchecked, Ceres will not update the value of the Sent to Roadnet

field for the journal.

4. On the Roadnet Donor Pickup Line Tab, set the filters to limit the pickups that are included in the export. To

add additional filters, click the Add Filter button, pick the correct field from the dropdown, then enter the

filter value.

5. Regardless of filtering, the report only considers pickup lines where the Pickup Complete field is unchecked.

You can only process one batch at a time. To process multiple batches, you must select the batch one by

one from the Roadnet Donor Pickup Journal.

Note: The Order Date for Export maps to the Session date in the Roadnet software. When you submit an export file to Roadnet that includes multiple dates, a session in Roadnet will be created for each date.

6. Click the Print button or the Preview button.

Note: If Export to file is checked and a file exists with the same name as the one specified in the Export File Name field, Ceres will send a warning message. Click Yes to overwrite the file or click No and change the Export File Name field on the Report Request Page.

Below is an example of the Export Pickups to Roadnet Report.

Below is an example of the exported file.

Once the export file is created, the corresponding Roadnet Donor Pickup Journal lines will change so that the Sent to Roadnet field will be checked.

Creating Donation Orders

Upon completion of a Roadnet routed pickup, the user will update the Roadnet Donor Pickup Journal by placing a checkmark in the Pickup Complete field. Users will then be able to run a routine that creates the Donation Order Headers for each planned donation that was picked up.

Note: If a pickup was not completed, the Pickup Complete field should remain unchecked.

1. From the Roadnet Donor Pickup Journal, select the desired batch and review the lines.

2. For each line that has been picked up, place a checkmark in the Pickup Complete field.

3. To create donation orders, select Home à Process à Create Donation Order Headers.

4. If there are lines in the Donor Pickup Journal that have not been sent to Roadnet, a message indicating as

such will display. Select Yes to proceed or No to cancel the process.

5. A notification will display indicating the number of donation orders that were created.

6. The processed lines will reset the Pickup Complete and Sent to Roadnet fields so that users can

re-use the Donor Pickup Journal entries for recurring pickups.

7. To access the donation orders that were created, go to Departments à Donation à Order

Processing à Donation Orders.

8. Locate the newly created donation orders and update them with the items that were picked up. Then

process them like you would any other donation order. Notice that the Special Instructions flow to the

order.

9. Repeat the above steps to convert the other donor pickups to orders as they become fulfilled.

Donor Overview
Donation Order Overview
Location Overview
Roadnet Agency Order Exports
Roadnet Transfer Order Exports
Donor Preferred Pickup Days and Times