Inventory Quantity sold and Profit margin by Category

1

I created a custom field and applied it to inventory items to categorize my inventory based on the products of my suppliers. I have different suppliers with many inventories, but in order to group their products that’s why i use a custom field to categorize them. see image below

image
image1162×817 48.4 KB

Currently, I need a certain report to see inventory item, quantity sold, and profit by category. I know that manager is doesn’t have such report to see by category but it this possible to use Advanced Queries or custome report?

2

Hello @Najrash,

Unfortunately, that would require either Inventory Item - Lines tab or Inventory Custom Fields to be exposed on Transactions tab, both of which are not yet available.

Your only option is to create this report in a spreadsheet based on Inventory Profit Margin report and Inventory Items tab.