Introduction
Go to GL > Transaction Browser.
The Transactions Browser lets you:
View Transactions: View summarised details of all transactions and filter and sort them based on preselected criteria. These filters can then be saved. Datasets can also be exported to Excel.
Amend Transactions: Edit or Reverse a transaction. View allocations or un-allocate a transaction. View all changes to a transaction made by users.
Manage Documents: Reprint documents including invoices. Email documents including invoices.
The Transaction Browser does not include pre-posted transactions such as Orders, Deliveries, or Quotes which you can instead examine in their relevant grids.
See:
Creating General Ledger Journals
Managing General Ledger Accounts
Query Tools (GL Explorer, Transaction browser) (1.6) - AIQ Academy
Adjust the Layout and Customise the Grid
Adjust the layout:
- Screen-size: Hover over the edge you want to expand until a double-sided arrow appears. Click and drag until you reach the desired size. You can adjust column width in the same manner.
- Pagination: Select the number of records to display.
- Column Position: Drag and drop a column heading to the desired location.
Customise Grid:
- Go to Grid Options and select Customise Grid to open the column grid selector. This displays all other available columns not currently in use in the grid.
- To add a column, drag and drop the desired column to the required location. To remove a column from the Grid, drag its header away from the Grid and drop it.
- To save the grid view for re-use, select Save Grid Customisations. To restore the grid to its original layout, go to Grid Options > Reset Grid.
Simple Filtering
Simple Sorting and Filtering
- To sort a column, click on its header. This sorts the entire contents of the list in ascending order. Click again to sort the list in descending order.
- Filtering displays transactions for the last two years from today's date. The filter symbols (highlighted in red) can filter based on a particular condition. Using multiple filters can refine your search further.
- Enter search terms in the column header fields to refine even further.
Summarise Transactions
By default, the transaction browser shows the net, tax, and gross elements of a transaction as separate lines. Depending on the transaction type, all lines can be shown, or they can be grouped by control line, bank line, or first line.
Tick Summarise Transactions to view the principal transactions only, without the expanded list of General Ledger Postings. Uncheck to show all lines once again.
Advanced Filtering
Create Filter Condition:
- Click Clear Filter before creating a new compound filter condition. This will make transactions older than two years available for filtering.
- Click Create Filter Condition and create your desired condition.
- To add more conditions, click Save and add another, otherwise click Save.
Save and reuse filter conditions:
To save any number of filters for subsequent reuse:
- Click Save Filter.
- Enter a name for the filter and click on the checkmark.
- Reuse any saved filter later by searching for its name in the dropdown. To delete a saved filter, find it and click the red X, followed by OK.
Editing Transactions
Transaction Browser Screen
Description and Ext. Ref can be edited in the transaction browser.
- Click in the field to make the changes.
- To save any changes, click the Green Tick Symbol or to cancel, tick the Red X Symbol.
Transaction Details Screen
Drill down for further edits.
- Click any of the relevant blue links in the Transaction Browser to open transaction details or click Edit to open the Transaction Details screen.
- Click the pencil icon to make the desired edits. The edits that can be made depend on the status of the transaction; Posted, Unposted, Allocated, or Bank Reconciled. Under certain circumstances, you can also Reverse a transaction or Un-allocate it for further amendment.
- Click Process Edits.
See:
Managing Documents
The Transaction Browser lets you manage documents in the following ways:
- In the Action dropdown a selection of actions is available based on transaction type.
- Select Print for a range of printing options.
- Mark an invoice as Disputed by selecting Dispute from the Actions dropdown. Disputed invoices are highlighted with red flags in the Transaction Browser.
- Select Email to send sale documents.
- The Document Manager (paperclip symbol) lets you add scanned images or review previously attached images.
- Export your transactions or your chosen sub-set of transactions to Excel by clicking Export Transactions.
