Financial Reports > GL Reports > GL Transaction Activity Reports
  
GL Transaction Activity Reports
GL Transaction Activity Reports Menu (25.15.1) lists the reports that state activity on GL accounts. These reports are on the GL Transaction Activity Reports Menu (25.15.1).

GL Transaction Activity Reports Menu (25.15.1)
 
Report
Description
GL Transaction Report (25.15.1.1)
Lists all posting lines for the selected daybooks. The report groups postings by GL calendar year and GL period, daybook code, and entity. Within each grouping of daybook code and entity, the report groups transactions by voucher and posting date.
GL Transactions by Account (25.15.1.2)
Lists all activity for the selected GL accounts during the selected time frame, grouped by account.
The report displays the business relation code for every transaction related to a business relation.
GL Transactions per Sub-Account (25.15.1.3)
Lists all activity for the selected GL accounts during the selected time frame, grouped by sub-account.
GL Transactions by Daybook (25.15.1.4)
Lists all activity for the selected GL accounts during the selected time frame, grouped by daybook.
GL Transactions per Intercompany Code (25.15.1.5)
Lists all activity for the selected GL accounts and time frame, grouped by intercompany code.
GL History Report (25.15.1.6)
Lists activity grouped by currency, cost center, and sub-account for the periods indicated. It also lists the currency in which each transaction was denominated.
GL Open Item Report (25.15.1.8)
Lists and totals GL open items within the Open Items sub-ledger. The report groups output by allocation key.
Additional criteria:
Allocation Key
Open at Date
GL Transactions Audit Log (25.15.1.9)
Prints a detailed list of each transaction for a particular GL period. It is only possible to run the report for a single GL period.
For each daybook in the report criteria, all detail lines are printed for the specified GL period. Each detail line is followed by the analysis linked to that line.
Additional criteria:
Last Modified Date
Last Modified User
GL Account List (25.15.1.10)
Displays a listing of accounts from a specified range. The report displays account details, such as the account code, account description, the type of posting (automatic or manual), and the currency.
GL Account Data Report (25.15.1.11)
Displays a full description of each GL account identified by the selection criteria.
Reversed/Replaced GL Report (25.15.1.12)
Displays a list of all reversed/replaced GL transactions for the period indicated in the selection criteria.
GL Verification and Approval (25.15.1.13)
Displays data created during the status transitions with verify and approve statuses have been defined.
GL Account Sheet Report (25.15.1.14)
Shows the balance of the selected accounts at the specified start date and all transactions with the balancing accounts in detail up to the specified end date of the report. When applicable, the supplier or customer name and the tax class are shown per posting line.
GL Transactions Operational Report (25.15.1.15)
This report is similar to GL Transaction Report (25.15.1.1), but focuses on postings created from operational transactions and their associated details such as GL Reference, Transaction Type, Doc Type, Address.
Unposted Transactions Inquiry (25.13.13)
Lets you review unposted transactions before posting.
This report also contains a GL Reference selection field. References start with IC, SO, WO, FA, or with the GL calendar year.
Unposted Transactions Register (25.13.14)
Generates a report on unposted operational transactions based on ranges of selection criteria.
Entity (From/To)
Reference (ID)
Entered Date (From/To)
Effective Date (From/To)
Batch
Transaction Type
Unbalanced Only
GL Mirror Accounting Report (25.15.1.16)
Displays the source and mirror postings for a selection of source accounts and source daybooks. The report identifies the source and mirror posting lines and daybooks both for split and non-split transactions.
Reporting Daybook Exceptions Report (25.8.13)
Displays transactions for which the reporting daybook has been modified.
For invoice-type transactions, the reporting daybook normally matches the posting daybook. However, if a transaction was posted using an incorrect daybook, you can use Reporting Daybook Modify (25.13.1.15) to modify the reporting daybook to ensure that the transaction is reported on correctly. See Modifying Reporting Daybooks.
Cash and Bank Receipt Journal Report (25.15.7.1)
Lists the details of the posting lines per transaction. The transaction type is cash and bank receipt.
Cash and Bank Payment Journal Report (25.15.7.2)
Lists the details of the posting lines per transaction. The transaction type is cash and bank payment.
Account Transaction Journal (25.15.7.3)
Lists the details of the posting lines per transaction. The transaction type is account transfer (non-cash and bank).
Foreign Currency Journal Report (25.15.7.4)
Lists the details of the posting lines per transaction. Transactions that involve foreign currencies are reported.
General GL Journal (25.15.7.5)
Lists the details of the posting lines per transaction. Any GL transaction can be included in this report that has a general format.
Cash and Bank GL Report (25.15.7.6)
Lists all the transactions chronologically within a specified date period for a cash and bank GL account.
The account balances at the beginning of the period and by the end of the period are reported, as well as the summaries of daily totals on account debit and credit amounts.
The report can be detailed to the sub-account and cost center level.
Subledger Report (25.15.7.7)
Lists all movements for a GL account, within a specified date period, and the report can be detailed to the sub-account and cost center level.
The report shows the beginning and ending account balances for the period, the debit and credit totals, and accumulated totals for debit and credit amounts up to the reporting date.
Account Balance of Totals Report (25.15.7.8)
Lists GL accounts of an entity and their balances within a specified date period.
Each line of the report displays an account, its beginning balance, debit and credit amounts, and the ending balance of the period.
Generation of the report is based on a budget you set up for the entity following Chinese accounting practices. Typically, the budget includes the GL account, sub-account, and cost center levels of budget topics that cover the chart of accounts (COA) of the entity. You may also need the budget for reporting.
Columnar Ledger Report (25.15.7.9)
This report is an extension of the Subledger report. Additional columns are appended to the right side of the report, to indicate the detailed sub-account and cost center information for each movement for a GL account.
General Ledger Report (25.15.7.10)
Lists all movements for a GL account, chronologically within a specified fiscal period. Unlike the Subledger Report, the General Ledger Report cannot be detailed to the sub-account and cost center level.
The report shows the beginning and ending account balances of the fiscal period.
Value-Added Tax Payable Ledger Report (25.15.7.11)
Lists the value-added tax payable information for an entity within a specified fiscal period.