Search Transactions

The Search Transactions window provides sections where you can select filters to determine which transactions are placed in the list of transactions.

To use this function, select Utilities>Search Transactions.

See Search Transaction Options at the end of this topic for descriptions of the Search Transaction Options.

Customize the list of transactions as desired by removing or rearranging columns using Column Configuration. Multiple configurations can be set and saved—see Memorize Search later in this topic for more information about those options.

Change one or more of the criteria as follows and click Search to refresh the list of transactions based on the new criteria selected.

Get more detail on any transaction by double-clicking anywhere on the transaction row. This will bring up the transaction in the journal in which it was created. If the transaction is from a prior period, you will be able to view the entire transaction in the source journal but you will not be able to edit the transaction. If the transaction is within the current period, you will be able to edit any part of the transaction.

Date

• From—Enter the earliest date for transactions you want to locate. If you delete the date, then all transactions from the earliest recorded date will be displayed.
• To—Enter the latest date for transactions you want to locate. If you delete the date, then all transactions to the the last recorded date will be displayed.

Year & Period

• Entered or Effective—Select whether you want the Year and Period selection to apply to the year and period they were recorded (Entered) or the year and period they apply to (Effective), if they were made as adjustments to a prior period.
• Year—Select a year from the list to filter the transaction list to include only transactions within the selected year. Select All to not filter by year.
• Period—Select a period from the list to filter the transaction list to include only transactions within the selected period. Select All to not filter by period.

Account

Highlight the account or accounts that you want the transaction list to include. If no accounts are selected, the list will not be filtered by accounts. Use the Clear button to clear all selections.

Account Code

Use the Account Code field to enter wildcard characters for accounts. The following examples show how this can be done:

• 10* will display transactions posted to all accounts beginning with 10.
• *01 will display transactions posted to all accounts ending with 01.
• *01* will display transactions posted to all accounts where 01 is found anywhere within the account code.
• 10??01 will display transactions posted to all accounts that start with 10, end with 01 and have two characters between them.
• You can mix the * and ? wildcard characters.

Contact

Highlight the contact or contacts that you want the transaction list to include. If no contacts are selected the list will not be filtered by contacts. Use the Clear button to clear all selections. If you have a long list of contacts and want to get to one quickly without scrolling, double-click in the list box, then start typing the first few characters of the contact Lookup and the cursor will advance to the contact.

Org

Select an organization from the list to filter the contact list to include only contacts within the selected organization. Select All to not filter by organization.

Journal

Highlight the journal (window) or journals if you want the transaction list to include only transactions recorded in specified journals (windows). If no journals are selected, the list will not be filtered by journal.
Use the Clear button to clear all selections.

PR Item

This section will only be available if your program has been activated with payroll. Highlight the payroll item or items that you want the transaction list to include. If no payroll items are selected the list will not be filtered by payroll items. Use the Clear button to clear all selections. If you have a long list of items and want to get to one quickly without scrolling, double-click in the list box, then start typing the first few characters of the payroll item Lookup and the cursor will advance to the item.

Page Number

Use the Page Number field to enter wildcard characters for page numbers (check numbers, etc.). Use the same wildcard character rules as described above for Account Codes.

Batch Filter

Select the Year that you want to limit the Batch list to. Select All to show all batches in the drop-down list.

Batch

Select the Batch that you want the transaction search to include. Select All to not filter the search by batch.

Amount

Use Amount to search for an amount that is Equal to (=), Less than (<), Less than or Equal to (<=), Greater than (>), or Equal to or Greater than (=>) by selecting the appropriate sign and entering the desired number.

Search

Click Search to create a new query applying all criteria selections.

Reset All

Click Reset All to clear all criteria and restore to the initial settings.

Export

Click Export to export the results of the search as displayed in the grid. Select the desired format and enter or browse for the file path using the  button.

Print

Click Print to print the results of the search as displayed in the grid. Due to printer variations, column widths do not print the same as they look on the screen. Use Options>Print Offset to adjust for these differences..

Edit and View Modes

Click the Edit Mode button to put the Search Transaction results in Edit Mode. Clicking the Edit Mode button will perform this search, so it is unnecessary to select Search Transactions and then Edit Mode.

If your search criteria includes transactions outside of the current period, a dialogue box will open warning you that the year and period will be locked to restrict the results to the current year and current period. If transactions need to be edited in a prior period or future period, you will need to open those periods using Utilities>Process Prior Period or Process Future Period.

All editable columns will have a blue header. As soon as you change the data in an editable (blue) column, that transaction record is immediately changed in the database.

Memorize Search

Memorize Search allows you to memorize all setting for a search, including all criteria and the column settings in the results grid. Set up your search, give it a name, then click Save. To perform the search at a later time, highlight the name of the memorized search and click Restore.

Total (Total)

The total of all values in the Amount column will appear in the Total box at the bottom of the window if the Amount column is not hidden using Column Configuration.

Debit (Total)

The total of all values in the Debit column will appear in the Debit box at the bottom of the window if the Debit column is not hidden using Column Configuration.

Credit (Total)

The total of all values in the Credit column will appear in the Credit box at the bottom of the window if the Credit column is not hidden using Column Configuration.

Totals at the bottom of the window will be presented depending upon the columns selected in the grid.

Search Transactions Options

Click the options  icon on the Data Bar for Search Transactions Options.

• Print Offset—Due to printer variations, column widths do not print the same as they look on the screen. Use Options>Print Offset to adjust for these differences. Increase the number to increase the printed column width and decrease the number to decrease the width. Once this is set for your system, columns will print as they appear on your screen.
• Live Update
  • Yes—Items in the results grid will update automatically when the transaction is changed in another window or by another user.
  • No—Updates to transactions are not made until you click Search.
• Open with Search
  • Yes—The window will open with the default (current month) search.
  • No—The window will open with no search set. Setting this to No will make the window open much faster.
• Open with Range
  • Date—The window will open with a default date range for the current period; i.e., if the current period is 3 and the company's fiscal year end is December 31, then the default date will be From 03/01/20xx, To 03/31/20xx.
  • Year-Period—The window will open with the year and period set to the current year and current period.
• Combine Contact Lookup With Name
  • Yes—The Contact Lookup and Display Name will be separated by a hyphen in the Contact List.
  • No—The Contact Lookup and Display Name will be separated into two columns in the Contact List.