I am really new to Sage program. I ran a physical count variance report after a physical count was done. However, the Quantity on Hand shows zeros for every item. What did I do wrong>
Thank you
I am really new to Sage program. I ran a physical count variance report after a physical count was done. However, the Quantity on Hand shows zeros for every item. What did I do wrong>
Thank you
The “ideal” process to follow for physical count is:
The Physical Count variance is checking the counted amount against the frozen amount (which is really just a snapshot of inventory at that point in time) set at the start of the process. The current quantity on hand is not part of the process, after the items are frozen.
If I did not freeze the items and we did a physical count and uploaded it would it add the inventory counted to the inventory on hand.
I believe Sage will take the current QoH at the time of the import (regardless of any unposted transactions) as the beginning quantity, but I'm not sure on that.
If you had not frozen your inventory counts, and instead just added your "new counts" to the Inventory Physical Count Entry Screen, Sage will process a transaction that "adds" to inventory the quantity difference between what was "frozen" and what you "counted". If the "Quantity on hand" = zero, and your "Qty Counted" = 10 (as an example); the update will +10 to inventory as an IP transaction. I'd suggest copying your company to a test company, then posting the physical count variance to see what gets "added" and the GL Impact, prior to posting in your live company.
Thank you
*Community Hub is the new name for Sage City