Thank you for the response and the code...I ran it on our test server and it seems to work great! It only takes a few seconds to complete and seems...

I noticed that as well and for some reason was having touble incorporating the Product_Master table last night(fatigue I think) so was handling that with a formula field in the...

Thanks to both of you for replying to my posts, I was able to get the exact results I wanted as a view in a much more readable and manageable...

I have not had a chance to try the suggested code yet, I have been also participating in a webinar at the same time, however I am eager to try...

To hopefully clarify the logic...if there products in the Bins table then they will always be in Lots (but not vice versa), all of our inventory is lot based so...

Thank you guys for the quick response and the ideas here are similar to what I've been testing out but one of the problems I have is that the UOM's...