You’re offline. This is a read only version of the page.
12
We have a user that submitted a physical inventory count, and all of the expected quantities were at 0, so all of the deltas were positive. At first I expected user error, however I'm having a hard time wrapping my head around how they would have accomplished this without changing every item to a 0 count by hand.I feel that is very unlikely considering the number of items they would have had to touch.
I searched through the record deleted log table and found a deleted physical inventory count, but the count was deleted a few months ago, and they have counted the items between then and this latest count. I would have expected a more recent count with all quantities committed at zero, but that was not found
I checked out the recent transfers, both in and out, and nothing adds up to the quantities and number of items that we're seeing. The purchase orders are the same, just a handful items that do not add up to the missing counts in the latest inventory count.
The previous inventory count had expected quantities for the same items, so we know something happened between the counts, or more likely, at the time of the latest count.
So now I'm really not sure if it's user error or some kind of glitch. Any ideas how this could have happened?
*This post is locked for comments
I have the same question (0)
Jesse:
If you are comfortable looking at the SQL tables then you can go to your database and look at the records in the InventoryTrasferLog table by running some adhoc SQL queries. You can look up the records for a particular ItemId to troubleshoot what might have caused this.
For example:
SELECT * FROM [dbo].[InventoryTransferLog] WITH (NOLOCK) WHERE ItemID=8856;
You can contact us at support@americanretailsupply.com and we will be happy to look at it briefly.
Hope this helps.
-Suren
Share
Report
All responses (
Answers (
