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. |
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. |
Displays the opening balance in one of the following specified ways:
Example If the date range defined is 1.4.05–31.3.06 and the posting periods defined are four quarters per calendar year, the date to be considered as "Start of Fiscal Year" is 1.1.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. |