Skip to Content
Jul 09, 2020 at 03:06 PM

Query for Inventory Changes in a timeframe


I am trying to construct a query which will return all items which have had their stock (on hand quantity) change in a given timeframe (on a per-warehouse basis). So, for instance, getting all items that have had the on hand amount change in the last 5 minutes.

The OITW table doesn't have any column which tracks this. I was wondering if there would be a way to query this easily? Or set up something to allow me to track this.