Hi,
Does anyone know where (or whether) a link is recorded between two related/opposite inventory transactions in the database? This is for reporting purposes on stock movements.
For example, if I move some stock from one location to another location, two transactions are created: an INVM-OUT transaction at the location the stock was moved from, and an INVM-IN transaction at the location it was moved to.
However, I’ve been unable to find anywhere in the database that actually links these two transaction IDs, making reporting difficult when I want to show both the From and To Locations for a single stock movement.
Is there a link between these transactions in the database? If so, I imagine this would be stored in a mapping table, but I haven’t been able to find one so far.
I’d appreciate any input anyone could provide.
Thanks!
Wilf