In ASPIRE version 5.18 we added the ability to enter contract ID(s) directly into the the parameter field instead of choosing a range. What some people may not realize is how easy it is to paste results from a work queue into the field. This affords the ability to run your trial balance using any selection criteria that can be created through a work queue. Simply export your work queue and use the concatenate formula in excel to create a list of contracts with commas, then paste the collection into the parameter field. The attached short video (no sound) demonstrates the process: Export the work queue, copy (or enter) the concatenate formula, autofill (or copy/paste) the formula to the rest of the column, copy new column and paste into the parameter field.

CLICK HERE for a quick 1 minute video demonstrating this.