Bulk Pool ID Update

Bulk Pool ID Update

Bulk Pool ID Update

There are various situations in which updating the Pool ID will allow you to process updates in Bulk through the Tasks > Bulk Contract Processing function in ASPIRE.  The Pool ID can be used to select the contracts for update. 

Examples of Bulk Processes include:

·         Move contracts between Finance Companies

·         Move contracts between ADC codes

·         Updating a Remit to Location

·         Bulk Pool Funding

To change the Pool ID for contracts to be updated: 

Go to a Contract Level Work Queue that contains all of the contracts to update.  Ensure the Pool ID is a field in the work queue and clear any filters that may conflict with the update or set filters that will help improve the selection process.

1.      Click on the Contract Bulk Update Export (Note, your cursor should be sitting within the work queue grid)

2.      An Excel file is exported and displays on screen.  Update the pool ID for those contracts that are to be updated using the Bulk Process.  Ensure you select a unique Pool ID for this process.  The Pool ID will be used as the trigger for the Bulk Process Change

3.      If there are other Pool IDs in use, understand that this process may over write the pool ID, so be foresighted with the process.

4.      Save a copy of the updated excel file for your records and name it as backup and save another version with only the original sheet (AspireContractImport.imp).

      5.      Within the same work queue, click on the Contract Bulk Update Import


      6.      A new popup will appear, select the file path input box and select “(AspireContractImport.imp)” file and press the import button


      7.      Refresh the work queue and validate results.


    • Related Articles

    • Bulk Contract Update - Processing Bulk Contract Sales

      The attached document outlines the steps to process existing or new Bank Funding and Discount Pools The purpose of the document is to provide an overview of processing a bulk Contract Sales procedure. ASPIRE has tools available to automate this ...

    • Bulk Processing of Payment Extensions

      See attached document for details. In response to the increased number of borrower payment deferment requests, LTi has developed an add-on utility that allows bulk modifying multiple contracts for payment extensions.

    • Bulk Asset Processing - Tax Depreciation Code Update

      To address potential issues that could arise from attempting to update Tax Depreciation codes from the Global Equipment Update from Equipment Work Queues, we have developed a new tool to specifically handle this process. Things to note: - Global ...

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

    • How to utilize the Global Equipment Update Module

      The Global Equipment Update Module launches from the Contract Explorer > Equipment screen, and creates an Excel spreadsheet of the existing equipment line-items and details. It allows a user to edit data and import it back into ASPIRE for the same ...