Inventory Movement History

Updated 2 months ago

Inventory Movement History Tutorial

All movement of inventory is logged in the Inventory Movement History, so you can view the movement status of a product and reconcile its physical and aggregate quantities. Inventory Movement is defined as any transaction that adds or subtracts from the inventory quantity such as shipped orders or received purchase orders. The following image shows a list of movement types: 

Important Note: as of May 8, 2014, FBA orders are no longer logged in the Inventory Movement grid. Since we get FBA inventory Reports, we track inventory that way instead tracking it through the movement log. This change was also made to prevent errors that can result from cross referencing by the two inventory sources - the log and the FBA report.

Navigate Product > Toolbox >  Inventory Movement. From the product detail page, click on the View Movement link located next to the physical and aggregate quantities.

Use the Search Filters to

  • search for movement in a selected warehouse
  • search by movement type
  • search movement within a date range.
  • If the product is a shadow, select from the Product ID filter to view movement of either the shadow or the parent products.  

The Grid details the movement of the inventory

Information in the grid includes: 

  • the SKU
  • the date of the action
  • the vendor
  • the sales channel and the company at which movement occurred
  • the details of the change in quantity
  • the price and cost of the product at the time of the movement
  • an adjustment reason if the quantity was manually adjusted
  • the warehouse at which the movement occurred.

Clicking on the Detail ID link will open the related movement log, such as the order or purchase order. 

It's important to understand the difference between an "Order" and an "Order Reserve." An "Order" type refers to an order that was already shipped. The quantity change of the order type affects the physical quantity. The “Order Reserve” type refers to an unshipped order, and its change only affects the available quantity. (see below on calculating physical and available quantities)

As orders come into the system they are marked with a status of “Order Reserve” with the date of the order placement. As soon as they are marked as shipped, their movement type will change to “Order” and the physical inventory will be updated. The date will then change to the date of the shipping.

Understanding how movement is calculated.

There are two basic categories of changes in inventory: 

  • Changes to to the Physical quantity
  • Changes to the Available quantity. 

The inventory quantity is always calculated from the quantity that was set on the date of the last physical inventory count. The date of the last physical in each warehouse can be displayed by hovering over the last physical inventory quantity. (Reference Image Above)

  • Total Inventory Change refers to the sum change of the physical inventory based on movement that has occurred since the last physical. If the only movement of physical quantity since the last physical was 2 orders, the total inventory change will be 2.
  • Calculated Inventory is the sum of the last physical quantity and the inventory change. This gives you the current physical quantity.
  • Reserved  is the sum of all inventory that has been reserved to fill orders that have not yet been shipped 
  • Not Sellable refers to inventory that cannot be sold. For example, inventory that is stored in an unsellable warehouse.
  • Calculated Available Inventory takes into account the combined reserved and unsellable quantities of the calculated physical  inventory to give you the number of available units. Typically, the calculated available units are sellable and the available quantity will equal the aggregate available quantity.

When viewing a kit with a Main Component inventory dependancy, the movement history will be directed to the movement history of the main component. If the kit is dependent on All Components, then the movement will be directed to the component with the lowest available inventory.  

From the action menu  you can export the movement history to an excel file. Clicking on View Reserved Orders will open a grid on the Manage Orders page with all reserved orders.

To view all movement of the item from the time it was first entered into the system, click View All Movement. In this view you'll also see the name of the user or customer who executed or initiated the movement.

When dropshipping, you may not want the inventory to be included in the calculations. When you edit a vendor, select Dropship Preferences from the Toolbox and enabled  Do Not count Inventory for DropShip PO. 

If you don't see a particular PO in the inventory movement history, you should check if this setting is enabled on the vendor.

How did we do?

Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter
Powered by HelpDocs (opens in a new tab)