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 
Administration
Setup General Reference Field Links 
.
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.
NoteUser-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.
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.