web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Physical Inventory count - expected quantities all zero

(0) ShareShare
ReportReport
Posted on by 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)
  • Community Member Profile Picture
    on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans