Obviously this can be done very easily manually, but I cant figure out how to script it and I am wondering if anyone has an idea I can borrow from shamelessly.

I am trying to automate a script that shows receivables on open orders/invoices for balances open 0-30 days, 31 - 60 days 61 through 90 days and 90+.

My main problem is I can't figure out how to do a "range" find in a script.

Any help would be greatly appreciated.

Thanks,

Steve

Hi, Baylah! Look attachment. I will be glad if i understand you!

Ranges.zip

... why not just enter the text "0...30" for zero to thirty days... or if its 90+... just do a search for "0...90" and omit recrods...

Thanks for this....I did not know you could use "set field" in a find statement like this. Thank you, that makes it pretty easy.

Steve