Show TOC

Object documentationDocument Journal Locate this document in the navigation structure

 

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.

Note 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.
Selection Criteria
BP

Displays business partners in the report.

Note Note

When not selected, all other fields pertaining to business partner selection criteria are unavailable.

End of the note.
Customer Group, Vendor Group

Specify whether to display business partners from specific groups, divided into customers and vendors.

Note Note

To display only customers, choose None in the Vendor Group field.

End of the note.
Properties

Opens the Properties window where you can specify properties as selection criteria. Your choices appear in the adjoining field.

Accounts

Includes G/L accounts in the report.

Note Note

When not selected, all other fields related to G/L accounts selection criteria are unavailable.

End of the note.
Find

Opens the Find G/L Accounts window, where you can specify G/L accounts to be included in the report.

[Level]

Select the level of the accounts to display in the table. Selecting Level 1 displays the account titles on the highest level.

Note Note

A selected row includes all accounts appearing under the title.

End of the note.
X, Account

Indicates accounts selected to appear in the report:

  • Clear the X from a row to deselect the account.

  • Click the X in the column header to select/clear all accounts/selections in the table.

Posting Date From...To, Creation Date From...To, Document Date From...To

Define the transaction range by posting, creation and/or document date, and specify a date range.

Output Mode: Detailed

Specify the output mode of the report:

  • No Total: Displays all journal entries

  • Month (Posting Date): Displays all journal entries per month based on the posting date

  • Month (Posting Date) and Original Journal: Displays all journal entries per month based on the posting date and original journal

  • Period (Posting Date) and Original Journal: Displays all journal entries per period based on the posting date and original journal

Output Mode: Totals

Specify the output mode of the report:

  • Month (Posting Date): Displays the totals per month based on the posting date

  • Month (Creation Date): Displays the totals per month based on the creation date

  • Month (Posting Date) and Original Journal: Displays the totals per month based on the posting date and original journal

  • Period (Posting Date) and Original Journal: Displays the totals per period based on the posting date and original journal

Creation Date

Groups the postings by month, based on the creation date.

Note Note

Only available for Month Totals Mode.

End of the note.
Display Postings Summary

Displays the postings summary in a separate row at the end of the report.

Note Note

Only relevant for Month Totals Mode.

End of the note.
Display OB for Periods

Displays the opening balance in one of the following specified ways:

  • OB from Start of Company Activity – from day one of company activity through the date range defined for the report.

  • OB from Start of Fiscal Year – accumulated from the start of the fiscal year to which the earliest posting period included in the date range of the report refers.

Example 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 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.
  • If Posting Date is one of the selected options, all transactions with posting date earlier than the date defined in the Posting Date From field are included.

  • If Posting Date is not one of the selected options, all transactions with document date earlier than the date defined in the Document Date From field are included.

Ignore Adjustment

Report excludes adjustment transactions.

Display Installments in One Row

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 Note

Only relevant for the Detailed Transactions output mode.

End of the note.
Numbering for Detailed Mode, First Sequential No., No. on First Printed Page

Specify the first sequential number and the first page number to be displayed in the detailed mode of the report.

Note Note

Page numbering is only relevant for printed reports.

End of the note.
Sort

Report sorts using the criteria that you specify.

In the table, specify the required sorting fields and their preferred order.