Viewing Ledger Information

Unit

Select the business unit for which you want to return ledger data.

Ledger

Commitment control and summary ledgers are not available for ledger inquiry.

Show YTD Balance (show year-to-date balance)

Select this check box and the inquiry returns year-to-date balances for specified ChartFields for a period. For example, results are summed in order by account for the periods which appears in the numerical order of the account.

Do not select this check box and the inquiry returns individual balances for period and account that are displayed in order by period.

This field is not available if the selected Ledger in the ledger criteria uses the Average Daily Balance ledger template.

Show Transaction Details

Select to see the ledger data along with the journal transactions that contributed to the balance.

For example, if you select this check box and select all ChartFields in the Sum By check boxes, the inquiry returns a list of all journals that contribute to the ledger lines.

Include Closing Adjustments

Select this option to include closing balances (period 999) along with the current open period amounts.

Only in Base Currency

Select this option if you want the inquiry amounts to appear only in the base currency indicated for the selected business unit.

Max Ledger Rows (maximum ledger rows)

You can override the default of 100 with any number <=300 rows of data that you can display in a scroll area. Less than 300 usually contributes to better performance.

Search

Click to display either the Ledger Summary page or Transaction Detail page, when the Show Transaction Details check box is selected.

Clear

Select to clear the ledger and ChartField criteria from the page to enter different criteria.

Delete

Deletes the inquiry, cancels the page, and returns you to a blank Ledger Inquiry - Ledger Inquiry Criteria page.

ChartField

Select a ChartField value for one or more ChartFields to review specific data in a ledger.

ChartField Value Set

Select a predefined set of selection criteria for a given ChartField.

Update/New

Click this link to update an existing ChartField value set or create a new ChartField value set.

Sum By

You are required to select at least one ChartField to sum by and if you do not, you receive an error message when you click the Search button.

Period is always included in the sum by and is always the first column in the inquiry results. The order in which the ChartFields appear on the inquiry results is determined by the order in which you select the Sum By check boxes for the ChartFields.

If you select all ChartFields available in the ChartField Criteria for Sum By and the Show Transaction Details check box is not checked, the result is a display of each row in the ledger that meets your criteria for business unit, ledger, fiscal year, accounting period, currency, and statistics code.

Value Required

Select this check box to filter out ChartFields with blank values.

This check box is available only when the Sum By check box is selected.

It is also unavailable for selection but is automatically selected by the system if the ChartField Account has Sum By selected.

Order By

Determine the sort order of the ChartFields in the result page by the order in which you select Sum By for each ChartField.

Sel (select)

Select specific adjustment periods by selecting its check box from the list of adjustment periods that are available based on the selected Ledger and Fiscal Year. Only adjustment periods that are applicable to the fiscal year are available.

Period

Adjustment periods are displayed based on those available for the selected ledger and fiscal year. For example, depending on the periods set up for the fiscal year, there might be 901 through 912 or if set up, 913. You can also use the common adjustment period 998.