My product’s Movement History shows a different quantity than the Historical Inventory report!

View the inFlow Cloud version of this article

These two reports aren’t meant to be compared because they generate data based on different dates:

  • The Historical Inventory report relies on the quantity owned, which goes by the shipped date if shipping is turned on, or by invoice date if shipping is turned off on a sales order.
  • The Movement History tab (or report) relies on quantity on hand, which is determined by the pick date on a sales order.

On older versions of inFlow On-Premise, where pick date is not available, a product’s Movement History goes by the order date instead.

In other words, the Historical Inventory report records that a product is removed from inventory on the shipped or invoiced date, while the Movement History records that the product is removed from inventory on the picked date.

With this in mind, it’s important to remember that the data you see in both reports is still accurate – but you may see a difference in the quantity displayed if your sales order shipped/invoice date is different than the order date.

How to check if the sales order shipped/invoice date is different than the pick date

If you have shipping turned off:

You can toggle between Order Date and Invoice Date on a sales order by clicking the small black arrow next to the field dropdown, like in the screenshot below:

If you have shipping turned on:

If shipping is turned on, the Historical Inventory report will go by the product’s shipped date. You can check when a product was shipped by clicking into the Ship tab and selecting Shipping Details:

If the shipped/invoice date is different than the order date, you will see a difference in your product quantity when looking at the Movement History vs the Historical Inventory report.

Rememberboth reports are accurate, but the quantities are being calculated differently in each!

danielakrapivnik
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
July 18, 2018

Rate this article

Not enough ratings yet
1 star2 stars3 stars4 stars5 stars
Loading...
  • Did this article help? If not, please let us know so we can improve it.

  • This field is for validation purposes and should be left unchanged.