Document Journal 
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 
Financials 
Financial Reports Accounting Document Journal Report 
. Alternatively, open it from the Reports module.
After defining the report, you can view it in the output modes Detailed Transactions or Month Totals.
This topic documents fields and other elements in this window that either are not self-explanatory or require additional information. End of the note. |
NoteSelection Criteria
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 |
()Displays business partners in the report.
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.
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.
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.
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.
Only available for Month Totals Mode. End of the note. |
Displays the postings summary in a separate row at the end of the report.
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:
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.
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.
|
Example
CautionReport 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.
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.
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. |