Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

UNKNOWN inventory adjustment

Posted on by 990

When I look at the Item Movement Report in HQ, I sometimes see adjustments in the [Type] column with and entry of "Unknown."  Does anyone know what causes these Unknowns

*This post is locked for comments

  • Re: UNKNOWN inventory adjustment

    Hello Rick,

    Thank you for letting us know that the link on our reports library appears to be broken.

    The worksheet 260 should be used to send newly created items to a store from HQ. If you use Worksheet 260 on an item that already exists at the store, it will set the store's on hand quantity to match HQ's on hand quantity.

    For this reason, we do not reccomend using Worksheet 260 to edit item properties. To edit an item's properties, use Worksheet 250 in Maintenance Mode.

    Let us know if you have any other questions.

  • Rick McKeon Profile Picture
    Rick McKeon 990 on at
    Re: UNKNOWN inventory adjustment

    I do.  First, thanks.  Second, the report is not there.  I can see it listed when I drill through to the Reports Library for RMS, and can view the pdf, but the zip file location is invalid.  And finally, my understanding of a 260 is that it is the definition of an item.  How does a 260 change item  on-hand quantities?

  • Re: UNKNOWN inventory adjustment

    Hello Rick,

    Thank you for your questions.

    The InventoryTranferLog.Type of "11" signifies a quantity adjustment that was made as a result of processing a Style 260: Download Items worksheet.

    We have a report available on Customer Source that labels these movements as such:

    Report - Item Movement History Report with InventoryTransferLog.Type 11 Added

    https://mbs.microsoft.com/downloads/customer/Custom_-_Item_Movement_History_Report_with_New_Type_HQ.zip

    Let us know if you have any other questions.

  • Rick McKeon Profile Picture
    Rick McKeon 990 on at
    Re: UNKNOWN inventory adjustment

    They are all showing up with an 11 in the [Type] column of the InventoryTransferLog table.

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 Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans