Ask Denovo is revisiting the integrities but this time with AP and AR. All integrities are checking posted transactions only. And keep these key points in mind for all integrities:
-> Submit one integrity report at a time.
-> Run integrity reports when other users are not accessing the system to ensure accuracy.
-> Run integrity reports weekly so that you do not risk compromising your accounting data.
The links to the Doc ID’s step through each integrity, possible causes, and ways to correct issues.
Accounts Payable (Doc ID # 1407766.1):
1. AP Orig Doc to GL by Batch Report (R04701)
2. AP Payments to GL by Batch Report (R04702A)
3. A/P to G/L Integrity with Adjustments Report (R04711)
4. A/P Payments to G/L Integrity with Adjustments Report (R04712)
5. AP to GL by Offset Account Report (R047001A)
6. AP Payments to AP with Update Report (R04713)
Accounts Receivable (Doc ID # 2242260.2):
1. AR to Account Balance by Account ID (R03B707)
2. AR to GL by Batch Integrity Report (R03B701)
3. F03B11 to F0911 Integrity (R890911AI)
4. F03B11 to F03B14 Integrity (R8903B14I)
5. F03B13 to F0911 Integrity (R890911CI)
6. AR to GL Receipts by Batch (R890911BI)
7. F03B11 to F03B22 Integrity (R8903B22I)
8. F03B11 to F03B40 Integrity (R8903B40I)
9. F03B14 to F03B13 Integrity (R8903B13I)
10. F03B22 to F03B23 Integrity (R8903B23I)
Oracle provided this great flow in Doc ID # 2242260.2 of how the AR Integrities should be run including the use of General Accounting integrities R007011, R007021, and R007031:
Want to see your question answered in the series, or just want to subscribe for alerts on future issues? Simply fill out the form below!