Exact Globe+

Selecting/Searching transactions

Menu path

Finance > General ledger > Select > Search

Introduction

In Exact Globe+, you can search financial transactions. These consist of information on general ledger, accounts receivable or accounts payable transactions. You can use the filter to specify criteria for finding financial transactions.

What version are you using?

The information in this document is applicable to product update 407 and higher. If you have versions lower than this, certain features explained here will not be applicable.

How do I view financial transactions?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.

How do I export financial transactions to Microsoft Excel?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Export.

Keep in mind: Before you export a general ledger table, you must first activate the Print Spooler service to export journals to Microsoft Excel. Otherwise, you will get an error message.

How do I view the creditor card?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Creditor card.

How do I view the debtor card?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Debtor card.

How do I view the general ledger card?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click G/L.

How do I view the general journal entry?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Entry.

How do I view financial transactions of the customer?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Your ref..

How do I view my financial transactions?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Our ref..

How do I view the sales invoices?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Invoice.

How do I update the financial transaction?

1. In the Finance > General ledger > Select / Search screen, define the search criteria.
2. Click Refresh.
3. Select a financial transaction from the overview.
4. Click Change.

Fields

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 checkbox 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 checkbox to search for all financial transactions.

Journal

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

Entry number

Type the entry number linked to the financial transactions. Select the All checkbox 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 checkbox 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 checkbox 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 checkbox 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.

Buttons

Close

Click this to exit.

Print

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

Clear

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

Export

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

Note: Before you export a general ledger table, you must first activate the Print Spooler service to export journals to Microsoft Excel. Otherwise, you will get an error message. For more information, see You cannot use page setup properties in Excel if no printers were installed.

Creditor card

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

Debtor card

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

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.

Entry

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.

Our ref.

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

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.

Change

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

Refresh

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

Related documents

• Creating and maintaining currencies
• Creating and maintaining sales invoices
• Inserting and deleting columns
• Modifying transaction details
• Viewing creditor cards
• Viewing debtor cards
• Viewing G/L cards