Financial Integrity Reports: различия между версиями
Перейти к навигации
Перейти к поиску
Yarkin.m (обсуждение | вклад) (Новая страница: «==Overall recommended order== #Create Baselines: AP to GL Integrity by Offset Account report (R047001A) as a baseline AR to Account Balance by Account ID (R03B707...») |
Yarkin.m (обсуждение | вклад) |
||
| Строка 1: | Строка 1: | ||
==Overall recommended order== | ==Overall recommended order== | ||
| − | #Create Baselines: | + | # Create Baselines: |
| − | AP to GL Integrity by Offset Account report (R047001A) as a baseline | + | #* AP to GL Integrity by Offset Account report (R047001A) as a baseline |
| − | AR to Account Balance by Account ID (R03B707) as a baseline | + | #* AR to Account Balance by Account ID (R03B707) as a baseline |
| − | Account Balance to Transactions (R09705) as a baseline | + | #* Account Balance to Transactions (R09705) as a baseline |
| − | Repost Account Ledger Report (R099102) as a baseline | + | #* Repost Account Ledger Report (R099102) as a baseline |
#Batch Header integrities: | #Batch Header integrities: | ||
| − | Unposted Batches (R007011) | + | #* Unposted Batches (R007011) |
| − | Transactions to Batch Header (R007021) | + | #* Transactions to Batch Header (R007021) |
| − | Batch to Detail (R007031) | + | #* Batch to Detail (R007031) |
| − | Batches Out of Balance (R007032) | + | #* Batches Out of Balance (R007032) |
#G/L integrities for accounts and companies: | #G/L integrities for accounts and companies: | ||
| − | Transactions without Account Master (R097021) | + | #* Transactions without Account Master (R097021) |
| − | Account Balance without Account Master (R097031) | + | #* Account Balance without Account Master (R097031) |
| − | Accounts without Business Units (R097041) | + | #* Accounts without Business Units (R097041) |
| − | Companies in Balance (R097001) | + | #* Companies in Balance (R097001) |
| − | Company by Batch Out of Balance (R09706) | + | #* Company by Batch Out of Balance (R09706) |
| − | Intercompany Accounts in Balance (R097011) | + | #* Intercompany Accounts in Balance (R097011) |
#A/P integrities: | #A/P integrities: | ||
| − | AP to GL by Batch (R04701) | + | #* AP to GL by Batch (R04701) |
| − | AP Payments to Voucher (R04713) | + | #* AP Payments to Voucher (R04713) |
| − | AP Payments to GL by batch (R04702A) | + | #* AP Payments to GL by batch (R04702A) |
| − | General Journal by Account Report (R09311) for the A/P Trade account(s) with data selection set to Document Type not equal to AE | + | #* General Journal by Account Report (R09311) for the A/P Trade account(s) with data selection set to Document Type not equal to AE |
| − | AP to GL Integrity by Offset Account report (R047001A): compare to its baseline | + | #* AP to GL Integrity by Offset Account report (R047001A): compare to its baseline |
#A/R integrities: | #A/R integrities: | ||
| − | AR to GL by Batch Integrity Report (R03B701) | + | #* AR to GL by Batch Integrity Report (R03B701) |
| − | AR to GL Receipts by Batch (R890911BI) | + | #* AR to GL Receipts by Batch (R890911BI) |
| − | F03B11 to F03B14 Integrity (R8903B14I) | + | #* F03B11 to F03B14 Integrity (R8903B14I) |
| − | General Journal by Account Report (R09311) for the A/R Trade account(s) with data selection set to Document Type not equal to AE | + | #* General Journal by Account Report (R09311) for the A/R Trade account(s) with data selection set to Document Type not equal to AE |
| − | AR to Account Balance by Account ID (R03B707): compare to its baseline | + | #* AR to Account Balance by Account ID (R03B707): compare to its baseline |
#Final G/L integrities: | #Final G/L integrities: | ||
| − | Account Balance to Transactions (R09705): compare to its baseline | + | #* Account Balance to Transactions (R09705): compare to its baseline |
| − | Repost Account Ledger Report (R099102): compare to its baseline | + | #* Repost Account Ledger Report (R099102): compare to its baseline |
Note - The following reports are not dependent on each other, this is only Oracle Support's recommended order. It is important to run each and clean up any discrepancies before running the next report. | Note - The following reports are not dependent on each other, this is only Oracle Support's recommended order. It is important to run each and clean up any discrepancies before running the next report. | ||
Версия 14:10, 16 сентября 2024
Overall recommended order
- Create Baselines:
- AP to GL Integrity by Offset Account report (R047001A) as a baseline
- AR to Account Balance by Account ID (R03B707) as a baseline
- Account Balance to Transactions (R09705) as a baseline
- Repost Account Ledger Report (R099102) as a baseline
- Batch Header integrities:
- Unposted Batches (R007011)
- Transactions to Batch Header (R007021)
- Batch to Detail (R007031)
- Batches Out of Balance (R007032)
- G/L integrities for accounts and companies:
- Transactions without Account Master (R097021)
- Account Balance without Account Master (R097031)
- Accounts without Business Units (R097041)
- Companies in Balance (R097001)
- Company by Batch Out of Balance (R09706)
- Intercompany Accounts in Balance (R097011)
- A/P integrities:
- AP to GL by Batch (R04701)
- AP Payments to Voucher (R04713)
- AP Payments to GL by batch (R04702A)
- General Journal by Account Report (R09311) for the A/P Trade account(s) with data selection set to Document Type not equal to AE
- AP to GL Integrity by Offset Account report (R047001A): compare to its baseline
- A/R integrities:
- AR to GL by Batch Integrity Report (R03B701)
- AR to GL Receipts by Batch (R890911BI)
- F03B11 to F03B14 Integrity (R8903B14I)
- General Journal by Account Report (R09311) for the A/R Trade account(s) with data selection set to Document Type not equal to AE
- AR to Account Balance by Account ID (R03B707): compare to its baseline
- Final G/L integrities:
- Account Balance to Transactions (R09705): compare to its baseline
- Repost Account Ledger Report (R099102): compare to its baseline
Note - The following reports are not dependent on each other, this is only Oracle Support's recommended order. It is important to run each and clean up any discrepancies before running the next report.
