Stock Count Data Audit

The setting is listed in the Cycle Count Controller.

Stock Count Audit is used to log the steps of counting flows.

It uses the PMX_CCLH table for Log Heads and the PMX_CCLL table for Log Lines. PMX WMS logs into two tables: the header table contains location level information while the lines table stores stock line level information gathered during the cycle count. The detailed table structure can be found in the Database Structure.

The Log Head contains the Location, CycleCountKey and JobName columns as well.

The Log Line contains the details about the counted item.

Both tables contain a Status column, which represents the current state of the count.
The state transitions can be found in the State Diagram.

For summarizing the jobs, there is a sample view PMX_CYCLE_COUNT_JOB.
This can be customized without any restrictions as this is not used by Produmex WMS.

Limitations:
  • Processing Lost&Found counts is not logged fully. The log is only changed when the Lost&Found location doesn’t contain that Item/BatchNumber/SecondBatchNumber/BestBeforeDate anymore. This is a logical constraint of the Lost&Found counting, so this is NOT possible to solve.

Temporary Limitations:
(These limitations will be addressed in future releases)

  • Serial Numbers added during the Processing of the count are not logged. This also means that the processing of these counts are not logged fully.
  • Partial processing of Serial Numbers is not logged fully.
  • SerialNumbers column contains the missing/extra serial numbers in case of difference. If there is no difference during count, it contains every counted serial number. </callout>