This report enables you to generate a list of journal entries posted to the company database according to various criteria. Use this window to specify selection criteria for the report.
To open the window, choose
. Alternatively, open it from the Reports module.After defining the report, you can view it in the General Ledger window.
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. |
You can save a specific set of selection criteria and generate the report accordingly whenever required. To do so pressCTRL+A , enter a meaningful name, and set all the required selection criteria for the report. Choose Save. To generate a report based on a saved selection criteria set, click the () icon. The List of Reports – Selection Criteria window appears. Highlight the required selection criteria set from the list, and choose the Choose button. The selected selection criteria set is populated. To generate the report, choose OK. |
Displays business partners in the report. Note If not selected, other fields pertaining to business partner selection criteria are not displayed. End of the note. |
Enables you to include business partners from a specific group, divided between customers and vendors. Note To display only customers, choose None in the Vendor Group field. End of the note. |
Opens the Properties window, where you select the required properties. Your choices appear in the adjoining field. |
Includes G/L accounts in the report. Note If not selected, other fields related to G/L account selection criteria are not displayed. End of the note. |
Opens the G/L Accounts window, where you specify G/L accounts for the report. |
Select the level of the accounts displayed in the table. Selecting Level 1 displays the account titles on the highest level. Note A selected row includes all accounts appearing under the title. End of the note. |
Indicates accounts selected to appear in the report.
|
Specify the date type by which to define the transaction range for the report. You can:
|
Opens the Expanded Selection Criteria window, where you define additional parameters for the transactions to be included in the general ledger report. |
Prints the transactions related to each account on a separate page. Otherwise, the transactions are printed successively. |
Prints the report without displaying it on the screen. |
Report displays accounts in the same order as in the Chart of Accounts window. |
Report excludes transactions with Adj. Trans. (Period 13) selected. |
The report displays the foreign names defined for business partners and accounts. |
Select the checkbox to summarize the transactions posted to the control accounts in the report. |
Select this checkbox to hide any transaction row which has a zero posting amount in the local currency. |
Includes a summary of the postings displayed in the bottom line of the report. |
Select this checkbox to display the opening balance of the selected BP and G/L accounts, as accumulated in the time range from the following option date to the start date specified in the Selection options:
Example You have selected the OB from Start of Fiscal Year radio button. The posting date range defined in the Selection option is 01/04/2005–31/03/2006, and the posting periods defined for the company are four quarters per calendar year. The date to be considered as "Start of Fiscal Year" is then 01/01/2005 . The opening balance display is then the accumulated balance from 01/01/2005 to 01/04/2005. End of the example. Caution The calculation of the opening balance is influenced by the date range defined for the report. If you specify more than one date range, SAP Business One calculates opening balance as follows: End of the caution.
|
Choose the transactions to display in the report:
|
Note This field is available only if you select All Postings, Not Fully Reconciled, or Fully Reconciled Only in the Display field. End of the note. Enables you to do the following:
|
Note The field is available only if you select All Postings in the Display field and select Consider Reconciliation Date checkbox. End of the note. Select to hide the transactions which have a zero balance due as calculated when the Consider Reconciliation Date checkbox is selected. |
Excludes zero balanced accounts from the report. Note Available only if Hide Acct with no Postings is not selected. End of the note. |
Report excludes accounts with no postings. |
Enables you to specify sorting criteria for displaying the report on the screen:
|
Opens the Revaluation Selection Criteria window where you can specify how to revaluate report results. Note The revaluation is for display purposes only and does not affect the postings values. End of the note. |