I want to check the cost ratio and gross profit margin of Inventory Item in a report.
I would like to check the cost percentage and gross profit margin of an inventory item in a report.
The items are as follows
Cost of goods purchased, total cost (cost of goods purchased x quantity, cost ratio)
Gross profit amount (sales amount - total cost), gross profit margin
Is this possible?