I am trying to create a sales report for one subsidiary showing all invoiced items with gross margin from cost of good sold. I understand that this can be done with a sales order search, joining the revenue amounts from the invoice and the COGS amount from the item fulfillment. This is working ok.

The issue I now have is the currency used in the amount fields. I understand that the currency of the amounts are determined by the subsidiary permission of the user role. So if the user role has permission to all subsidiaries (like administrator) the values are shown in the currency of the parent company, if they have only the permission for the one subsidiary amounts are shown in the currency of the subsidiary, if the user has permission for some but not all subsidiaries it is again a bit different.