Hello,

I have a table in my DB that tracks movement of inventory. There are many different transactions, but I need to target a couple of specific scenarios for a report:

1. Weighing inventory out of the warehouse (transaction 1) where a future transaction is receiving at dispatch bay (transaction 2).

2. Weighing inventory out of a second warehouse (transaction 1) where a future transaction is receiving at dispatch bay (transaction 2).

Is it possible to build a report to only look at these scenarios? In addition to these transactions in the table, I have others such as receipt into warehouse, movement between warehouses etc. that I want to completely ignore.

Each transaction has a different ID number.

Any assistance that can be provided would be very much appreciated.

Kind Regards,

John