R127013 - G/L to Fixed Assets Integrity Report

This report is the most powerful of the integrity reports. It uses the range of accounts that are defined in the FX AAIs to compare the Account Balances table (F0902) to the Asset Account Balances File table (F1202).

Through processing options, you can:

• Display transaction detail for exception transactions only.

• Display year-to-date or inception-to-date balances with transaction detail.

The system also reconciles any out-of-balance accounts on a transaction-by-transaction basis. When the system locates an out-of-balance account, it determines the difference between the balances and then processes each general ledger detail transaction as if it had been posted to fixed assets. A new difference is calculated for each detail transaction, attempting to reduce the difference to zero. The posting codes for each line also print and enable you to determine exactly which transactions are causing the problem.

To identify the exception transactions, the system compares the G/L Post Code with the Passed Code for each detail transaction from the Account Ledger table (F0911). This table shows the comparison and result:

G/L Post Code	Passed Code	Exception Identification
P	*	OK
P	P	Exception
P	H	Exception
P	Blank	Exception
Blank	*	Exception
Blank	P	These do not cause an imbalance between the Account Balances (F0902) and the Asset Account Balances File (F1202) tables. However, the month-end balances might not be accurate without these postings.
Blank	H	These do not cause an imbalance between the Account Balances (F0902) and the Asset Account Balances File (F1202) tables. However, the month-end balances might not be accurate without these postings.
Blank	Blank	These do not cause an imbalance between the Account Balances (F0902) and the Asset Account Balances File (F1202) tables. However, the month-end balances might not be accurate without these postings.