Distribution Pounds by County Report with XML Export (v5)

Modified on Fri, 26 Apr at 9:26 AM


 

Purpose of this document

 

The Distribution Pounds by County Report in Ceres includes an option to generate an XML file for upload to HungerNet. This document covers the export process

 

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


 

 

Table of Contents

 

Setup

 

Prior to generating the Report and/or XML file for upload to HungerNet, the following setup steps need to be completed. For an even longer review see the Feeding America Reporting Procedure.

 

1. UNC County Codes

  1. Verify with Feeding America that the import process has been run to populate the UNC County Codes.
  2. The UNC County Codes can be accessed from Departments à Administration à Application Setup à General à Food Bank Codes à Counties.

 

 

2. Link the FBC County Code to the appropriate UNC County FIPS Code.

  1. For each FBC County Code listed, select the appropriate UNC County FIPS Code from the edit assist list or enter it manually.

 

 

3. Mobile Pantry Drops Indicator.

  1. An indicator has been added to the Agency Card, Information Tab to designate if Agency Orders from the Agency should be considered.
  2. The Agency List can be accessed from Departments à Agencies & Receivablesà Agency Relations à Lists à Agencies.
  3. Once an Agency is selected, Click Actions à Edit to edit the details of that Agency.


 

  1. If the Mobile Pantry indicator on the Agency Card is selected, the user will be prompted with the following:

 

 

A “Yes” answer will set the Mobile Pantry indicator on the Agency Card and on all posted Agency Orders for that Agency.  The Mobile Pantry Drop indicator will also be defaulted to “Yes” for any new Agency Orders for this Agency.

A “No” answer will set the Mobile Pantry indicator on the Agency Card and the Mobile Pantry Drop indicator will be defaulted to “Yes” for any new Agency Orders for this Agency.  No existing transactions will be updated.

Note: While the Mobile Pantry indicator will be defaulted to “Yes” on any new Agency Orders, the indicator can be set to “No” on an Agency Order if that specific Agency Order is not a Mobile Panty Drop.

 

Distribution Pounds by County Report

 

1. Click Departments à Financial Management à Receivables à Reports à Distribution Pounds by County.

 


2. This will open the request page.


 

3. If the Export XML option is not selected:

  1. The report can be run for any Begin Date and End Date
  2. The XML file will not be created.

 

4. If the Export XML option is selected:

  1. The report can only be run for a Begin Date and End Date that spans a complete Month or Quarter depending upon which Report Type has been selected.
  2. The Report Type “Monthly” or “Quarterly” must be selected and match the period covered by the Begin Date and End Date.
  3. The Period Number must be specified and match the Report Type selected and the period covered by Begin Date and End Dates.
  4. The XML file will be created in the location specified in the Temp Path field for the user running the report.  This path is normally set to “C:\NAVTEMP\”.  Once saved it is recommended to move the report to a location on your network so that more than just the person running the export can access the file.


 

 

5. The XML file will be named by process as follows:

 


6. Amounts on both the Report and XML Export are now rounded to the nearest whole number.

 

 

7. If a County is included on the Report and/or XML Export and does not have a UNC Count FIPS Code associated with it, the user will receive the following message upon running the report and/or export.

 

 

To resolve this error, review the FBC County Codes list to ensure that every county listed has a UNC County FIPS Code specified.

 

8. The number of Mobile Pantry Drops has been added to the printed report to the right of the Agency Count field.

 

 Related Topics

  1. Agency Overview
  2. Agency Order Overview
  3. Blue Receipt Activity Report
  4. FA Reporting and UNC Coding (QPRs_Blue Receipts)
  5. Receipts and Distribution Report with XML Export
  6. QPR Import User Guide

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article