Ceres5.00.34.1 - Backporting of Ceres5.01.60 (HER)

Modified on Wed, 29 Mar 2023 at 11:56 AM

Service Request or Support Case: SR-0002978

Issue addressed: Feeding America requests changes to Ceres in order to support the FANO HER initiative for select legacy Ceres versions.


Note: This release is ONLY applicable to sites running Ceres 5.0 on NAV 2018 executables.


Objects Affected:

Type               ID                    Name


Table              18                    Customer

Table              27                    Item

Table              32                    Item Ledger Entry

Table              37                    Sales Line

Table              39                    Purchase Line

Table              83                    Item Journal Line

Table              14012332      Item Ledger Report View

Table              14012341      Master Descriptor

Table              14012375      Nutrition Rubric

Report            14012279      HER Rating Export

Report            14012524      Agency Invoice

Report            14012525      Ceres Agency Order

Report            14012533      Agency Invoice w/ Grant Det.

Codeunit       14012262      Outbox Processing

MenuSuite    1052               Dept - Ceres

Page               30                    Item Card

Page               38                    Item Ledger Entries

Page               46                    Sales Order Subform

Page               54                    Purchase Order Subform

Page               14012622      Item Ledger Report View List

Page               14012351      Donation Order Subform


This release presents a change in system usage methodology. The following procedure documents were updated accordingly.

  1. Item Overview
  2. Item Nutrition Overview


Resolution: With this release, Ceres has been enhanced to implement changes to the management of Nutritional data associated with the FANO HER Initiative.   See noted procedure document for additional information.




  1. CreateCeresViews.sql is required to be updated and the CreateCeresViews process run when implementing CERES5.00.34.1.  CreateCeresViews_5_00_34_1.sql is provided with this release which contains the required updates. Be sure to update the USE statement within the script to reference to applicable database.
  2. Update the Member Data Sharing team (need this anytime fields in the item or item ledger entry tables have field adds/deletes).
  3. Update Techbridge support so they can make the appropriate updates on their end to add the "HER Rating" to the ITM File.

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