Show TOC

Procedure documentationSetting Filters on Reports for IFRS Locate this document in the navigation structure


SAP Business One allows you to filter your financial reports and accounting reports according to the level of granularity your company requires for IFRS. You do this by specifying selection criteria for the reference fields and user-defined fields that were defined in   Administration   Setup   General   Reference Field Links  .


  1. Open the selection criteria window of one of the following reports:

  2. Choose the Expanded button.

    The Expanded Selection Criteria window opens.

  3. To the right of the Reference Fields checkbox, click the Browse (Browse) button or click the Reference Fields checkbox.

  4. In the Reference Fields window, specify the following data for one or more reference fields:




    Displays the reference field name and position in the following order:

    • Ref. 1 (header)

    • Ref. 2 (header)

    • Ref. 3 (header)

    • Ref. 1 (BP row)

    • Ref. 1 (row)

    • Ref. 1 (all rows)

      This setting applies to both Ref. 1 (BP row) and Ref. 1 (row).

    • Ref. 2 (BP row)

    • Ref. 2 (row)

    • Ref. 2 (all rows)

      This setting applies to both Ref. 2 (BP row) and Ref. 2 (row).

    • Ref. 3 (BP row)

    • Ref. 3 (row)

    • Ref. 3 (all rows)

      This setting applies to both Ref. 3 (BP row) and Ref. 3 (row).


    To determine how to filter the values for a particular field, select one of the following from the dropdown list:

    • Equal

    • Not Equal

    • In Range

    • Out of Range

    • Greater than

    • Greater or Equal

    • Smaller than

    • Smaller or Equal

    • Contains

    • Does Not Contain

    • Start with

    • End with

    • Is Empty

    • Is Not Empty

    If you do not want to filter this reference field, do not specify a rule.


    Specify the required value for each field that you filter.

    To Value

    If the rule that you selected is either In Range, or Out of Range, specify a value. For all other rules, this field is disabled.

  5. Optionally, do one or more of the following:

    • To cancel the operation, choose the Cancel button.

    • To clear all values in the window, choose the Clear button.

  6. To save your settings and to return to the Expanded Selection Criteria window, choose the OK button.

    The Reference Fields checkbox now appears as selected.

  7. To set one or more filters based on user-defined fields, click the Browse (Browse) button to the right of the User-Defined Fields checkbox or click the User-Defined Fields checkbox, and proceed as described in steps 3–5 above.

    Once you have set filters on user-defined fields, the User-Defined Fields checkbox appears as selected.

    Note Note

    User-defined fields of the following definition types and structures are not available:









    End of the note.
  8. To return to the selection criteria window, choose the OK button.


The respective financial reports and accounting reports are generated according to the rules and values that you have defined in this procedure.

Reports based on these filters have the following features:

  • The logical operator between the filters – that is, between the rows in the definition table – is AND not OR.

  • Any filter settings that were made against the All Rows option affect both accounting entries in the report (BP row and row).

  • In the balance sheet, trial balance, and profit and loss statement, the printed/printable report's selection criteria shows the filters on reference fields and/or user-defined values that were used to generate the report.

  • In the general ledger and document journal, the reference fields and user-defined values are displayed in the detailed views of the report results. You can activate/deactivate the display of these fields in the Form Settings window in exactly the same way as you can for standard fields.