Field help (CRITBSE)

Use this fields to select additional criteria for a more refined query.

You can save these criteria by clicking Memo and assigning a Memo code. Click Recall and enter the Memo code to reload the same criteria. You can create multiple memo codes for different sets of criteria.

Selection block

Company: Enter a company or group of companies (mandatory).

Site: Enter a site for a single company. This field is not available for a group of companies.

Ledge type: Enter a ledger for the query. It can only be a general ledger.

Date ranges: Enter a date range to limit the query. The start date cannot be a peiord start and the end date must be a period end.

Carry forward: Select this check box to include carry-forward entries.
Beware of the rules for taking into account carry-forward entries.

Closing: Select this check box to include entries for the period close.
Beware of the rules for taking into account carry-forward entries Y/N, for the group of companies.

Off-balance-sheet: Select this check box to include entries for account not on the balance sheet.

Pyramid block

Account pyramid: Enter the account pyramid defined in the chart of accounts.

Detail: If you select this check box, the movement (normal and collective) accounts display. If not, movement accounts (normal and collective) are not included in the query.If you select this check box and the Multilevel check box, you also see all levels or the levels about any value entered in the Level field.This field is not available if a Controlaccount is entered.

Level: Select the group level you want to search for. If blank, all levels display in the query results.

Multilevel: If you select this check box and if you entered a Level, everything above that level displays. If you select this check box and the Detail check box, you see the movement accounts (normal and collective) in addition to the levels.If no level is entered, all levels display.This field is not available if a Control account is entered.

Include zero amounts: If you select this check box, all the accounts are displayed even if they have no amount. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

Out of the pyramid: Select this check box to include accounts in the chart of accounts but not in the selected Account pyramid. This option is only available if the Detail check box is selected.This field is not available if a Control account is entered.

Display block

Currency: Enter the exchange currency into which the balance is converted. The converted amounts are displayed in the Conversion column. If no currency is entered, the Conversion columns are blank.

 The entered currency is not used as a filter but as a conversion data. The recovery grid displays all the transactions for the selected period, irrespective of their original currency.

The conversion is performed based on the type of exchange rate entered for the CNSTYPCUR - Inquiry exchange rate parameter (TC chapter, CUR group).

Based on the screen code, ( set up in the GESGTC function), you can display the amounts in the original currency, in ledger currency, and in conversion currency.

Screen code: The preset screen codes (via the GESGTC function for the BAF code) are selected.

On entering the account inquiry function, the parameters stored with code STD(the whole columns are displayed) are recalled by default.

If the criteria are not stored in an STD memo, the submitted default values are the default accounting site for the user (and the corresponding company), the date range matching the last open fiscal year, and the default currency of the company.