Hey there @Tracy29615,

Let me join in on the discussion, to run a report that shows the desired information, we can look for a detail type of report as this can't be achieved through a summary or transaction list of reports. Since the information you are looking for are the detail line items. 

We may not also have those detailed report that separates each Lot Number and Sites. But, we can run a report with this information and Export this in Excel. From Excel we can also insert a Pivot Table. That will be the best way to customize detailed report and have the tables needed.

Run a report Custom Transaction Detail. Customize the report and add the Lot Number and Site Inventory. Then export it to Excel.

I will also submit this to our engineers as it would benefit a lot to customer that have multiple site inventory sorting and separated by Lot Number or Vice Versa.

Let us know if there's anything else we can be of service. 
​​​​​