Inventory Valuation by Month

in Development
I am finding it hard to believe there is no way to get an inventory valuation by category at a date in history. In the POS system that I just left to come to Lightspeed Retail, we were able to see the change in our inventory over a specified time period. In essence this helps with cash flow analysis and shows where our money has been invested into. Does anyone know of a way to get this information? And does anyone know if this is something Retail is working on?
1 comment
Although you posted this question in the OnSite API area, I assume you are referring to Lightspeed Retail? There is a historical canned report in there. Something like this --> https://us.merchantos.com/?name=reports.inventory.listings.assethistory&formname=listing&_sortdir=ASC&category=-1&season=-1&department=-1&asset_date=&item_search=&shop_id=-1&category_id=-1&tags=&neg_tags=&manufacturer=-1&vendor_id=-1.
I don't see categories defined as selection criteria, however. Not sure if the Lightspeed Analytics add-on provides this reporting ability. Perhaps it does. Frankly, I found for more sophisticated inventory and sales analysis most of these canned reports aren't enough. We export inventory and sales daily via the API into our own local SQL data tables. If we couldn't do that then running our business would come to a grinding halt.