Inquiring on transactions

Amount

Shows the amount in either base or transaction currency.

• If the amount is in base currency but the transaction is in non-base currency,then an asterisk displays next to the amount.

• If the amount displays in transaction currency, report one, or report two currency, then the currency code displays next to the amount.

  Note: Use the Filter subform to display amounts in the currency of your choice.

Use these guidelines to specify the field values:

Enable Filter

Select yes in this field to enable the filters. Your selections are applied to the display only if the filter is enabled.

Currency

• Select T (Transaction) in this field to display amount in transaction currency, with the currency code next to the amount.

• Select A (Accounts) in this field to display transactions in account currency.

• Select 1 (One) to display amounts in report currency one

• Select 2 (Two) to display amounts in report currency two.

  The default setting is B (Base), which displays transactions in base currency, with an asterisk next to any non-base currency transactions.

System

Select a system code in this field to display only transactions originated in the application represented by the system code. For example, if you select AM, then you will display only Asset Management transactions.

Transaction Currency

Select a transaction currency code in this field to display only transactions entered in that currency.

Source Code

Select a source code in this field to display only transactions assigned that source code. For example, if you select AA, then you will display only Asset Management addition transactions.

Originating Company / Activity / Journal Book / Reference / Amount Range / Negative Adjustment

You can also limit the display to an originating company, an activity, a journal book, a reference, and an amount range. You can also include negative adjustment transactions in the display.

Type

This field lets you select the type of transactions included. If you leave this field blank, then Amount becomes the default value.

Status

This field lets you select the type of transaction statuses included. The default setting is All. You can select Unreleased, Released, or History transactions.

Posting Dates

(From) You can choose a posting date range to filter records. Specify the beginning date. Using the posting date range will pick up transactions within the date range that also fall within the period range you specified on GL90.

Note: If the posting date range is beyond the year and periods entered on GL90, then only the transactions within the year and periods meeting the posting date range requirements display.

(To) You can choose a posting date range to filter records. Specify the end date.

Automatic Reverse

This field displays if the journal entry is defined as auto reverse. If the journal entry was auto reversed, then an opposite entry for the transaction was created in the next period.