Hi @Nelson Yip  Not sure but hoping that the below report may help you. If NOT, we can come up with a new Generic Inquiry to fetch the details from Sales Orders.

Hi @Nelson Yip 

There is no out of the box report which gives the output you are expecting. But altering following report can give you the details you are looking for. 

-You can remove the item class grouping and sort the report based on margin% or Net Sales value.

Hope this helps, 

Regards,

Thanks, I used that report and exported out to Excel to sort it.

Would be easier to just do everything inside Acumatica.

Hi @Nelson Yip 

Noted your comment. Please post a request on our ‘Ideas’ page as well. Our Product management team can review the requirement and evaluate if it could be added on future product roadmap.

https://community.acumatica.com/ideas

Regards,