also sounds like a good candidate for a map/reduce...
# suitescript
a
also sounds like a good candidate for a map/reduce script, if you aren't using one already