Using Contracts from a Work Queue as Your Selection Criteria for a Trial Balance - Video

Using Contracts from a Work Queue as Your Selection Criteria for a Trial Balance - Video

Info
See attached video for a demonstration
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.


    • Related Articles

    • ASPIRE Training Video Inventory

      The following is a list of training videos available in this Knowledge Base. Be sure to browse the Category for additional information related to your topic. Account Management Build a New User This hour-long video shows the process of setting up and ...

    • Filter Work Queue by User Deal Access

      Question: How can you filter a work queue so that only their deals appear? Answer: In Work Queue setup, use the Filter Type “Logged In User Roles” and select the Role. This will look at the user and the role of the user logged in, and if that role is ...

    • Document Templates Training - Video

      Please see the attachments for detailed information, recording available from within the Vimeo weblink Two Attachments available + a link for the Recorded Training: 1. Detailed notes that accompany the Recording, titled "Document Templates ...

    • Automation and Contract Profiles Training

      Please see the attachments for detailed information, recording available from within the Vimeo weblink Three Attachments available + a link for the Recorded Training: 1. Detailed notes that accompany the Recording, titled "Detailed Notes - Automation ...

    • Bulk Generation of Documents for User Identified Contracts

      See the attached document for details. The attached document provides the ability to batch generate and email documents for a group of user identified contracts. It also allows generating and sending a reminder to that group to sign and return the ...