The General Ledger report displays posted general ledger transactions for a specified fiscal period range or date range. It is available as a Standard Report, Compressed Report, or Alternate Report.

For each account, the report displays the account number, account description, and beginning and ending balances, transaction details, and period totals.

Transaction details include the document ID, the journal to which the transactions were posted, a line description, the date of posting, the vendor name or reference for the transaction, debits, credits, and the ending balance.

For Inventory transactions, the report prints Inventory ID, the type of inventory transaction such as Receipt, Shipment, or Return, and the Document ID from data entry screens in the Inventory module.

NOTE that the value in the Name or Reference column is:

• Vendor name from AP Transactions, or
• Reference value from JE transactions, or
• Customer name from AR Transactions.

Unapproved Transactions - When the transaction is unapproved, an asterisk (*) appears next to the account description.

Period totals, provided for each account, include debit, credit, and ending balance totals.

If the period totals do not reflect an entire period, due to the selected report range, the words “partial period“ appear next to the Period Totals heading.

When run for Multiple Fiscal Years - The General Ledger reports (all options) print headings and group totals for Subtotal amounts by account for the fiscal year ended, when the report is run for multiple fiscal years.

1. From the eFinancials menu, select Reports—GL Reports—General Ledger. Or, from the ePO menu, select Reports—General Ledger.
2. Click Select EntitiesCompanies. Select the entitiescompanies for which you want to print the report and click Save.
3. Select the From and Thru Prd/Fiscal Year option button and enter a period and fiscal year range for the report. Or, select the From Date option button and enter a date range for the report.
4. From the From and  To Account fields, click the Lookup icon to display the Select GL Account Tab and select a range of general ledger account numbers for the report.

Note

If the From / To  Account fields are left blank, the report includes all accounts for all selected entitiescompanies.

5. To include unapproved transactions on the report, select the Include Unapproved Transactions check box.
6. To print a summary report, select the Summary option button. If the button is not selected, a detail report prints.
7. Select the type of report you want to print: Standard Report or Compressed Report, or Alternate Report.
   • Standard Report - The standard format for the General Ledger report.
   • Alternate Report - For information about the Alternative Report format, refer to the topic, Alternate Report Format.
   • Compressed Report - Prints the report in a compressed layout. The font  size is smaller, white space is reduced, and $0.00 does not display in Debit and Credit columns for detail lines.
8. Select one of the following report printing options:
• PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.
• Create Spreadsheet: Prints the report in an Excel spreadsheet.
9. Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.