Adding or Updating Accounts to the
Statement (Trigger) Table

Last Revised: February 4, 2013

The Statement Table screen can be used to view, add or delete accounts in a temporary database table for which you want to print current or delinquent summary statements.  Once you have saved the accounts on this screen, you can go to the Batch Menu to print the statements.

If you have just a few accounts for which you want the statements, you can enter them directly on this screen.  After saving the data, you can run Batch Current Statements or Batch Delinquent Summary Statements on the batch menu to generate a pdf file that you can print on your desktop printer. The statements will print in the order in which they were entered on the Statement Table screen.  However, if you re-query the accounts in this screen, they will be sorted by account number.

If you have already run the Create Delinquent Reminder/Notice Data process, batch menu no. 1033, you can view the accounts gathered in that process, and add or delete the accounts for which you want statements.

 

  1. From the Main Menu, select Update, then Statement Table.  The Statement Table screen will appear.

To create a new batch (group) of accounts in the trigger table, go to step 5.

To search for data that you previously entered in this screen or that was generated via the Create Delinquent Reminder/Notice Data process:

  1. Enter either the Request Seq. number from the Create Delinquent Reminder/Notice Data process or an Account Number, then press F8.  The screen will fill with data.

To begin adding accounts to the same batch,

  1. Click in one of the lines having the Batch Seq. number you want to add to, then click Add to Batch. A new line will appear, filled in with everything except the account number.
  1. Enter the account number.  Skip to step 7.

To begin adding accounts to a new batch (a new group of accounts to be printed separately from the other batches,

  1. From a blank Statement Table screen, press CTRL+Q
  2. Fill in the following information on the first row:
  1. To enter another account, press Tab or Enter.  A new line is entered, filled with the same information as the line you just filled in, with the exception of the account number.  Enter or change the information for the new account. For each account, you can change the Request Seq. number, Batch Seq. number, Status, and Account Number.
  2. To delete an account, change the request sequence or batch sequence number to a number that you will not be using for a real request sequence or batch.

Note: Pressing Shift+F6 () to delete the line will not work; the deletion will not be saved.

  1. When you have entered all the accounts you want, press F10 (Save) to save the data.
  2. For batches having a small number of accounts, you can print batch current or batch delinquent summary statements using the processes on the batch menu.

For batches having a large number of accounts, you will need to create a file to send to a printing company. To do this, you need run the Load Statement Accounts Table - Statement Table process on the batch menu.  After that is finished, run either the Create Data File for Delinquent Reminders/Notices, Delinquent Tax Reminders/Notices or the Create Data File for Current Statements process.