I’m stumped. I am try to query Inventory Transfer transactions. I need to filter by the transferlocation, but it doesn’t appear to be on the transaction table or the transactionLine table. Is there a join I’m missing? Anyone have thoughts?

Hi, You have inventorylocation on the transactionline table It shows two lines per item line. The one with a positive quantity is the "to location", and the one with the negative quantity is the "from location"