I've been working on some changes to our Open Orders by Item report in Sage 100. I would like to print this report, and have it indicate the quantity on hand in addition to the items on open orders to better help show when product is available to fill on open orders.
I was trying to add the IM_ItemStockStatusWrk data base in Crystal reports, but can't figure out how to get the databases linked with SO_OpenOrdersByItemWrk to make it work. Is this possible? Can anyone help with how I can add the quantity of an item on hand in the Open Orders by Item report?
