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

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

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

    • 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 ...

    • 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 ...

    • Using Quantity and Splitting Assets

      See attached document for complete details. ASPIRE allows for asset-level management on any given contract and contracts that have a high number of assets can be cumbersome to service at times. The attached document outlines how to use the Equipment ...

    • 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 ...

    • Requirements of Combining Invoices

      Rather than creating 1 invoice per contract when a customer has more than 1 contract, there is the possibility of creating combined invoices. However, there are a few baseline requirements in order to combine as well as a few different ways that you ...