Reporting - Filter Inventory reports by Tracking
Please add ability to filter inventory reports by tracking codes, so you can see quality purchased and sold by tracking code.
Hi team, while not available in the Inventory reports directly you could run the Receivable or Payable Invoice Detail reports where you'll find your can group and filter by Item and Tracking which should help you get a picture of quantities purchased and sold by category 🙂
-
Daniell McCoy commented
That'd be great - we've clients that want to track products sold at different sites. As a workaround, I've setup a custom report for the Payable Invoice Detail report, export to Excel and then use a pivot table to extract the data we need to report on.
-
Naomi Aspin commented
To be able to filter by tracking category would be a huge advantage to one of my Clients as they have stock at more than one site and using this would assist them in know what stock is at each site. Also then being able to have the option to see the Location/Tracking Category on the specific Product Inventory Page would be a huge advantage.
-
Karen Gerrits commented
Please add ability to filter inventory reports by tracking codes, so you can see quality purchased and sold by tracking code.
-
Laura Rasmussen commented
It's wild that the tracking categories aren't included in inventory reports. The work around suggestion of using the receivable or payable details doesn't cut it, as it doesn't capture cash basis (spend/receive money) transactions and therefore isn't a complete picture of inventory.
-
Jennifer Tryggvason commented
The payable invoice detail reports as suggested above don't include anything entered as a spend money. So the reports would be incomplete or take considerably more data entry time to get entered in a way that can be reported.
-
Anita Geber commented
And also with the option of graphs
-
Kimberley Charles commented
Inventory Sales report - filtered by Channel.
So the existing report (Inventory Sales Summary) for tracked stock would be great if the Channel field was added to the filtering options. Then we could see sales per channel as well as by SKU.