Zero-Quantity Items

PeopleSoft Inventory stores information for items received and put away into the PeopleSoft Inventory business unit. After items have been either adjusted to zero or shipped completely out of a storage location, the PHYSICAL_INV table reflects the zero quantity. Because the Event Creation process includes these zero-quantity records in each counting event, you count event lines for stock that is not there, requiring more time to run the cycle counts and making it harder to identify exactly which items need to be counted. The Counting Event Setup - Count Options page and the Event Creation page both include options that eliminate or limit the number of zero-quantity rows included in counting events.

The zero-quantity count option is not applicable to all cycle count options. For example, a negative balance cycle count includes only items in storage locations with negative available quantities. Additionally, a manual cycle count includes only the items that you choose to include in the counting event.

Eliminating zero-quantity records from the counting event excludes storage locations identified by the system as empty (associated with zero-quantity items). To confirm empty locations, add the empty locations to the existing counting event, using the Item Counts page, or perform a manual count.

In addition to using the zero-quantity count option, you can remove zero-quantity item records from the Physical Inventory table (PHYSICAL_INV) using the physical inventory purge routine. Perform this purge periodically to minimize the number of zero-quantity stock records in the PHYSICAL_INV table.