CERES5.03.66 - Pallet Suggestion Handling for Qty. Available

Modified on Fri, 16 Jan at 12:41 PM

Service Request or Support: N/A

Issue Addressed: Ceres does not consider pallets recorded as a pallet suggestion as being available inventory. However, Ceres does consider pallets recorded as a pallet suggestion as demand. Consider the pallets and their availability below (and assuming the pallets comprise all available quantity for their related item). Ceres would not count the first two pallets as having any available quantity (due to them being represented as a pallet suggestion). Thus, the calculated available quantity would be 2. Demand, however, is also calculated as 2 leaving zero available quantity.

Pallet No. Available Quantity Pallet Suggestion Exists

1305-00001 1 Yes

1305-00002 1 Yes

1305-00003 1 No

1305-00004 1 No

Objects Affected:

Type ID Name

Table 37 Sales Line

Table 39 Purchase Line

Table 83 Item Journal Line

Table 5741 Transfer Line Yes

Table 5767 Warehouse Activity Line

Table 7321 Warehouse Shipment Line

Table 7326 Whse. Worksheet Line

Table 14012507 Kit BOM Journal Line

Codeunit 6620 Copy Document Mgt.

Codeunit 14012258 Lot Management

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

Resolution: With this version, Ceres will consider pallets recorded as a pallet suggestion as being available inventory. Thus, the calculated available quantity would be 4, demand would be 2, and the available quantity would be 2.

Note: With this release, the “Ceres5.03.66 - CreateQuantityAvailableProcedures.sql” version will need to be executed within SSMS.