I am trying to make a custom report in Business Insights Explorer that shows:

Item Code

Item Description

Product Line

Quantity on Sales Order

Total Quantity on Hand

But I cannot link a "Qty. on Sales Order" column to the rest of the report.
It seems I cannot link columns from the Sales module to the Items module.

Is there a way to do this?

I am just trying to compare what our daily production / warehouse needs are compared to what we have in our warehouse. 

We are a small family company, and a report like this would help so much! 

Thank you!