Searching for financial transactions
Menu path
Modules ?
Financial ? Reports
? Search ? Search
Introduction
On this page, you can search and view the list of financial transactions that are grouped by the selected general ledger account(s). Based on the criteria that you have chosen, the results of the financial transactions can be filtered and displayed by the division, period, reference numbers, and many more.
Roles and rights
To search and view the list of financial transactions,
function right 135 — View ledger on screen is required. By default, users with the General manager or Controller role have this function right.
Note:
- For more details on function rights, go to Modules ? System ? Setup ? Security ? Function
rights.
- For more details on roles, go to Modules ? System ? Setup ? Security ? Roles.
What version are you using?
The information in this document is applicable to product
update 262 and higher. If you have versions lower than this, certain features
explained here will not be applicable.
How do I search for financial transactions?
- On the Financial: Search page, define the search criteria.
- Click Show.
How do I reset the search criteria?
- On the Financial: Search page, click Reset.
How do I view the total number of transactions?
- On the Financial: Search page, define the search criteria.
- Click Count.
How do I set the search criteria to the default settings?
- On the Financial: Search page, click Default.
Buttons
Close
Click this to exit.
Show
Click this to display the results based on the defined criteria.
Note:
- Once you have clicked this, the name of the button will change to Search.
- Once you have clicked this, the Reset, Count, and Default buttons will not be available.
- Once the search results are displayed, the
Expanded, 
Compressed, and 
Column icons will be available next to the Page size field for you to select the display views for the search results.
Reset
Click this to clear the defined criteria.
Count
Click this to display the total number of results based on the defined criteria.
Default
Click this to set the search criteria to the default settings.
Icon
Customise
Click Customise at the title bar to customize the fields, columns, or sections. You can add or
remove existing criteria based on your preferences by selecting or clearing the relevant check boxes. You can also specify the columns to be shown at the
results section as well as the order of the columns. Click Save to save the settings, Default to set back to default settings, or Close
to exit. Take note for the following sections or fields:
Columns section
You can add or remove columns based on the information you want to view. You can arrange the order of the columns by clicking the Up or Down buttons. There are various columns that you can select, such as Account, Cost centre: Code, Division: Description, Free field 1, and Item: Code.
Totals section
You can add or remove the following columns:
- Amount
- Amount - Division
- Quantity
Division section
You can define the relevant information on the division, such as the country, continent, region, and many more under this section.
Cost centre / Cost unit section
You can define the relevant information on the cost center or cost unit under this section.
G/L section
You can define the relevant information such as the corporate or division general ledger accounts, and general ledger account categories under this section. You can also define the type and subtype of the general ledger account.
Item section
You can define the relevant information on the items such as assortments and the serial number under this section.
Account section
You can define the relevant information on the account such as the type, sector, classification, and many more under this section.
References section
You can define the relevant information on references such as the order number and payment reference under this section.
Other section
You can define the relevant information on the project under this section.
Type / Origin section
You can define the relevant information such as the transaction type, subtype and the origin in this section.
Free fields section
You can define five types of free fields under this section.
Created section
You can define the relevant information such as the creator and date under this section.
Fields
Division section
Division
Type or select a division code to display transactions linked to the division.
G/L section
G/L (Corporate)
Type or select a corporate general ledger account number or the range of corporate general ledger account numbers to display financial transactions linked to the general ledger accounts.For more information, see Creating and modifying corporate general ledger accounts.
G/L (Division)
Type or select a division general ledger account number or the range of division general ledger account numbers to display financial transactions linked to the general ledger accounts. For more information, see Creating and modifying division general ledger accounts.
Account section
Account
Select the account linked to the financial transactions.
Date section
Year: From, Year: To
Select a year or the range of years linked to the financial transactions.
Period: From, Period: To
Type a period or the range of periods linked to the financial transactions.
Range
Select Date or Reporting date and type or select a date or the range of dates to display the financial transactions accordingly.
References section
Our ref.
Type the our reference number linked to the financial transactions.
Your ref.
Type the debtor/creditor reference number to filter and display the reference numbers that start with, contain, or equal to a certain letter or number.
Note: Click the icon to switch between the required filters, which are starts with, contains or equal to.
Entry no.
Type the entry number linked to the financial transactions.
Other section
Person
Type or select the person linked to the financial transactions.
Amount in DC (EUR) section
Debit / Credit
Select this to display only the debited or credited financial transactions or both. You can select one of the following options to display a specific search amount:
- = — Equal to
- <> — Not equal to
- > — Greater than
- >= — Greater than or equal to
- < — Less than
- <= — Less than or equal to
- between
- not between
View section
Sort by
Select one of the following options to group and display the search results:
- None
- Date
- Entry no.
- Our ref.
- Your ref.
Columns section
The columns displayed are the groupings that you will see when you click Show.
Templates section
You can save your search criteria as a template. For more information, see Creating and modifying search templates.
Related documents
| Main Category: |
Support Product Know How |
Document Type: |
Online help main |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
15.509.938 |
| Assortment: |
Exact Synergy Enterprise
|
Date: |
16-11-2018 |
| Release: |
|
Attachment: |
|
| Disclaimer |