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…

Is there a way to customize Item memo so if certain customers order that item a pop up will show up on the sales order. Possible by customer number or country code. We have some items that can not be sold in certain countries.

Would someone be able to tell how I would go about setting up a way to track lost sales? We are using Sage 100 Advanced ERP, Version 5.00.1.0...