CERES5.00.26 - Misc. System Updates

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

Service Request or Support: N/A

When running the "Clean up Orphan Inv. Picks" report, the rendering has a lot of space.
When attempting to change the name of a user (from maiden to married), an error occurs: Cannot write the value "xxxx\xxxx" to the field Relation Code in the table ACF Anveo User because the value is either too long or the content is invalid..."
BOM Journal - Test report (14012560) has the Total Cost in the wrong column (Unit cost column).
When entering an incorrect Item No in documents (AO, DO, PO) you are prompted to add a new Item. This needs to be suppressed this in base. Additionally disable & remove the "Create Item from Description" field from the General Tab or A&R Setup as this feature is not compatible with Ceres Item creation.
Agency Statement actions on agency list page and agency card page refer to 10072 - it should likely use the report selections to avoid confusion as to which report ID is run.
On Page 14012322 (Lots) the "Receive Date", "Unit Cost", "Unit Gross Weight", and "Ship By Date" fields are listed twice. If a users attempts to use the quick filter on any of these fields the page will crash.
The "Posted Invoices" link on the "Buy-from Vendor History" fact box page (Page 9095) is not visible.
The Shopper Name look up on the Agency Order may not display.
"Total Distributed" is misspelled on the Agency Statistics Fact Box.
The first column on report 7321 Inventory Movement is too small to accommodate the heading and data.
Report14012266 (Items On Hand by Location) calculates the “Ext. Gross Weight” based on the Item card. Update this report to calculate the “Ext. Gross Weight” based on the ILE.
Report 14012499 (Items on Hand By Date) is using the ILE Remaining Quantity to calculate the Gross Weight for Kitted Items, but the ILE is not being filtered for the As of Date for the report so ILE entries past the As of Date of the report may be included when the Gross Weight is calculated.
Report 14012499 (Items On Hand by Date) correctly calculates the quantity on hand at the as-of-date. However instead of calculating the weight on hand, it multiplies the item's current weight times the quantity to arrive at the ext. gross weight on hand.
When running Clear Lines from Bank Account Reconciliations and Deposits exist that have been Collapsed, the system doesn't properly reset Bank Account Ledger Entry Statement No. & Statement Line No.
NAV is creating multiple Job Queue Entries for "Calendar Event Execution". While the additional Job Queue entries do not appear to cause any issues it is difficult to find active Job Queue entries due to the number of Calendar Event Execution entries in the Job Queue.
On the Accounting Manager Role Center (Page 9001), the "Vendors" page action is not filtered for Vendor Type = Vendor so vendor and donor records are being displayed.
My Jet Reports does not support Jet Report version 2019.
When lines are present on Donation Order and the FBC Product Category is changed on the header, Ceres askes is the lines should be updated, when the user answers YES, the lines should be updated with the new FBC Product Category but they are not.
Remove or hide the "Check-Avail. Period Calc." and "Check-Avail. Time Bucket" fields from Company Information as these are base NAV fields and not used by Ceres.
The export file is not being saved in folder specified when running the Export Orders to Roadnet process.
After executing the Split Line page action on an Inventory Pick, all pick lines disappear.
Ceres verifies that “Your Reference” on Agency Orders does not exceed 30 characters for "Web Orders" or Agency Orders having an "Appointment Time". Since all Agency Orders for an Agency that is permitted for Web Ordering are sent to Agency Express the verification needs to apply to all Agency Orders when the Agency is permitted for Web orders.
Report 702 (Item Journal Test) should include the “Ext. Gross Weight” and “Reason Code” columns.
Registering Movement from Movement Worksheet generates error: “Pallet No.=XYZ currently resides in Bin Code=ABC. Bin Code must be 123”. The error is generated because Ceres is validating the bin code from the “To-Bin Code” of the movement.
Ceres performs a redundant check to ensure that pallet and lot are specified when required.
Under Shipment Option 2, when using a Shopping Zone with “Exclude from Whse. Doc.” = Yes and selecting an Item with “Pallet No. Required” = No, when the Order is Released and attempted to be posted an error stating that "Warehouse handling is required…” may present.
The Sales/Agency Journal, Purchase Journal, and Cash Receipts Journal does not respect the "Show Amounts" setting on General Ledger Setup when the journals are opened from the Role Center.

Type ID Name

Table 27 Item

Table 36 Sales Header

Table 38 Purchase Header

Table 10121 Bank Rec. Line

Report 702 Inventory Posting - Test

Report 7321 Inventory Movement

Report 14012266 Items On Hand by Location

Report 14012480 Export Orders to Roadnet

Report 14012499 Items On Hand By Date

Report 14012560 BOM Journal - Test

Codeunit 80 Sales-Post

Codeunit 229 Document-Print

Codeunit 1351 Telemetry Subscribers

Codeunit 7301 Whse. Jnl.-Register Line

Codeunit 14012258 Lot Management

Codeunit 14012367 Jet Report Management

Page 1 Company Information

Page 21 Customer Card

Page 22 Customer List

Page 253 Sales Journal

Page 254 Purchase Journal

Page 255 Cash Receipt Journal

Page 459 Sales & Receivables Setup

Page 7378 Invt. Pick Subform

Page 9082 Customer Statistics FactBox

Page 9095 Vendor Hist. Buy-from FactBox

Page 14012322 Lots

This release does not present a change in system usage methodology.

Resolution: Ceres was enhanced to address the issues.

The indicated report was previously updated as part of the establishment of Ceres5.00.00 to eliminate white space. Notes that place holder header information is displayed for the categories of orphan documents. This is by design.
The “User Name” field was expanded to accommodate 50 characters in order to confirm with the “User Name” accepted length of base NAV. This update was made as part of the establishment of Ceres5.00.00.
The “Total Cost” summation was aligned with the “Total Cost” column header.
The indicated option dialog was suppressed and the "Create Item from Description" control was removed from A&R Setup. Note that the value of the "Create Item from Description" should be verified as being set to ‘No’ prior to importing CERES5.00.26.
The “Agency Statement” action on the Agency List and Card pages were updated to run the report specified for Agency Statement on the “Report Selections – Agency” page.
The indicated duplicate fields were removed from the Lots page.
The "Posted Invoices" link on the "Buy-from Vendor History" fact box page (Page 9095) was set to be visible.
The Shopper Name look up on the Agency Order was updated to display properly.
The spelling for the "Total Distributed" link was updated on the Agency Statistics Fact Box.
Updated the RDLC for improved display of headers and data.
The indicated report was update to calculate the “Ext. Gross Weight” based on the ILE.
The indicated report was previously updated as part of the establishment of Ceres5.00.00 to address the reporting issue.
The indicated report was update to calculate the weight on hand properly.
Ceres was updated to properly reset the Bank Account Ledger Entry Statement No. & Statement Line No.
As Calendar Events only apply SaaS NAV tenants, the functionality was disabled for Ceres.
The indicated page was previously updated as part of the establishment of Ceres5.00.00 to address the filtering issue.
Ceres support for Jet Reports version 2019 was added while retaining support for Jet Reports 2018 R2 and previously supported versions.
Ceres was updated to cascade the changed value for the header’s “FBC Product Category Code” to the related lines. Note that this also updates the “UNC Product Category Code” for related lines and applies to Donation and Purchase Orders alike.
The indicated controls were removed from the “Company Information” page.
The indicated report was updated to save the export file to the user defined directory.
The filtering was updated to prevent pick lines from being filtered out of the current view.
Ceres was updated to extend the “Your Reference” verification to all Agency Orders for an Agency that is permitted for Web orders.
The indicated report was updated to include the “Ext. Gross Weight” and “Reason Code” columns. Additionally, the report was updated to reflect its format in Ceres 2009. In order to provide more useful information, the following changes were made: “Invoiced Quantity”, “Unit Amount”, and Amount columns were removed. The “Pallet No.”, “Lot No.”, and “Unit of Measure Code” columns were added. Lastly totals by “Entry Type” and a report total were added for the Quantity and “Ext. Gross Weight” columns.
Ceres was updated to validate the bin code for the Movement’s From-Bin Code.
Ceres was updated to disable the redundant check for pallet and lot number.
Ceres was updated to disable the redundant check for pallet and lot number. Note that this issue is related to issue 26 as reported in this document.
The Sales/Agency Journal, Purchase Journal, and Cash Receipts Journal were updated to respect the "Show Amounts" setting on General Ledger Setup.