CERES5.03.17 - Missing Pallets during AGI Reconciliation process

Service Request or Support: N/A

Issue Addressed: 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. 

Objects Affected:

Type               ID                    Name

Table              307                 Inventory Buffer

Report            14012587      Calculate Inventory-WMS Recon

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

Resolution: Ceres was enhanced by adding a dedicated sorting key by Item No. and Pallet No. to the Inventory Buffer table and implementing the new key in the Calculate Inventory-WMS Recon report (RP 14012587), to correctly sort the Inventory Buffer to select all available Pallets per Item.