Skip to main content
Question

Is there a database link between two related/opposite inventory transactions?

  • January 14, 2025
  • 0 replies
  • 25 views

Forum|alt.badge.img+1

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

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings