Physical Count Situation

SOLVED

Hey All,

I saw this post https://www.sagecity.com/us/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/94349/you-cannot-proceed-with-unposted-data-in-physical-count-entry, but I want to elaborate a bit to see if I can find the genesis of my problem.

My supervisor was trying to change a valuation in Sage 100 Advance 2019 with Manufacturing, and he received the message:

I have no idea how a Physical Count was started, and ALL of our inventory was put into Physical Count, but when we were trying to figure out what happened, we ran the Physical Count Variance Register which should unfreeze items.

According to the post I linked above, we should just be able to clear the Physical Count Worksheet, but shouldn't the Variance Register do that as well?

Our biggest concern right now is that we will not be able to close the month. So, I humbly submit a few questions:

1. How did our Inventory get put into Physical Count?

2. Can we clear the count to unfreeze items without impacting our true inventory? We did NOT put any new values into the count, and the Variance Register doesn't reflect what we have in inventory at all

3. Can we close the month if we can't resolve this right away?

4. And finally, how do we figure out how the count wast started?

Thanks all, I am completely confused on this one.

  • +1
    verified answer

    Query IM_Physical (linking to SY_User to translate user key's into names) to figure out the when / who... which should hopefully help you understand the how.

    Using Physical Count Worksheet should allow you to un-freeze everything.  If it doesn't there could be bad data in the table, which gets more complicated.

  • 0 in reply to Kevin M

    Hey Kevin M,

    Thanks for pointing me at the data query through Excel! I'll try that, and I'm sure that will help me suss out what exactly happened. And as for putting the kibosh on that Physical Count, I was able to reinitialize the data files for the Physical Count and all is well!

    As always, thank you for the help. I am eternally grateful!