Understanding the Commitment Integrity Report
You can generate a Commitment Integrity Report (R40910) to compare the open order amounts against the committed amounts and amount balances and to review any variances.
Use the Commitment Integrity Report program (R40910) to indicate variances among these tables:
F4311
F43199
F0902
Two comparisons are made to identify out-of-balance conditions between files.
The detail file and the audit file are compared on a to-date basis, which means that all data in the files is summed regardless of date. The detail file is not date sensitive and does not contain information such as when you made changes to the open amount.
The system compares the audit file and the balances file on a through-period-end basis. The system uses the date that you enter for the first processing option to determine the period end date to use. This comparison is period-sensitive because that is the lowest level of detail stored in the balances file.
The columns under Balance to Date on the left side of the report are Purchase Order Detail File, P.O. Detail Ledger File - Flexible Version, and Variance. The amounts reported by account number and subledger are:
Open amount in the detail file.
Total of the commitment audit trail transactions.
Difference between the two columns.
The columns under Balance as of xx/xx/xx on the right side of the report are P.O. Detail Ledger File - Flexible Version, Account Balances, and variance. The amounts reported by account number and subledger are:
Total of the Commitment Audit Trail transactions.
Account Balances total.
Difference between the two columns.
Variances occur between the F4311 table and the Commitment Audit Trail under these conditions:
Unposted receipt or voucher batches.
To confirm that all O and V batches are posted, run the Unposted Batches report (R007011).
Subcontracts on budget hold.
The system does not create a commitment until a subcontract is released from budget hold.
If you find an inconsistency in the commitments that cannot be resolved, you can correct the information in the PA ledger. All entries in the PA and PU ledgers are based on the F4311 table. You can rebuild this information from the F4311 table and correct any inconsistencies in the F0902 table.