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