My report returns the follow data: Qty Needed and Qty Available in each location.  For one part I might have 4 lines showing the quantity in each location.  For another part only one line because it is only in one location, etc... My Qty Available is sorted by oldest receipt date.

 

I have to use the oldest inventory first.  So I am trying to figure out how to compare the first line Qty Available to the Qty Needed.  If there is enough inventory there then just print that line, suppressing the others.  If not then add Qty Available from line 1 to Qty Available from line 2 and compare that to Qty needed.  If that is enough then print lines 1 and 2. 

 

Thanks in advance,

Joel

 

Thanks again,

Joel