Lightspeed Analytics Report to show Multi Store Sales and Inventory
I am looking to create a daily report to allow us to balance inventory between two shops. One shop is temporarily closed so we are using it like a "Warehouse" and want to move inventory from it to the "Main" store as items sell through at the main store.
The columns I would like to see are
Description and quantity sold of items sold at main store
Current On Hand for the Main store and the Warehouse store.
So far, I can get a report that shows everything for the Main store, but I cannot figure out how to get a column showing the inventory at the Warehouse for each item in the sold at the Main store.
Any insights or tips are welcome.
BTW - currently I am doing this in two reports and then using Excel to combine them. My hope is to have Analytics do the work and email out the single report daily.