AnsweredAssumed Answered

Report that does inventory as of a date?

Question asked by donjuancarlos_1 on May 7, 2009
Latest reply on May 7, 2009 by donjuancarlos_1

Title

Report that does inventory as of a date?

Post

I have a database that tracks our inventory of steel coils.  I have another database that keeps track of inventory transactions to those coils.  When a part of the coil gets used, a user creates a transaction entry to show how much metal was used and when it was used.

 

I want to create a report that shows how much inventory I had at any given date.  This means I would somehow have to take the original weight of the steel coil and subtract only selected transactions from it.  Does anyone know how I might do this?  And how would I prompt a user for a date?

Outcomes