Running the General Ledger Report

The General Ledger Report lists the posting from each source for a single general ledger account or a designated group of ledger accounts for a specified period of time. You can set up the report to list the postings individually, subtotaled by source by day, or subtotaled only by source.

For a description of the report layout, see Report Data at the end of the topic.

To run the General Ledger Report:

1. From the G/L > G/L Reports menu, select General Ledger to display the General Ledger screen.

2. In the Br/Tr/All field, enter the branch or territory for which you want to run the report. Enter All to run the report for all branches and territories.

3. In the Start Date field, enter the first date of the period to include in the report.

4. In the End Date field, enter the last date of the period to include in the report.

Note: For both the Start Date and the End Date field, you can enter an actual date or a variable date, which the system converts to an actual date based on the As of Date entered when the program runs.

5. In the Account field, enter the account name for which you want to run the report.

6. In the Template field, press F10 and select a report template ID.

7. In the SubLedger field, press F10 and select a subledger to include in the report.

Note: If you leave the Account field and the Template field blank but enter a subledger or multiple subledgers in the Subledger field, the report contains all accounts that have postings for those subledgers.

8. In the Sort by field, press F10 and select one of the following ways to sort the report:

• Account# (Default)

• Account# by Branch

9. In the Summary/Detail field, press F10 and select one of the following options:

• Summary – Totals the transactions for each source and prints a line for each subtotal on the report.

• Branch Summary – Subtotals the transactions for each source by branch and prints a line for each branch on the report.

• Totals by Day – Totals the transactions for each source for each day and prints a line for each subtotal on the report.

• Detail – Prints a line for each transaction on the report. Any detail notes added when the general ledger is distributed against in A/P, with cash receipts, or for inventory adjustments are included when you run the report in detail mode.

10. In the Report Currency field, if you want to print the report in a currency other than your company's base currency, press F10 and select a new currency.

11. In the Calculate Exchange field, if you have defined a currency other than your company's base currency in the Report Currency field, select one of the following to indicate how to convert the transaction funds:

• As of Current Date – Converts each transaction amount using the current date's exchange rate.

• Historically – Converts each transaction amount using the exchange rate in effect on the transaction date.

• Average – Uses an average exchange rate by taking the average of all exchange rates within the reporting period and dividing the balance by the amount for that period. Days that do not carry a balance are not included in the average.

12. In the Break on Periods field, type one of the following:

If the report period spans any two fiscal months:

• Type Y to print separate reports for each fiscal month.

• Type N to print one report for a single month. This is the default.

If the report does not span two fiscal months, type N. This is the default.

13. In the SpreadSheet Format field, enter one of the following to determine how to format the report:

• Y – Formats the report for downloading purposes. Specifically, it moves the Account Name into the first column, and adds a Posting Date column after the Source column.

• N – Formats the report for on-screen viewing.

14. Set Options, if needed, and generate the report.

Report Data

The General Ledger Report lists the following columns of information:

See Also:

Foreign Exchange Rates Overview

Standard G/L Reports Overview

Running the General Ledger Export Report