Hi,
In the reports section, the “inventory profit margin report” is there a way to deduct the sales invoices that were converted to credit notes (due to sales returns).
As currently the invoices that were (partially or fully) returned are also being shown in the “inventory profit margin report” which is somewhat misleading. Is there a workaround for this?
The content of built-in reports cannot be modified (except for parameters like date ranges that define the report). The Inventory Profit Margin report calculates profit margins on sales, not net sales. If you want the full picture, you need to derive it from drill-downs on the Inventory - sales and Inventory - cost accounts.