Sage 100

1. Anybody know how to get SO Tracking Numbers into the Explorer Views? v2017 Adv. 2. I have some Sales Orders (in Explorer Sales Orders View) that will only show 1 item in the lower grid and in reality there are 3. I tried to 'Open Preview' on the order to bring the item to the upper grid and still just the 1 shows. I deleted the order and reentered and still didn't fix it. It has progressed to other orders too but yet some show all the items.

I couldn't do it in BIE, but was able to create an SI container with fields from AR_InvoiceHistoryHeader, AR_InvoiceHistoryTracking and AR_TrackingByItemHistory. Add parameters for Customer #, item # and/or Date Range... and it may be a workable solution. Else, create an Excel query to pull the info.