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
Selection Criteria Name

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.

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.

Summarize Control Accounts

Select the checkbox to summarize the transactions posted to the control accounts in the report.

Hide Zero Value LC Rows

Select this checkbox to hide any transaction row which has a zero posting amount in the local currency.

Display Postings Summary

Includes a summary of the postings displayed in the bottom line of the report.

Opening Balance for Period

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:

  • OB from Start of Company Activity – displays the opening balance accumulated after company activity started.

  • OB from Start of Fiscal Year – displays the opening balance accumulated after the start of the fiscal year specified in the Selection options.

Example 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 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.

Display

Choose the transactions to display in the report:

  • All Postings – Displays all transactions posted to the selected BP and G/L accounts.

  • Not Fully Reconciled – Displays transactions posted to the selected BP and G/L accounts that are either partially reconciled or not reconciled.

    You can internally reconcile the BP or G/L accounts in the BP Internal Reconciliation - Selection Criteria or G/L Internal Reconciliation - Selection Criteria window.

  • Fully Reconciled Only – Displays only the transactions posted to the selected BP and G/L accounts that are fully reconciled.

  • Unreconciled Externally – Displays transactions posted to the selected BP and G/L accounts that are not reconciled with any external account statement.

    You can externally reconcile the BP or G/L accounts in the External Reconciliation - Selection Criteria window.

  • Reconciled Externally – Displays transactions posted to the selected BP and G/L accounts that are reconciled with external account statements.

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.