WMS and Cycle Counting (1 Viewer)

[tmyers]

I cant determine how to do the table structure for handling cycling counting. Do I need an audit table? Or is one table with before/after quantities enough? Do I need to lock tables while the DB is in "cycle count mode" to prevent records from changing? I can see so many different possible methods that I am going cross eyed and have confused myself.

 

[Pat Hartman]

The order process should encumber inventory but not deplete it. The picking action is the final step to remove inventory. And the people conducting the cycle count will not interfere with picking.

 

[tmyers]

You would still want to log changes when a discrepancy arises though, correct? If the DB shows having x and you confirm you only have y, you would want to log that before simply adjusting.

 

[Pat Hartman]

Each inventory adjustment regardless of the cause - receive (from a PO), pick (for an order), adjust (based on difference between cycle count and calculated count) -- is a separate transaction. All the transactions are summed to calculate the in stock quantity.