AnsweredAssumed Answered

rental inventory control calculation

Question asked by ericjlindholm on Apr 15, 2012
Latest reply on Oct 13, 2012 by bnmohr

Title

rental inventory control calculation

Post

I am reposting this thread to bring it back to the top of the list.  I appologize for not following through when you are helping me. Rental Inventory Script Help  this ia link to our previous conversation.    Regarding phils lasts comment, you are correct.  That is how my table relationship is set up.  

 

I set up a manual checker that compares the start and end dates for an equipment list and lists all the line items with the same ID in that date range.  It works well.  Im sure i could loop the script to search for all conflicts but having a quanitiy available calculation in the inventory table would be ideal.  Thank you!

Outcomes