This report displays in detail journal entries created manually or automatically by documents produced in SAP Business One. The large variety of selection criteria can create the most accurate report as per company requirements.
Use this window to specify selection criteria for the Document Journal report.
To open the window, choose
. Alternatively, open it from the Reports module.After defining the report, you can view it in the output modes Detailed Transactions or Month Totals.
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 When not selected, all other fields pertaining to business partner selection criteria are unavailable. End of the note. |
Specify whether to display business partners from specific groups, divided into 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 can specify properties as selection criteria. Your choices appear in the adjoining field. |
Includes G/L accounts in the report. Note When not selected, all other fields related to G/L accounts selection criteria are unavailable. End of the note. |
Opens the Find G/L Accounts window, where you can specify G/L accounts to be included in the report. |
Select the level of the accounts to display 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:
|
Define the transaction range by posting, creation and/or document date, and specify a date range. |
Specify the output mode of the report:
|
Specify the output mode of the report:
|
Groups the postings by month, based on the creation date. Note Only available for Month Totals Mode. End of the note. |
Displays the postings summary in a separate row at the end of the report. Note Only relevant for Month Totals Mode. End of the note. |
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.
|
Report excludes adjustment transactions. |
Group installments included in transactions in one row. The row representing the installments displays the cumulative amount of all the installments in the transaction, while all the other details of that row refer to the last installment. Note Only relevant for the Detailed Transactions output mode. End of the note. |
Specify the first sequential number and the first page number to be displayed in the detailed mode of the report. Note Page numbering is only relevant for printed reports. End of the note. |
Report sorts using the criteria that you specify. In the table, specify the required sorting fields and their preferred order. |