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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / "Unknown" t...
Microsoft Dynamics RMS (Archived)

"Unknown" transactions on ItemMovementReport

(0) ShareShare
ReportReport
Posted on by Mike McElhaney 345

Inventory is disappearing and re-appearing. The Item Movement History Report has a Type of  "Unknown." When I look at the InventoryTransferLog table, I see the Type=11 in the type field for the offending records. This is happening on multiple items, and seems to have started shortly after upgrading to the latest service pack.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I have a report from one of our data guys that he's seen this in a couple of instances. No clue where the Type=11 comes from but the behavior is same as what you're describing. Unfortunately we can tie it back to at least 2.0.0127 and prior so your suspicion of a recent update being the cause may not be the case.

  • Trent Bourgois Profile Picture
    Trent Bourgois on at

    Hello Mike,

    Thank you for your question.

    I have found that "unkown" item movements can be caused if a Worksheet 260 is used on an item that already exists at the store. If this worksheet is processed again for the same item at the store, it will automatically update the quantities at the store equal to the quantities in HQ. To prevent this from happening, please be sure that worksheet 260 is only used for sending new items down to your stores.

    If you need to update an item’s attributes, use a worksheet 250 while in maintenance mode.  

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at

    You need to download the new report from CustomerSource; https://mbs.microsoft.com/customersource/support/downloads/reportslibrary/rms/ModifiedReports/modifiedreports_rmsstoreoperationsreports.htm

    Report - Item Movement History with InventoryTransferLog.Type 11 Added
    The Item Movement History Report has been modified to accurately display results for records that have a value of "11" in the InventoryTransferLog table in the Type field. The InventoryTranferLog.Type of "11" signifies a quantity adjustment that was made as a result of processing a Style 260: Download Items worksheet. This new InventoryTransferLog.Type of "11" was added as part of the Microsoft Dynamics RMS Hotfix 1 (build 2.0.0106). (April 23rd, 2009)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans