Frozen Quantity Question

[ocgregw]

We run cycle count daily using the frozen quantity. We ran the cycle count selection on Friday 2/8/13 in the AM. The same afternoon the counts were entered and the Variance Report was generated. On all items the frozen quantity and the counted quantity matched. The following Monday, 2/11/13, The Physical Update was run. The frozen count on all items now showed zero on the report. The report did not list any change to inventory. What we have subsequently discovered is that the on-hand inventory for every item was increased by the counted quantity. We have been running cycle count for years and have never had this problem.

Any thoughts on what could have happened?

We are on Macola/ES Version 9.5.700

Thanks

 

[dgillz]

If the frozen count was zero, I would expect the qty on hand to increase by what you counted. The question is why/how did this happen? Can you perform a small cycle count on one item and see if the frozen quantity is set back to zero?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[ocgregw]

We have been doing a daily cycle count Monday thru Friday since this happened and have never had the problem repeat. I think something happened to the data base that caused the frozen count to be set to zero. That is what I am trying to figure out.