WMS and Cycle Counting

[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.

 

[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.