F03B11 to F03B22 Integrity (R8903B22I)

In proof mode, this report compares records in the F03B11 table with the F03B22 table and prints the differences on a report.

In final mode, this report creates an adjusting amount in the F03B22 table to balance to the F03B11 table.

F03B11 to F03B40 Integrity (R8903B40I)

Prerequisite: Run the F03B11 to F03B22 Integrity report.

In proof mode, this report compares records in the F03B11 table with the F03B40 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F03B40 table to balance to the F03B11 table.

F03B11 to F03B14 Integrity (R8903B14I)

Prerequisite: Run the F03B11 to F03B40 Integrity report.

In proof mode, this report compares records in the F03B11 with the F03B14 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F03B14 table to balance to the F03B11 table.

F03B14 to F03B41 Integrity (R8903B41I)

Prerequisite: Run the F03B11 to F03B14 Integrity report.

In proof mode, this report compares records in the F03B14 with the F03B41 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F03B41 table to balance to the F03B14 table

F03B14 to F03B13 Integrity (R8903B13I)

Prerequisite: Run the F03B14 to F03B41 Integrity report.

In proof mode, this report compares records in the F03B14 table with the F03B13 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F03B13 table to balance to the F03B14 table.

F03B22 to F03B23 Integrity (R8903B23I)

Prerequisite: Run the F03B14 to F03B13 Integrity report.

In proof mode, this report compares records in the F03B22 table with the F03B23 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F03B23 table to balance to the F03B22 table.

F03B11 to F0911 Integrity (R890911AI)

Prerequisites:

• Run the F03B22 to F03B23 Integrity report.

• Set up AAI items ADR and AER for company 00000.

  If you do not set up ADR and AER, you receive an AAI missing/invalid error message when you run this report in proof and final update F0911-only modes. You can set up ADR and AER for companies other than company 00000; however, in final mode, this integrity report creates an adjustment for the last company in a document or batch, which might not be the correct company.

This report has four modes, one proof and three final:

In proof mode, this report compares records in the F03B11 table to the F0911 table and prints differences on a report.

In final mode, update F0911 only, this report creates an adjusting amount in the F0911 table to balance to the F03B11 table. In final mode for this report, the adjusting amounts are directed to:

• ADR, which tracks differences between the F03B11 and F0911 distribution amounts at the document level.

  The distribution amounts typically appear in revenue accounts.

• AER, which tracks differences between the F03B11 and F0911 automatic entry amounts at the batch level.

  The automatic entry amounts appear in accounts such as trade and tax payable accounts.

In final mode, update F03B11 only, this report creates an adjusting amount in the Amount to Distribute field (ATAD) of the F03B11 table to balance to the F0911 table. This report ensures that the distribution amounts in the F0911 equal the total of the ATAD amounts for a document. To balance the amounts at the document level, this report creates an adjusting amount for the last pay item in a document.

In final mode, update F0911 and F03B11, this report creates an adjusting amount first in the F0911 table to balance to the F03B11 table, and then an adjusting amount in the ATADfield of the F03B11 table to balance to the F0911 table. The results of this report are the same as running the final - update F0911 only and final - update F03B11 only reports in succession.

Note. If, at a later time after the conversion, you adjust an existing pay item for a document in which the ATAD field was adjusted by this integrity report, the document might be out of balance. To avoid this, you should create a new pay item to adjust the amount instead of adjusting the converted pay item.

F03B13 to F0911 Integrity (R890911CI)

Prerequisite: Run the F03B11 to F0911 Integrity report.

In proof mode, this report compares records in the F03B13 table with the F0911 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F0911 table to balance to the F03B13 table.

F03B14 to F0911 Integrity (R890911BI)

Prerequisite: Run the F03B13 to F0911 Integrity report.

In proof mode, this report compares records in the F03B14 table with the F0911 table and prints differences on a report. In proof mode, this report is equivalent to the A/R to G/L Receipts by Batch report (R03B702).

In final mode, this report creates an adjusting amount in the F0911 table to balance to the F03B14 table.

A/R to Account Balance by Account ID (R03B707)

Prerequisite: Run the F03B14 to F0911 Integrity report.

This report replaces the A/R to G/L by Offset Account integrity report (R03B7001A). It summarizes open amounts in each general ledger account in the F03B11 table and compares the total with the balance amount in each offsetting accounts receivable trade account in the F0902 table.

F0411 to F0911 Integrity (R04711)

In proof mode, this report compares records in the F0411 table with the F0911 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F0911 table to balance to the F0411 table. The adjusting amount is directed to one of these AAIs:

• ADP, which tracks differences between the F0411 and F0911 distribution amounts (expense account).

• AEP, which tracks differences between the F0411 and F0911 automatic entry amounts (trade account).

  Note. Before you run this report in final mode, determine whether you want to automatically create adjusting entries for batches that are out of balance. If you do not want to create adjusting entries, modify the data selection to exclude the batches from appearing on the integrity reports. Otherwise, adjusting entries are created for out-of-balance batches.

F0414 to F0411 Integrity (R04713)

In proof mode, this report compares records in the F0414 table with the F0411 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F0414 table to balance to the F0411 table.

F0414 to F0911 Integrity (R04712)

Prerequisites: Run the F0414 to F0411 Integrity and F0411 to F0911 Integrity reports.

In proof mode, this report compares records in the F0414 table with the F0911 table and prints differences on a report.

In final mode, this report creates an adjusting amount in the F0911 table to balance to the F0414 table.

Note. Before you run this report in final mode, determine whether you want to automatically create adjusting entries for batches that are out of balance. If you do not want to create adjusting entries, modify the data selection to exclude the batches from appearing on the integrity reports. Otherwise, adjusting entries are created for out-of-balance batches.

A/P to G/L Integrity by Offset Account (R047001A)

This report summarizes open amounts in each general ledger account in the F0411 table and compares the total with the balance amount in each offsetting accounts payable trade account in the F0902 table.

Unposted General Journal (R09301)

This report prints a general journal of unposted transactions in the F0911 table.

Accounts without Business Units (R097041)

In proof mode, this report locates account master records with an invalid company number and without a business unit record in the F0901 table.

In final mode, this report updates the F0901 table with the company number from the business unit master record.

Account Balance without Account Master (R097031)

In proof mode, this report locates account balance records with an invalid company number and without an account master record in the F0901 table.

In final mode, this report updates the F0902 table with the company number from the account master record in the F0901 table.

Transactions without Account Master (R097021)

In proof mode, this report locates transaction records with an invalid company number and without an account master record in the F0901 table.

In final mode, this report updates the F0911 table with the company number from the account master record in the F0901 table.

Companies in Balance (R097001)

This report indicates the net balance for each company. When a company is in balance, the columns on the report are blank.

Intercompany Accounts in Balance (R097011)

This report lists imbalances between corresponding intercompany accounts.

If you have multiple companies with different base currencies, do not run this integrity report. This integrity report does not accommodate different base currencies.

Account Balance to Transactions (R09705)

This report lists imbalances between the F0902 and F0911 tables by fiscal period.

If imbalances exist between these tables, and you change an account from monetary to nonmonetary or vice versa, contact the Global Support Services consultant for a resolution plan.

Foreign Account Balances (R09707)

In proof mode, this report compares foreign currency ledger (CA) records with domestic ledger (AA) records in the F0902 table and prints a report that indicates CA records that do not have corresponding AA records.

In final mode, this report removes from the F0902 table CA records that do not have a corresponding AA record.

Cash Basis Integrity Test (R11C750)

This report identifies cash accounts that have different balances in the domestic ledger (AA) and cash basis ledger (AZ) after posting.

This integrity report can be accessed only from the Cash Basis Accounting menu (G09314).

F70404 to F0911 Integrity (R74701)

In proof mode, this report compares records in the F0911 table with the F70404 table.

In final mode, this report creates an adjusting amount in the F70404 table to balance to the F0911 table.

F74411 to F0411 Integrity (R74703)

In proof mode, this report compares records in the F0411 table with the F74411 table.

In final mode, this report creates an adjusting amount in the F74411 table to balance to the F0411 table.

F0911 Transaction Report (R127012)

This report prints transactions from the F0911 table for accounts within the AAI item FX range.

Unposted F0911 Transactions to F1202 (R12301)

This report compares unposted transactions in the F0911 table to unposted balances in the F1202 table for accounts within the AAI item FX range and prints differences on a report.

F0911 to F1202 Integrity (R12910)

In proof mode, this report compares posted transactions with (batch rear end = *) in the F0911 table with posted balances in the F1202 table.

In final mode, this report creates an adjusting amount in the F1202 table to balance to the F0911 table. This integrity report is the same program as the Fixed Asset Repost.

Note. If you summarize the depreciation transactions, do not run this integrity report. Running this integrity report serves no purpose because Summarized transactions have F1202 records without supporting F0911 transactions. After you summarize transactions, you cannot recreate detail transactions.

F1202 to F0902 Integrity (R127011)

This report compares posted balances in the F1202 table with posted balances in the F0902 table and prints differences on a report.

F5144/F5145 to F0902 (R51800)

In proof mode, this report compares records in the F0902 table with records in the F5144 and F5145 tables.

In final mode, this report creates adjusting amounts in the F5144 and F5145 tables to balance to the F0902 table.

CO/PCO (F5315/F5314) Integrity (R53701)

This report compares final and quoted amounts for cost, revenue, and subcontract records in the F5315 table with the attached planned change orders in the F5314 table and prints the differences.

PCO/CR (F5314/F5311) Integrity (R53702)

This report compares final and quoted amounts for cost, revenue, and subcontract records in the F5314 table with the attached change requests in the F5311 table and prints the differences.

Commitment Integrity Report (R40910)

In proof mode, this report compares records in the F43199 table to the F4311 table and records in the F43199 table to the F0902 table, and then prints the differences.

In final mode, this report creates an adjusting amount in the F43199 table if a difference exists between the amounts in the F4311 and F43199 tables. Creates an adjusting amount in the F0902 table if a difference exists between the amounts in the F43199 and F0902 tables.

Item Ledger/Account Integrity (R41543)

This report compares records in the F0911 table to the F4111 table and prints differences on a report.

Item Balance/Ledger Integrity (R41544)

This report compares records in the F41021 table to the F4111 table and prints differences on a report.

Cost Component/Ledger Integrity (R30543)

This report compares the sum of the frozen standard cost components to the unit cost in the F4105 table and prints a report that indicates the variances.

Batch to Detail/Out of Balance (R007031)

This report locates batches that were posted out of balance and prints a detailed report. Compile a list of any batches that were intentionally posted out of balance and use the list to compare the results after the conversion.

Note. Run this report after you run the postconversion integrity reports for all other systems and before you run the Repost Account Ledger program (R099102).