This chapter contains these topics:
Cash basis reports provide detailed information about cash basis transactions. Use these reports to review transactions, research problems, or verify information. The following table includes a description for each of the cash basis reports:
From Cash Basis Accounting (G09314), choose Unposted Cash Basis Report
From the versions list, select the DEMO version General Journal: Cash Basis Entries. This version has the data selection set up for Ledger Type equal to AZ and G/L Posted Code equal to *Blank.
The processing time for the Unposted Cash Basis report depends on the number of unposted batches in the system. Alternatively, you can review cash basis transactions online. Reviewing transactions online provides a quicker, more flexible review. However, if you require an audit trail for proofing or if there is a balancing problem, the report is more useful for detailed analysis.
The Unposted Cash Basis Report shows transactions from the Account Ledger table (F0911). This report is the same as the Unposted General Journal Report. See Print General Journals in the JD Edwards World General Accounting I Guide.
You can enter additional data selection, but you should not change the data sequencing. The report calculates totals, and changing the data sequencing will produce unpredictable totaling results.
From Cash Basis Accounting (G09314), choose Cash Basis IntegrityTest
The Cash Basis Integrity Test report (P09750) reviews all cash basis entries for a specific time period and produces an exception report that lists the accounts that are out of balance. Expect that only cash accounts balance between the two ledgers (AA and AZ).
The report prints summary or detail information. The integrity test with transaction detail can be lengthy. You might want to run the report without detail first to determine how many accounts within the range you choose are out of balance.
If you set the View Transaction Detail processing option, all posted detail records in the AA and AZ ledgers appear above the ledger balances for each period that is out of balance. If you do not select the detail format, the two ledger balances appear side-by-side for each period that is out of balance.
Information on the report appears in reverse chronological order, beginning with the "as of" date that you specify in the Enter As Of Date processing option and going back through all years that you specify in the data selection.
If you are using Enhanced Subledger Accounting, this information displays on the report. See Work with Enhanced Subledger Accounting in the JD Edwards World General Accounting I Guide for more information.
The Cash Basis Integrity Test report shows transactions from the Account Ledger (F0911) and Account Balances (F0902) tables.
Enter the prior fiscal years that you want to view. You must specify ledger type AA. The integrity test and report run more efficiently when you sequence by company.
From Cash Basis Accounting (G09314), choose Cash Basis Audit Report
The Cash Basis Audit Report (P09760) provides you with information about the cash basis entries at the transaction level. This is a powerful research tool that allows you to quickly determine which documents are balanced, as well as which documents are posted. You can identify cash basis entries that do not balance by the message Not Balanced.
JD Edwards World provides three DEMO versions of this report. You can choose:
Cash Basis Audit Report - G/L Entries
Cash Basis Audit Report - A/R Entries
If you are using Enhanced Subledger Accounting, this information displays on the report. See Work with Enhanced Subledger Accounting in the JD Edwards World General Accounting I Guide for more information.
See Section 6.5, "Cash Basis Audit Report - G/L Entries (P09760)" for information from the Account Ledger table (F0911).
Do not change the data selection for Ledger Type equal to AZ (cash basis). You can enter additional data selection to select posted records, additional cash basis document types, a specific batch, or G/L dates. Do not change the data sequencing. The report calculates totals, and changing the data sequencing will produce unpredictable totaling results.