Sage 100

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…

This may be better accomplished by a crystal report, but I don't have access to create those. I'm looking to calculate the final GP Margin on a job including credits which are often $0 to the customer with negative costs of goods so they greatly improve…