Have you wondered why some numbers in your Item Movement History report do not seem to jive with the numbers in the Item Quantity reports?   

The reason for this is that the reports were designed for different purposes; and we do not recommend using the Item Movement History report to track current inventory quantities. 

Some of the reasons for this include:

  • The Item Movement History report was designed to track an item's movement, not the item's current quantity.
  • If you run the Item Movement History report without any filters to view the current quantity, the report could take an abnormally long time to generate. This is because the report has to generate and load data for all the item movement that has occurred since the store was opened.
  • There is a default Item Quantity List report in Store Operations that will produce a more accurate representation of your item's current quantities.
  • The Item Movement History report does not consider items that are on hold, are in the Offline database, are on a Work Order, or on a Layaway.

There are also several things that can cause the Item Movement History report quantity totals to be inaccurate when you compare it to the quantity totals in the Item Quantity list report.

Some of these things include:

  • If you have ever updated an item's quantity with a third-party program, a record of the movement may not be recorded in the InventoryTransferLog table. Therefore, the totals in the Item Movement History report may not be accurate.
  • If you have ever updated an item's quantity with a SQL statement, a record of the movement will not be recorded in the InventoryTransferLog table. Therefore, the totals in the Item Movement History report may not be accurate.
  • There were some Product Defects in earlier versions of Microsoft Dynamics RMS that caused issues with records in the InventoryTransferLog table.
  • If Items were imported into the database with a quantity, the Item Movement History report will not account for this imported quantity because the Store Operations Import Utility does not record a record in the InventoryTransferLog table for the imported quantity.

Do not let this discourage you from using the Item Movement History Report for what its true purpose is, which is to track the various movement of your items. Movement types include the following:

  • Purchase Order receipts
  • Inventory Transfer In
  • Inventory Transfer Out
  • Transaction Return to the Offline database
  • Transaction Return to the Main database
  • Transfer to the Main database from the Offline database
  • Transfer to the Offline database from the Main database
  • Manual Adjustment
  • QuickAssist (Inventory Wizard Adjustments)
  • Physical Inventory Adjustment
  • Headquarters Adjustment
  • Parent Child Adjustment
  • Kit Component Transfer
  • Headquarters Manual Adjustment
  • Sales

I hope that the information in this blog will help you better understand the differences and purposes of the Item Movement History and Item Quantity List reports.

Have a great week!

Gregg Kosel
Microsoft Dynamics RMS/POS Technical Support Escalation Engineer