Trial Balance - Selection Criteria

Use this window to specify selection criteria for the Trial Balance report.

To open the window, choose Start of the navigation path Financials Next navigation step Financial Reports Financial Trial Balance End of the navigation path . Alternatively, open it from the Reports module.

After defining the report, you can view it in the Trial Balance window.

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.

Selection Criteria

BP
Includes business partners in the report.

Properties
Open the Properties window and use the business partner properties as selection criteria.

G/L Accounts
Report includes G/L accounts.

Find
To find a special account, choose this button and specify the account code. SAP Business One automatically displays an X next to this account.

Level
Choose the level of the account displayed in the table. If you choose Level 1 here, the table displays the highest level titles for the accounts. If you select a row in the table, you actually select all the accounts that appear under this title.

Date, From...To...
Click and choose the date range type for displaying the report. Then, define the actual range in the From ...To.. fields. Click to define a range of posting periods.

Display in Report
You can select the following options to display in the report: Hide Zero Balanced Acct – Select this checkbox to exclude zero balanced accounts from the report. Hide Acct with No Postings – Select this checkbox to exclude accounts with no postings. This checkbox is only available if Hide Zero Balanced Acct is deselected. Foreign Names – Displays only the foreign names defined for G/L accounts in Financials Chart of Accounts Account Details Foreign Names . Note When this checkbox is selected, nothing is displayed for accounts for which the foreign name was not defined. End of the note. External Code – Displays external codes defined for G/L accounts in Financials Chart of Accounts External Code . Opening Balance for Period – Select this option when you need to differentiate between the balance of the selected posting period and that of the previous periods. When a date range of a current posting period is selected, you can select this checkbox to display the bookkeeping balance prior to the selected date range in a separate column: OB. As default, the checkbox is cleared. Selecting it displays the following options: OB from Start of Company Activity – Displays the opening balance accumulated since the company’s activity started. OB from Start of Fiscal Year – Displays the opening balance accumulated from the start of the current fiscal year. Foreign Currency – Displays amounts in local and foreign currency. When the option System Currency is also selected, the amounts are displayed in system and foreign currency. Note For All Currencies accounts and business partners, if all the journal entries were recorded using the same foreign currency, the trial balance shows the actual foreign currency balance. Otherwise, **** is displayed instead of the amounts. End of the note. System Currency – Displays amounts in system currency only. Local and System Currency – Displays amounts in system and local currencies.

Template
Click (Dropdown List) and select a template for displaying the balance sheet.

Annual Report, Quarterly Report, Monthly Report
Select: Annual Report to calculate the trial balance for the entire year Quarterly Report to calculate the trial balance separately for each quarter Monthly Report to calculate the trial balance separately for each month

Periodic Report
Displays the report according to the posting periods included in the defined date range.

Add Journal Vouchers
Includes in the report Open transactions that are recorded in journal vouchers, but are not yet saved in the database.

Ignore Adjustments
Report excludes adjustment journal entries from its balance calculation.

Add Closing Balances
Selected: Report includes period-end closing journal entries and balances of the selected posting period only. All profit and loss accounts that were closed by the period-end closing process show a zero balance. CB of Life-to-Date: Reports includes the closing balance from the system go life date to the end of the selected period. CB before Selected Period Only: Reports includes the closing balance from the system go life date to the beginning of the selected period. Not selected (default): Report does not include period-end closing journal entries. All profit and loss accounts that were closed by the period-end closing process show the G/L account balance prior to the closing process. Note Period-end closing journal entries of posting periods prior to the selected period are included in the Opening Balance column. In certain countries you can transfer the balances of Balance Sheet accounts from one fiscal year or period to another. In these localizations the period-end closing process is different than described above; therefore, the effect of this box on the report is different. For additional information see the country-specific online help file under Help Documentation Country-Specific Info . End of the note.

Revaluation
Opens the Trial Balance Revaluation window. After the revaluation is made, the option next to this button is selected.

Expanded
Opens the Expanded Selection Criteria window, where you can use a transaction code, project, and distribution rule range, as well as series, as selection criteria for this report.

More Information

Properties

Trial Balance Revaluation

Finding G/L Accounts to Include in Financial Reports/Period-End Closing