You can specify through detailed selection criteria which accounts should be included in your company's financial reports and which accounts should be included in period-end closing.
In the case of financial reports, these selection criteria help you prepare the reports according to the following groups:
Common accounts and local G/L accounts = for local GAAP reports
Common accounts and IFRS G/L accounts = for IFRS reports
To find and select the required accounts, follow the procedure below.
From the SAP Business One Main Menu, choose
.Open the selection criteria window of one of the following reports, or of the period-end closing transaction:
G/L Accounts and Business Partners
General Ledger
Document Journal
Trial Balance
Trial Balance Comparison
Budget Report
Trial Balance Budget Report
Period-End Closing
Alternatively, you can open any of the above reports from the Reports module.
To clear previous G/L account selections, click the “x” sign at the top of the accounts grid.
Note
If you do not clear previous account selections, these are added to the newly made account selections and the results are displayed cumulatively.
Choose the Find button.
In the Find G/L Accounts window, select whether you want to identify the relevant G/L accounts for the report by segment or by G/L account.
If your company does not use account segmentation, skip this step.
Depending on what you specified in the previous step, do one of the following:
Specify by G/L account codes or by G/L account names, or a mixture of both, which accounts are to be included or excluded in the respective report, together with the appropriate filtering rules.
Note
If the rule that you have selected is either In Range or Out of Range, you must specify a value in the To Value column. For all other rules this field is disabled.
Perform one or more of the following actions, as required:
To perform this task... |
Do this... |
---|---|
Create a new row |
Right-click an existing row and choose Duplicate Row. Alternatively, from the menu bar, choose . |
Delete a row |
Right-click the row and choose Delete Row. Alternatively, from the menu bar, choose .Note If the window contains only one account code row and you delete this row, you can only create further account code rows by choosing Restore. The same applies if you delete a single account name row. End of the note. |
Cut/copy, and paste a value from one row to another |
Click the source cell and choose Cut or Copy. Then click the target cell and choose Paste. |
Delete a value from a row without deleting the entire row |
Click the cell and choose Delete. |
Restore the window to its original state, with one empty row for account code and another empty row for account name |
Right-click a row and choose Restore. |
Cancel the current operation |
Choose the Cancel button. |
Remove all rules and values, while retaining the same number of rows as well as the Field column |
Choose the Clear button. |
Transfer the specified accounts to the selection criteria |
Choose the OK button. |
Note
The relationship between the selection criteria is such that if you specify more than one row, the OR condition applies.
Specify according to segments or segment ranges which G/L accounts are to be included in the report.
This radio button is available only if your company uses account segmentation, that is, if you have selected the Use Segmentation Accounts checkbox on the Basic Initialization tab in
.Specify the other selection criteria and verify that the accounts marked with an “x” in the accounts grid are the ones you require.
To apply the specified filters to the report, choose the OK button.
G/L accounts are displayed in the financial reports according to the rules and values, or the segments, that you defined in the Find G/L Accounts window.
Note
The settings you make in the Find G/L Accounts window are retained in the application until you change them. However, it is not possible to save them as part of an entire set of selection criteria for the report.