G/L Transactions By Account and Period Report

This report provides a list of transactions (invoice/payment/credit/refund) in a specific period and their debit/credit effect on the G/L Account. Since this report provides transaction level detail, this report could be thought as a detail report of Batch Activity by Date Report.

Report Parameters

Selected report parameter information displays below the title of the report.

Parameter Name Required Description
Business Unit Required

Choose the specified business unit you want to run this report on from the drop-down list.

Fiscal Year Status Required

Choose the specified fiscal year status you want to run this report on from the drop-down list: All, Open, or Closed.

Fiscal Year Required

Choose the specified fiscal year you want to run this report on from the drop-down list.

Period Required

Choose the specified fiscal year period you want to run this report on from the drop-down list.

GL Account Type Optional Choose the specified General Ledger account type you want to run this report on from the scrolling list.
GL Account Optional Choose the specified General Ledger account you want to run this report on from the drop-down list.

Report Fields

This report can produce output in a browser window (HTML) containing the following information:

Column Name Description
Transaction Date

Lists the transaction date.

Transaction Description

Lists the transaction description.

Transaction Number

Lists the transaction number.

Customer Number

Lists the customer number.

Customer Name Lists the customer name.
Debit Amount Lists the debit amount for the batch.
Credit Amount Lists the credit amount for the batch.
Batch Name Lists the batch name.
GL Account Total Lists the General Ledger account total.
Grand Total Lists the report total.