Show TOC

Object documentationTrial Balance - Selection Criteria Locate this document in the navigation structure

 

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

To open the window, choose   Financials   Financial Reports   Financial   Trial Balance  . 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 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 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 (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 Note

  • Period-end closing journal entries of posting periods prior to the selected period are included in the Opening Balance column.

  • In Italy, Spain, France and Portugal localizations 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.

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.
Country-Specific: Poland, Portugal, Slovakia
Detailed Annual Report

Displays the opening and closing balances for the entire year, together with data on the reporting periods, with separate Debit and Credit columns for the relevant balances.

More Information

Properties

Trial Balance Revaluation

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