Description
The General Journal By Date Report allows you to look at all transactions that go against the General Journal (cash and accrual) for a particular Date Range.
Data: General (Adjustments) Journal (cash and accrual)
Note: This report is run for a date range. You may not see the same figures if you are trying to compare this to an Income Statement or a Balance Sheet that uses a GL Period as a Date Filter.
Prompt
Date Ranges
| • | Start & End Date - Filters the data by the Date Type supplied in the next selection. |
| • | Date Type (Required) - Options are: |
| o | Transaction Date - The Transaction date of the journal entry. |
| o | Create Date - Create Date of the transaction |
| o | Modify Date - Modify Date of the transaction |
General
| • | Org Unit - Filters to a specific the Organizational Unit related to the GL Base Code of the Transaction. |
| • | Include Org. Children - Includes the Organization Units Children when filtering to a specific the Organizational Unit. |
| • | Is Accrual - When checked, the report looks at the Accrual Journals (Receipts & Disbursements) instead of the Cash Basis Journals (CBReceipts & CB Disbursements). Note: The Cash Basis Journals are populated by running the Cash Basis Conversion Utility. |
| • | Hide Detail - When selected, the detail of the Disbursement Journal is hidden. |
| • | Show Comments - When checked, the report will show the GL Comments from the line-items of the Journals. |
| • | Currency Type - The Type of Currency to be used when running the report. Options are Base, Company, Project and Transaction. |
| • | Currency Code - The Currency Code to be used when running the report. Options are set in the Multi-Currency applet. More on Multi-Currency |
Sorts
The Sorts section Groups & Sorts the report by Transaction Date, Create Date, Modify Date, Transaction No.
| • | Sort 2 - Second Level Sort. |
| • | Sort 3 - Third Level Sort |
Report
Report Columns
| • | Trans ID - Identification number of the General Journal Entry |
| • | Trans Date - The Transaction Date Associated with the transaction. |
| • | Comment - G/L Comment associated with the transaction. |
| • | Account - G/L Account associated with the detail of the General Journal Transaction. |
| • | Project - The Project associated with the detail of the General Journal Transaction. |
| • | Expense Code - The Expense Code associated with the detail of the General Journal Transaction. |
| • | Amount - The amount of the line item in the detail of the General Journal Transaction. |
Sample(s)
|