Show TOC

Object documentationGeneral Ledger Locate this document in the navigation structure

 

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   Financials   Financial Reports   Accounting   General Ledger  . Alternatively, open it from the Reports module.

After defining the report, you can view it in the General Ledger window.

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
Business Partner

Displays business partners in the report.

Note Note

If not selected, other fields pertaining to business partner selection criteria are not displayed.

End of the note.
Customer Group, Vendor Group

Enables you to include business partners from a specific group, divided between 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 select the required properties. Your choices appear in the adjoining field.
G/L Accounts

Includes G/L accounts in the report.

Note Note

If not selected, other fields related to G/L account selection criteria are not displayed.

End of the note.
Find

Opens the G/L Accounts window, where you specify G/L accounts for the report.
Level

Select the level of the accounts displayed 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.
Level

Indicates accounts selected to appear in the report.

  • To deselect an account, clear the X from its row.

  • To select/clear all accounts/selections in the table, click the X in the column header.
Posting Date From...To..., Due Date From...To..., Document Date From...To...

Specify the date type by which to define the transaction range for the report.

You can:

  • Use more than one date range

  • Specify a specific financial period
Expanded

Opens the Expanded Selection Criteria window, where you define additional parameters for the transactions to be included in the general ledger report.
Print Each Account on Sep. Page

Prints the transactions related to each account on a separate page. Otherwise, the transactions are printed successively.
Print Directly to Printer

Prints the report without displaying it on the screen.
Order Acct By Chart of Accounts

Report displays accounts in the same order as in the Chart of Accounts window.
Ignore Adjustments

Report excludes transactions with Adj. Trans. (Period 13) selected.
Foreign Names

The report displays the foreign names defined for business partners and accounts.
Display Postings Summary

Includes a summary of the postings displayed in the bottom line of the report.
Display OB for Periods

Displays the balance of the business partners and accounts, as calculated for the day before the first day in the date range defined for the report.

Caution Caution

The calculation of the opening balance is determined by the date range specified for the report. If you specified more than one date range, SAP Business One calculates opening balance as follows:

  • If Posting Date is one selected option, all transactions with posting date earlier than the date defined in Posting Date From are included.

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

End of the caution.
Display

Choose the transactions to display in the report:

  • All Postings – All postings found, according to the selection criteria

  • Not Fully Reconciled – All the postings that are not fully reconciled

  • Fully Reconciled Only – Only the postings that are fully reconciled

  • Unreconciled Externally – Only postings that are not reconciled externally (relevant mostly for bank accounts)

  • Reconciled Externally – Only postings that are reconciled externally
Consider Reconciliation Date

Note 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:

  • If you select the checkbox, the report displays transactions with a correct historic balance due as at the specified posting date To date as follows:

    • If the reconciliation date is later than the specified posting date To date, the transaction (or partial transaction if partially reconciled) is shown as un-reconciled, and the un-reconciled Balance Due value is displayed.

    • If the reconciliation date is earlier than or same as the specified posting date To date, the transaction (or partial transaction if partially reconciled) is shown as reconciled, and the reconciled Balance Due value is displayed.

  • If you do not select the checkbox, the report displays transactions with the latest balance due.
Hide Zero Balance Due

Note 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.
Hide Zero Balanced Acct

Excludes zero balanced accounts from the report.

Note Note

Available only if Hide Acct with no Postings is not selected.

End of the note.
Hide Acct with no Postings

Report excludes accounts with no postings.
Sort and Summarize

Enables you to specify sorting criteria for displaying the report on the screen:

  • In the field below, specify what is to be sorted.

  • In the table, define up to three levels of sort.

  • In each row, specify:

    • Required field

    • Order

    • Summarize or not
Revaluation

Opens the Revaluation Selection Criteria window where you can specify how to revaluate report results.

Note Note

The revaluation is for display purposes only and does not affect the postings values.

End of the note.

More Information

Properties

G/L Accounts

Expanded Selection Criteria

Finding G/L Accounts to Include in Financial Reports/Period-End Closing

Revaluation Selection Criteria