Filter

Select the required option to filter the financial transactions that starts with or contains a certain text/number.

Range

Select Date, Fulfillment date, or Reporting date to display the financial transactions accordingly.

Date

Type or select a date or range of dates linked to the financial transactions. Select the All check box to search for financial transactions linked to all dates.

GL account

Type or select a GL account or range of GL accounts linked to the financial transactions. Select the All check box to search for all financial transactions.

Journal

Type or select a journal linked to the financial transactions. Select the All check box to search for financial transactions linked to all journals.

Entry number

Type the entry number linked to the financial transactions. Select the All check box to search for financial transactions linked to all entry numbers.

Cost center

Type or select a cost center or range of cost centers linked to the financial transactions. Select the All check box to search for financial transactions linked to all cost centers.

Cost unit

Type or select a cost unit or range of cost units linked to the financial transactions. Select the All check box to search for financial transactions linked to all cost units.

Geographical/ Strategic/ Operational/ Management

Select one of the subcategories.

Note: This is available only if you have defined the cost center categories and subcategories at System ➔ Finance ➔ Cost centers/units ➔ Categories. You can define up to four cost center categories and name them accordingly.

Account

Type or select a creditor or debtor account linked to the financial transactions. Select the All check box to search for financial transactions linked to all creditor or debtor accounts.

Our ref.

Type a full or partial Our ref. linked to the financial transactions.

Note: The Filter starts with or contains is applicable to this criterion.

External number

Type a full or partial External number linked to the financial transactions.

Note: The Filter starts with or contains is applicable to this criterion.

Your reference

Type a full or partial Your ref. linked to the financial transactions.

Note: The Filter starts with or contains is applicable to this criterion.

SO no. / PO no.

Type a full or partial sales or purchase order number linked to the financial transactions.

Note: The Filter starts with or contains is applicable to this criterion.

Description

Type a full or partial description of the financial transactions.

Note: The Filter starts with or contains is applicable to this criterion.

Selection code

Type or select a selection code linked to the financial transactions.

Type

Select one of the following options to display the financial transactions accordingly:

• All
• Standard
• Void
• Opening balance
• Correction
• Fiscal

Subtype

Select one of the following subtypes to display the financial transactions accordingly:

• All
• Sales invoice
• Sales credit note
• Purchase credit note
• Payment
• Cash receipt
• Fulfillment
• Returns: fulfillment
• Receipt
• Returns: receipts
• Counts
• Payroll
• Revaluation
• Disposal
• Other
• Reversal entry

Currency amount

Select one of the following options to display the search amount accordingly:

• Default currency
• Foreign currency
• Both

Currency

Select a foreign currency to display the search amount accordingly. This is enabled only when Foreign currency is selected at Currency amount. However, if you do not select a foreign currency code, then transactions in both the default and foreign currencies will be displayed. 

Note: You can only select active currencies. For more information, see Creating and maintaining currencies.

Amount

Select one of the following options to display the search amount accordingly:

• All
• equal to
• not equal to
• less than
• less than or equal to
• greater than
• greater than or equal to
• between
• not between

Note: When any of the options is selected except All, one or two boxes for entering the required search amount are displayed.

When searching for transactions, Currency amount, Currency, and Amount are used together to search for transactions in the relevant currency with the relevant amount.   

Note: It is possible that not all columns in this example are displayed. You can add or delete columns as required. For more information, see Inserting and deleting columns.

Refresh

Click this to refresh the displayed financial transactions. You will see all financial transactions that match the newly defined criteria.

Change

Click this to modify or update the selected entry. For more information, see Modifying transaction details.

Invoice

Click this to retrieve and view the processed sales invoice. This option is only enabled when the entry has been created at Invoice ➔ Entries ➔ Invoices. For more information, see Creating and maintaining sales invoices.

Our ref.

Click this to display the detailed financial transactions of the selected general ledger account.

Your ref.

Click this to display the detailed financial transactions of the selected general ledger account.

Entry

Click this to display the detailed financial transactions of the selected general ledger account.

G/L

Click this to display the detailed financial transactions of the selected general ledger account. The displayed financial transactions are grouped by general ledger code. For more information, see Viewing G/L cards.

Debtor

Click this to view the Debtor card of the selected general ledger account. For more information, see Viewing debtor cards.

Creditor

Click this to view the Creditor card of the selected general ledger account. For more information, see Viewing creditor cards.

Export

Click this to export all financial transactions within the defined criteria to Microsoft Excel.

Clear

If you want to start a new search, click Clear to clear the defined criteria.

Print

Click this to print general ledger transactions within the defined criteria.

Close

Click this to exit.