We sell some items in metric units and some in cases.  I want to create a sales report showing all quantities in metric units.  In order to do that I obviously need the actual SO line UOM in order to determine if the item was sold in metric units or if it needs to be converted.  Problem is, I also want to include profit, and as far as I know the only table that has the fields needed to calculate profit is tsoSalesAnalysis.  From what I can tell, it's not possible to create a view that includes tsoSalesAnalysis and also a table that includes the actual SO line UOM (tsoSOLine).  Just running this by the community before I inform the user that the report cannot be created.

Thanks.