Did anyone get this to work ? I am trying but same is happening

Here is the GI If I do the left join and count on the artran I still only get Sales on Inventory items. what data field on the artran should I be sel...

I got this figured out...thanks

How can I make this be a Filter on the front end of the GI instead of hard coded in the Result Grid I want the end user to be able to filter by date...

This is the end results but I need to have a date filter by either ARTrans or Shipment Date.

The "Inventory Status Original" is what they started with - it is linking the site id. The "MS-Inventory status test" is the one I reworked to remove...

So I have two warehouses one location is IIT (in transit) the qty is in the Qty Not available, because one WH has a 0 in "qty not available" and the o...