CERES5.01.98 - Exclude non Lot No. Required Items in Distribution Reports

Modified on Tue, 11 Apr 2023 at 09:34 AM

Service Request or Support: N/A

Issue Addressed: Distribution Pounds by County Report (14012292) will error if using any 'Non-Lot Tracked' Items in distributions to agencies during the period specified: These Items should be excluded. Receipts & Distribution report (14012277) is including 'Non-Lot Tracked' Items in the inventory by Storage Requirement summary portion of this report: These Items should be excluded.


Objects Affected:

Type               ID                                Name

Table              14012332                  Item Ledger Report View

Report            14012277                  Receipts & Distribution

Report            14012292                  Distribution Pounds by County



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

Resolution: Ceres was enhanced by adding filters to reports 14012292 (Distribution Pounds by County) and 14012277 (Receipts & Distribution), to exclude non ‘Lot No. Required’ Items.

A key update was required for table 14012332 (Item Ledger Report View) for the CALCSUM fields used in report 14012332: the ‘Lot No.’ field was added to key ‘Posting Date’, ‘UNC Storage Requirement Code’.

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