Sort Accounts in Trigger Table

Last Revised: June 30, 2015

This process can be used to sort the accounts in  the trigger table by name, account number, or zip code. This is done by the request sequence number generated when the file was loaded to the trigger table.  Batch statements and notices can now be printed in this order.

To use Sort Trigger Table do the following:

  1. From the Main Menu, click on Products, then Batch Products.  The ACT 7 Batch Menu will appear.
  2. Click the Sort Accounts in Trigger Table  line, batch menu no. 1026.
  3. Press Enter. The parameter screen appears.
  4. Enter your ACT 7 Client ID.
  5. Enter the Request Sequence used when the file to sort was loaded to the trigger table.
  6. In the First Sort Order field, enter the criteria to use for the initial sort: N - owner name, A - account number, F- fiduciary number, C - appraisal district number, or Z - zip code.
  7. In the Second Sort Order field, enter the criteria to use for the secondary sort: N - owner name (for current year), A - account number, F- fiduciary number, C - appraisal district number, or Z - zip code. For ex., if First Sort Order is Z, and Second Sort Order is A, then the accounts are sorted by zip code and within each zip code they are sorted by account number.
  8. In the Account Per Batch field, enter the number of accounts per batch for printing purposes. Leave this field blank to group all of the accounts into one batch. This may be the same number you entered in batch menu no. 1033, Create Delinquent/Reminder Notice Data.
  9. Click Submit Job to start the report process.  
  10. Click OK on the "OK to Submit Job" pop-up screen.
  11. To preview and print a log  file, see Previewing and Printing Reports.  The log gives the total number of accounts in the file, the number of accounts rejected (if any), and the name of the file.
  12. You may now print statements in this order by entering the request sequence number from the trigger table in the Batch Request Sequence No. field.