We recently pushed out a new report, called "Incremental Changes Report v1", and we wanted to take some time to give you a bit more information about this one, as well as to give you a peek behind the curtain at some of our plans around reporting over the coming months.
The report is designed to give you granular detail on changes to the availability of items in the warehouse. One of the main drivers was to support integrations that need to keep inventory in sync with the warehouse, but aren't able to use event subscriptions.
If you're familiar with the Incremental Changes event subscription then this report will look familiar to you - it's designed to show the same level of detail. It'll show you every positive and negative change to availability for each item, on a per-warehouse basis, along with the reason for that change (e.g. SO allocation, manual adjustments, etc.).
You can use the report as a base for higher-level summary views as well if you want; for example if you group the Item Code by value and sum across the Quantity changed, you can see the net change in availability for an item over that time period.
The report does look at a detailed set of historical data, so you'll get the best performance by choosing an appropriate time period that you want it to report across. By default, it'll show you all changes for the past 24 hours.
We know from past experience that everyone wants something slightly different from each report, so we've made sure to expose as many of the standard item properties as we can. If you want to search / group / filter on any custom data that you're holding in the item attributes you've got the tools to do that.
Going forwards, we're definitely interested in exploring alternative ways to expose data like this to you, and we're keen to find ways to let you manipulate and build upon that data without having to log feature requests for each change. We're prototyping some ideas over the coming months with an aim to build a solid foundation first, and then once we've got a stable, performant framework in place, we'll be looking to build it out with features to make that sort of thing easier.
We don't know exactly what that will look like at the moment; we've already had a wide range of feedback, with some Clients looking for direct access to our database, and others looking for a much simpler system that can just push out CSV files on a regular basis.
We're always open to feedback, so please feel free to reach out if you've got any suggestions for what you'd like to see around reporting in the future!