Ceres 20.6.00.13 (08.02.24)

Modified on Mon, 5 Aug at 8:59 AM

Batch Number: 20.6.00.13

Included:

Work Item No.	Type	Work Item Description	Work Item Issue Description
397	Enhancement	Expand Master Record Templates to include Ceres fields	The following fields were added to the Vendor Template: Fund No., FBC Product Source Code, FBC Product Category Code, Order Handling Group Code, Order Routing Group Code. The following fields were added to the Agency Template: Fund No., FBC County Code, FBC Agency Category Code, UNC Activity Status, Agency Group Code, Delivery Zone Code, Order Handling Group Code, Order Routing Group Code. The following fields were added to the Item Template: Pallet No. Required, Value Item By, Handling Fee (per LB), VAP Fee (per LB), USDA Value, Cost Adjustment Type, Cost Adjustment Factor, FBC Storage Requirement, FBC Product Type Code, FBC Package Type Code, FBC Product Category Code, Item Group Code.
402	Issue	Integration of Ceres5.02.83 - Restricted Pallet Movement and Reclassification	Implementing Ceres5.02.83 in the same manner as it was implemented for Ceres 5.1 is not technically possible in Ceres 6 as it requires updating the Base Application. Due to this movements to/from a Receiving Bin via the Movement Worksheet is not included. If necessary, the Reclassification Journal can be used to transfer inventory to/from a Receiving Bin. The update to allow inventory to be transferred to/from a Holding Bin via the Reclassification Journal was accommodated.
425	Issue	Account Name field on journals missing header	The Account Name field can be added to the Cash Receipt Journal and Payment Journal to indicate the name of the account entered. When the field is added to the respective journals via a page personalization the field correctly displays the account name, but the field does not have a title.
427	Enhancement	Add "Line No." to journal pages	A 'Line No.' field was added to the following journal pages: Purchase Journal, Agency Journal, Cash Receipt Journal, Payment Journal, Grant Journal.
474	Enhancement	Add Longitude and Lattitude to the Agency Card	Add the Longitude and Lattitude fields to the Agency Card, Address & Contact Tab, below the Zip Code.
502	Enhancement	Add option to print Agency Pallet Tags when creating Inventory Picks	When Agency Pallet Tracking is enabled on Inventory Setup, the Agency Pallet Tag is defaulted to be printed when the Pick is created. A new option 'Print Agency Pallet Tag when creating Pick' has been added to Inventory Setup to control if the Agency Pallet Tag is defaulted to be printed or not when the Pick is created.
505	Enhancement	Add print menu action to the Inventory Picks list page	Currently, an Inventory Pick can only be printed from the individual pick page. Add a 'Print' action to the Inventory Picks list page that will call the pick report for the current selected pick.
509	Enhancement	Add Post & New Action to Donation Order	Add a "Post & New" page Action to the Donation Order (Page 14012350) under the Posting menu.
518	Issue	Generate E-Statements utilizes the incorrect Report Selections Usage	The Generate E-Statements process calls the 'EmailAgencyStatement' function in WCC Food Bank Utilities. 'EmailAgencyStatement' attempts to find the appropriate Agency Statement in report selections via Usage = WCC A.Smt. Update the 'EmailAgencyStatement' function to find the appropriate Agency Statement in Report Selections via Usage = C.Smt to match the Report Selection Usage for Agency Statements.
519	Issue	Transfer Order Quantity Available Issue	In certain cases when attempting to select a Pallet No. on a Transfer Order, a Quantity Available error is encountered when there is sufficient quantity available to transfer. If the Pallet selected on the Transfer Order is in an Exclude from Whse. Doc. Zone, Ceres is only considering quantities that are in the Exclude from Whse. Doc. Zone as available inventory and then deducting the full order demand to arrive at Qty Available. The Qty Available calculation has been updated to include the "Exclude from Whse. Doc. Zone" option when calcluating order demand.
520	Issue	Change of Lot Expiration & Consume by dates are not cascaded correctly	On a Purchase Order, Donation Order, and/or Item Journal if the Lot dates (Consumed by, Expiration, and Ship By dates) are changed on any line after the Pallets have been created (e.g. multiple lines with the same Lot No.), the Lot Dates on the remaining PO/DO and/or Item Journal lines are not updated. When posted, the resulting ILE entries can have multiple dates which causes Item/Lot availability issues.
522	Issue	5.03.08 - Expired Lot List excludes palletized items	With Ceres 5.02.89 (Incorrect expired Lot List suggestion after WAP creation) applied, Expired Lots for Palletized Items are not included on the 'WAP Expired Lots' report generated from the WAP.
523	Issue	5.03.09 - Inventory Values not passed properly when doing Inventory Adjustment	For Items where 'Value Item By' is set to 'Effective Date', Inventory Values are not passed properly when doing an Inventory Adjustment.
524	Issue	5.03.10 - Inventory Valuation report does not calculate Kitted Items correctly	Inventory Valuation Report does not calculate Kitted Items correctly. When an Item is a kitted, Item Unit Value should be composed of the Lot's Unit Cost plus Lot's Unit Value.
525	Issue	5.03.11 - Expand Ceres No. fields to 20 characters to match base	Most of the Ceres specific 'No. Series' fields that have been added to the various setup tables (S&R, P&P, Inventory, etc.) are defined as Code 10. Base BC 'No. Series' fields are defined as Code 20. Expand the Ceres No. fields to match base BC.
526	Issue	5.03.12 - Pallet Suggestion assoc. w full pallet AO-Line deleted upon WAP Posting	When a Location is configured for Sug. Full Pallet from Put Away. The Pallet Suggestion associated with the full pallet Agency Order line is deleted when the WAP is posted so when the Pick is created from the Agency Order, the Pallet No. is not available for population on the Pick line.
527	Issue	5.03.13 - GotoLine functionality not working correctly on Invt. Pick (Skip) Miniform	The Go to Line functionality in the 'Invt. Pick (Skip)' Miniform is not reading and displaying the correct Whse. Activity Line entered when utilized.
528	Issue	5.03.14 - Blue Receipt Footer Totals not printing correctly	The Blue Receipt Activity report does not correctly calculate the Quantity and Weight totals for each Receipt/Return. Further, Receipts/Returns with multiple pages have interim totals that are incorrect.
529	Issue	5.03.16 - Posting error after adjusting quantities for Kit Disassembly in BOM Journal	Using the 'Suggest Kit Disassembly' function in the BOM Journal to disassemble part of a kit, via adjusting or deleting quantities, results in missing lot number error(s) and/or an unbalanced disassembly transaction.
530	Issue	5.03.17 - Missing Pallets during AGI Reconciliation process	Pallets were identified as missing during the AGI Reconciliation process. A review of the process determined that it was only generating the first Pallet by Bin Code per Item.
531	Issue	5.03.18 - New WMS bins conform AGI standards	Update WMS Setup to ensure that WMS Bins conform to AGI standards by adding minimum length(s) for each Bin segment.
532	Issue	5.03.19 - WAP allow only one Item per Bin	Bins can be configured to allow multiple Items on the Warehouse Activity Plan (WAP). The WAP should only allow one Item per Bin unless the Bin is configured to allow mixed Items.
533	Issue	Ceres Questionnaire updates	When a Ceres Question is defined as Multiple Choice Answer Type and the Type is either Single or Multiple and that Ceres Question is attached to a Ceres Questionnaire and the multiple-choice options are define for the Questionnaire, when the Agency Activity Review matrix page is opened, only the last multiple-choice option shows up as a Boolean field.
534	Issue	5.03.23 - Not updating Consume By and Expiration Dates on Lot No. Information	In the Lot No. Information table, function UpdateLotNoDates, the ItemJnlLine set range is incorrect. This error causes the 'Consume By Date' and 'Expiration Date' on any In-Process Item Journal lines to not be updated if the dates are changed on the Lot Card prior to the journal being posted.
535	Issue	5.03.24 - Lot No. Info created without FBC Coding	If an Item is created without FBC Coding, but used in a Receipt (PO, DO, Item Journal), and the Lot is created, the Lot is created with blank FBC Codes. Ultimately when the user corrects the Item and enters the FBC Coding, the Lot continues to contain blank FBC Codes.
536	Issue	5.03.25 - AGI Updates	The Ceres AGI interface is experiencing the following issues: 1. False insufficient quantity error on Picks. 2. Zone is not checked properly when excluding from WMS. 3. Quantity on Inventory Picks is not included in reconciliation count. 4. Can’t view pallets across multiple Queues.
537	Issue	5.03.26 - Creating Allocations with Standing Appt uses wrong date	When creating Agency Orders from the Allocation Journal, when a Standing Appointment is found and consumed, the resulting Agency Order has the incorrect Shipment Date
538	Issue	5.03.27 - Prevent Duplicate Pallet No.	When creating new pallets in Item Journal, Purchase Order, or Donation Order, it is possible to reuse the same Pallet Number on different lines with different Bins as long as they are new Pallets without existing quantities.
539	Issue	5.03.29 - WMS Update Bin Type Code	When adding a new Bin for a WMS enabled Location, specifying a Bin Type Code generates a 'Changes to the Bin Type Code are not sent to AGI. Please manually update AGI to reflect the Bin Type Code change was made in Ceres' message. This message should only appear when changing the Bin Type on an existing Bin that was already sent to AGI.
540	Issue	5.03.30 - Remove Exact Cost Reversing Mandatory from Purch. Setup	With Exact Cost Reversing Mandatory set on Purchases & Payables Setup, Purchase Return orders will not post after using get posted lines to reverse or copy document. When attempting to post it errors on the Applies to ID being set to blank.
541	Issue	5.03.31 - Prevent Negative Lots via Item Journal	Negative Lots for palletized and non-palletized Items can be created from an Item Journal. If you enter a Positive transaction (Positive Adjustment or Purchase) on an Item Journal and then change the Entry Type to Negative transaction (Negative Adjustment, Transfer, or Distribution), Ceres does not re-check availability prior to posting the Item Journal which can result in a negative Lot.
542	Issue	5.03.32 - Invt. Shorts/Cuts Handling for SO1 and SO3	The 'Inv. Short Handling Method' control on the Location Card is not editable for Shipment Option 1 or Shipment Option 3. For an Agency Order having a Shipment Option 1 Location specified, Ceres will not allow for the 'Qty. to Ship' to be modified when the Agency Order is in the Released Status.
544	Issue	5.03.34 - Send UNC Storage Requirements on all Items	AGI would like the UNC Storage Requirement sent on all Items as part of base Ceres.
546	Issue	5.03.37 - Qty. Available for Purch. Returns	The 'QtyAvailThisPalletWithReturn' function is used to calculate the maximum quantity of a pallet that can be returned on a Purchase Return Order. When a pallet to be returned is in use with an Agency Order, an Inventory Pick, or Warehouse Shipment, the demand quantity will be counted twice.
547	Issue	Pallets and Pallets (Available) pages do not filter totals correctly.	When certain 'Filter Totals by filters' are applied to the Pallets or Pallets (Available) pages, the totals are not correctly filtered. 'Filter Totals by' for Branch Filter, Date Filter, and Location Filter are supported for all fields on both pages. 'Filter Totals by' for Bin Filter and Zone Filter are not supported for the Quantity on Hand, Qty. Available to Take, and Net Change fields.
550	Enhancement	Remove/Hide Whse. Fund No. on General Ledger Setup	General Ledger Setup contains a 'Whse. Fund No.' field on the General Tab. With Ceres 6 a 'Removal of Self-Balancing Elements from UI' project was completed to remove the Self Balancing elements from Ceres. 'Whse. Fund No.' should have been included in that effort but was missed.
551	Issue	AE Item Description 50 character limit	Agency Express has a 50 Character Limit associated with Item Descriptions. In Ceres 6 the Item Description can be up to 100 characters. When sending Item Descriptions longer than 50 characters to Agency Express an FTP issue is encountered. When Outbox Processing sends the Item Description to Agency Express, the Item Description needs to be limited to 50 characters.
553	Issue	Changing Parent Donor on Donor record generates a permission error	When changing the Parent Donor on a Donor Card a permission error occurs when the process attempts to update Donor/Vendor Ledger Entry table.
555	Enhancement	Add Longitude and Lattitude to the Donor Card	Add the Longitude and Lattitude fields to the Donor Card, Address & Contact Tab, below the Zip Code.
556	Enhancement	Add Document No. and Posting Date filter to Get Posted Document Lines to Reverse	For the 'Get Posted Document Lines to Reverse' process from an Agency Return Order Ceres added dedicated filters for Document No. and Posting Date to the request page. Add the same dedicated Filters (Document No. Filter and Posting Date Filter) to the Get Posted Document Lines to Reverse process called from the Donation Return Order and the Purchase Return Order.
557	Enhancement	Add Last Modified by information to Agency Order list and page	Add the Last Modified By, Last Modified Date, and Last Modified Time to the Agency Order List page (last fields on the list page) and the Agency Order Card page (General tab as last fields on the tab available via 'Show More').