If I run and Inventory detail report today to show Item, Location, Qty OH and Average Cost, I need to substract the July transactions to get as close as we can to the Inventory on the last day of June. • What will it be the easiest to do this?

I had a similar requirement where client wanted to see inventory levels at each previous end of year. This SA75940 was the basis of the search to do what you want.