Setting Filters on Reports for IFRS

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 Start of the navigation path Administration Next navigation step Setup General Reference Field Links End of the navigation path .

Procedure

Open the selection criteria window of one of the following reports:
Choose the Expanded button.
The Expanded Selection Criteria window opens.
To the right of the Reference Fields checkbox, click the (Browse) button or click the Reference Fields checkbox.

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

Field	Description
Field	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).
Rule	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.
Value	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.

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.
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.
To set one or more filters based on user-defined fields, click the (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
User-defined fields of the following definition types and structures are not available:

Type

Structure

General

Link

General

Image

Alphanumeric

Text

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

Type	Structure
General	Link
General	Image
Alphanumeric	Text

Result

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.

More Information

Creating an IFRS Setup in SAP Business One