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

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.

NOTES:

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.