Roadnet Agency Order Exports

Modified on Thu, 30 Nov 2023 at 01:02 PM

 

 

 

Roadnet Agency Order Exports

 

 

 

Purpose of this document

 

This document outlines the Agency Order portion of the Roadnet Export.

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


 

 

TABLE OF CONTENTS


 

 
 

 

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 deliveries allows users the ability to export Agency Orders for dynamic routing of deliveries.

 

  1. Roadnet Setup can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Roadnet Setup” in “Tell me what you want to do” then selecting “Roadnet Setup” from the results in the Go to Pages and Tasks section OR by selecting the “Roadnet Setup” menu action (if present) from your Role Center home page.

 

 

  1. Toggle on the Enable Roadnet field on the Agencies FastTab.

 

 

  1. When Roadnet is enabled, any changes to an Agency Card will cause Ceres to show a warning informing you that you need to update the corresponding record in Roadnet. The updated master data does NOT export automatically from Ceres to Roadnet.

 

 

 

Roadnet Setup for Agency Deliveries

 

The delivery routing is sent to Roadnet via an export. Users can define the level of information sent.

 

  1. Select the information that should be reported to Roadnet by toggling on the appropriate fields.

 

 

Include Order Type: The export will show an ‘O’ to indicate an order.

 

Include Date Added: The export will relay the posting date from the Agency Order.

 

Include Special Instructions: Users may enter information in the Special Instructions field on a Transfer Order to indicate delivery rules, contact information, or other information that is pertinent to the transfer. An example might be, “When you arrive, ask for Joe.” The export can relay this information.

 

Note: Currently, Order Type and Date Added are mandatory information for Roadnet to process information from Ceres. Leaving these fields toggled off may lead to undesired results.

 

 

 

Roadnet Location Types

 

Roadnet Location Types are optional fields that can assist your food bank with filtering Agency Orders that are included in an export. This can help with grouping orders or segregating which orders should be part of Roadnet.

 

Once the Roadnet Location Types are created, they can be added to the Agency Card. This information will flow to new Agency Orders.

 

When the actual export is generated, the Roadnet Location Type will show as ‘PRG’ to comply with Roadnet formatting standards.

 

  1. Roadnet Location Types can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Roadnet Location Types” in “Tell me what you want to do” then selecting “Roadnet Location Types” from the results in the Go to Pages and Tasks section OR by selecting the “Roadnet Location Types” menu action (if present) from your Role Center home page.

 

 

  1. 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 Donation Orders that are reported to Roadnet.

 

 

Preparing Agencies

 

To reduce data input, users can set up delivery information and Roadnet Location Types on the Agency records, which then flow to new Agency orders.

 

  1. Agencies can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Agencies” in “Tell me what you want to do” then selecting “Agencies” from the results in the Go to Pages and Tasks section OR by selecting the “Agencies” menu action (if present) from your Role Center home page.

 

  1. Select and open an Agency that will be routed by Roadnet.

 

  1. Expand the Shipping FastTab.

 

  1. Lookup on the Roadnet Location Type field and select a Code (field may need to be added using personalization).

 

  1. In the Delivery Info. field, enter any special instructions that need to be mentioned.

 

 

Preparing Agency Orders

 

Deliveries that are being sent to Roadnet allow users to specify pallet counts for the UNC storage requirements for dry, refrigerated, and frozen products. This helps in determining the load configuration for the delivery routing in Roadnet. Users may optionally indicate special instructions and the Roadnet Location Type to provide further details.

 

  1. Agency Orders can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Agency Orders” in “Tell me what you want to do” then selecting “Agency Orders” from the results in the Go to Pages and Tasks section OR by selecting the “Agency Orders” menu action (if present) from your Role Center home page.

 

 

  1. Create a new order or select an existing order.

 

  1. Expand the Delivery/Web FastTab.

 

  1. Enter values for the Frozen Pallet Count, Ref Pallet Count, and Dry Pallet Count for each UNC Storage Requirement.

 

Note: These values are included in the export file and are calculated towards the file’s totaled Sum Pallet Count field. If the value is left blank, the corresponding value in the export file will be blank.

 

  1. On the Delivery Info field, enter any special instructions that need to be mentioned.

 

Note: If Special Instructions was on the Roadnet Integration Setup form, the Special Instructions will be included with the export.

 

  1. If needed, select the location type for the Roadnet Location Type field.

 

 

Exporting Orders

 

Once the Agency deliveries have been released, users may 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. Export Orders to Roadnet can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Export Orders to Roadnet” in “Tell me what you want to do” then selecting “Export Orders to Roadnet” from the results in the Go to Reports and Analysis section OR by selecting the “Export Orders to Roadnet” menu action (if present) from your Role Center home page.

 

 

  1. On the Options FastTab, ensure that Include Transfers is off.

 

Note: If Include Transfers is selected, the report will attempt to export Transfer Orders between food bank locations instead.

 

  1. Toggle on the Export to File field to create an export file or leave it blank to preview the report first.

 

Note: If Export to File is toggled off, Ceres will not update the value of the Roadnet Status field on the Agency Order(s).

 

  1. In the Export File Name field, set the name and path for the export file.

 

 

  1. In the Roadnet Exported field on the Agency Order FastTab, select if you want to filter for orders that have not been sent to Roadnet, or filter for orders that have already been sent and need resubmission. If you want to choose both, leave this field blank.

 

  1. Set the rest of the filters accordingly to limit the orders that are included in the export. In the example below, the generated report will include orders that are released, have a Shipment Date of 08/08/18, are Delivery orders, have a Roadnet Location Type of LOC, and were not sent to Roadnet.

 

Note: The Shipment/Pickup Date 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.

 

 

  1. Click the Print button or the Preview button.

 

Note: If Export to file is toggled on 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 form.

 

Below is an example of the Ceres report:

 

 

Below is an example of the exported file.

 

 

Once the export file is created, the corresponding Agency Orders will change so that the Roadnet Exported field will be toggled on.

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article