Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

"Unknown" transactions on ItemMovementReport

Posted on by 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

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: "Unknown" transactions on ItemMovementReport

    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)

  • Re: "Unknown" transactions on ItemMovementReport

    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.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: "Unknown" transactions on ItemMovementReport

    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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans