Description of Individual Integrity Checks
The following lists the integrity checks by module, and offers you a detailed description about each test the system performs using Organization>Data Integrity Checks. You will only see checks for the modules you have installed and added to the current organization.
General Ledger Balance Records are in Balance: Each General Ledger balance record is first grouped according to its effective date and entry type. Then, the sum of credits and debits are compared. When credits equal debits, the test will PASS; otherwise, it will FAIL.
General Ledger Detail Records are in Balance: Each General Ledger detail record is first grouped according to its Effective Date and Entry Type. Then, the current amount field will be totaled. If the total is equal to zero the test will PASS. Otherwise, it will FAIL.
General Ledger Balance Records have Corresponding Detail Records: Each General Ledger balance record is first grouped according to its Effective Date, Entry Type (limited to Normal "N" and Adjust Opening Balance "AO" types), and Account Code. Then, the current amount field will be totaled. All matching detail records will be grouped and compared to each balance record. If the total of the current amount fields net to zero, and the Account Codes are identical, the test will PASS; otherwise, it will FAIL.
General Ledger Detail Records have Corresponding Balance Records: Each General Ledger detail record is first grouped according to its Effective Date, Entry Type (excluding any System Opening "SO" types), and Account Code. All matching balance records will be grouped in the same way and compared to each detail record. The Account Codes must be identical for the test to PASS; otherwise, it will FAIL.
General Ledger Detail and Balance Record Amounts Agree: Each General Ledger balance record is first grouped according to its Effective Date, Entry Type (excluding any System Opening "SO" types), and Account Code. Then, credit and debit amounts are totaled. All matching detail records will be grouped and the current amount is totaled. The total of the detail record's current amount must equal the balance record's net of credits and debits for the test to PASS; otherwise, it will FAIL.
Fund and Balancing Segment Balance Records are in Balance: Each Fund and Balancing Segment Balance record is first grouped according to its Effective Date, Entry Type, and Account Code. Then, the sum of credits and debits are compared. If credits equal debits, the test will PASS; otherwise, it will FAIL.
Fund and Balancing Segment Detail Records are in Balance: Each Fund and Balancing Segment detail record is first grouped according to its Effective Date, Entry Type and Account Code. Then, the current amount field will be totaled. If the current amount field equals zero, the test will PASS; otherwise, it will FAIL.
Check All Segment Detail Records for Blank Account Codes: Each General Ledger, Fund, and Balancing Segment detail record must have a valid Account Code. If the Account Code exists for all detail records, the test will PASS; otherwise; it will FAIL.
Check All Segment Balance Records for Blank Account Codes: Each General Ledger, Fund, and Balancing Segment balance record must have a valid Account Code. If an Account Code exists for all balance records, the test will PASS; otherwise, it will FAIL.
Check Non-Balancing Segment Revenue and Expense Detail Records for Blank Account Codes: Each Non-Balancing Segment revenue and expense detail record must have a valid Account Code. If an Account Code exists for all Non-Balancing detail records, the test will PASS; otherwise, it will FAIL.
Check Non-Balancing Segment Revenue and Expense Balance Records for Blank Account Codes: Each Non-Balancing Segment revenue and expense balance record must have a valid Account Code. If an Account Code exists for all Non-Balancing balance records, the test will PASS; otherwise, it will FAIL.
Check Restrictions Segment Revenue, Expense, and Equity Detail Records for Blank Account Codes: Each Restricted Segment revenue, expense, and net equity/asset detail record must have a valid Account Code. If an Account Code exists for all restricted detail records, the test will PASS; otherwise, it will FAIL.
Check Restrictions Segment Revenue, Expense, and Equity Balance Records for Blank Account Codes: Each Restricted Segment revenue, expense, and net equity/asset balance record must have a valid Account Code. If an Account Code exists for all restricted balance records, the test will PASS; otherwise; it will FAIL.
All Document ID Records must have Supporting Detail Records: Each Document ID record must have a supporting record of detail. If a detail record exists for each document ID found, the test will PASS; otherwise, it will FAIL.
All Detail Records must have Supporting Document ID Numbers: Each detail record must have a supporting Document ID number. If a document ID exists for each detail record found, the test will PASS; otherwise, it will FAIL.
Detail Transaction Totals are in Balance by Document and Session Records: The amount of each credit detail record must equal the amount of the debit detail record for the same Document and Session. If the total amounts are in balance, the test will PASS; otherwise, it will FAIL.
Accounts Payable Records Reconcile to General Ledger Balance Records: Each Accounts Payable record in the General Ledger balance table should have a reconciling record in the Accounts Payable transactions table (excluding all System Opening "SO" records). If the total of Accounts Payable records in the General Ledger equal the sum of those in the Accounts Payable, the test will PASS; otherwise, it will FAIL.
Accounts Payable Transaction Records have a Supporting Document Record: Each Accounts Payable transaction record should have a matching record in the Accounts Payable open document. If matching Accounts Payable document IDs are found in the Accounts Payable open document table, the test will PASS; otherwise, it will FAIL.
Accounts Payable Transaction Record Amounts Reconcile to Document Record Amounts: The amount of the Accounts Payable transaction records (grouped by document ID, document number, and vendor) should be equal to the current amount of the Accounts Payable open document record. If the total of the transactions records are equal to the current amount of the open document record (excluding zero balances), the test will PASS; otherwise, it will FAIL.
Detail Records Reconcile to Accounts Payable Transaction Record Amounts: The sum of the Accounts Payable detail records (grouped by detail document number and vendor) should be equal to the sum of the Accounts Payable open document records. If the total of the detail records are equal to the current amount of the open document record, the test will PASS; otherwise, it will FAIL.
Open Accounts Payable Beginning and Ending Dates Match Dates in Detail Records: The beginning and ending dates of the Accounts Payable open document records (grouped by document ID, document number, and vendor) should match the beginning and ending dates of the similarly grouped detail records. If beginning and ending dates match, the test will PASS; otherwise, it will FAIL.
Open Accounts Payable Records Match Document Detail Records: The document ID of the Accounts Payable open document records (grouped by document ID, document number, document date, and vendor) should match the detail document ID in the detail records. If they match, the test will PASS; otherwise it will FAIL.
Check All Segment Open Accounts Payable Transactions Records for Blank Account Codes: Each General Ledger, Fund, and Balancing Segment in the Accounts Payable open transaction table must have a valid Account Code. If an Account Code exists for all open transactions records, the test will PASS; otherwise, it will FAIL.
Check Non-Balancing Segment Revenue and Expense Open A/P Transactions Records for Blank Account Codes: Each Non-Balancing Segment Revenue and Expense record in the Accounts Payable open transaction table must have a valid Account Code. If an Account Code exists for all open transactions records, the test will PASS; otherwise, it will FAIL.
Check Restrictions Segment Revenue, Expense, and Equity Open A/P Transactions Records for Blank Account Codes: Each Restrictions Segment Revenue, Expense, and Net Equity/Asset record in the Accounts Payable open transaction table must have a valid Account Code. If an Account Code exists for all open transactions records, the test will PASS; otherwise, it will FAIL.
Accounts Receivable Records Reconcile to General Ledger Balance Records: Each Accounts Receivable record in the General Ledger balance table should have a reconciling record in the Accounts Receivable transactions table (excluding all System Opening "SO" records). If the total of Accounts Receivable records in the General Ledger equal the sum of those in the Accounts Receivable, the test will PASS; otherwise, it will FAIL.
Accounts Receivable Transaction Records have a Supporting Document Record: Each Accounts Receivable transaction record should have a matching record in the Accounts Receivable open document. If matching Accounts Receivable document IDs are found in the Accounts Receivable open document table, the test will PASS; otherwise, it will FAIL.
Accounts Receivable Transaction Record Amounts Reconcile to Document Record Amounts: The amount of the Accounts Receivable transaction records (grouped by document ID, document number, and vendor) should be equal to the current amount of the Accounts Receivable open document record. If the total of the transactions records are equal to the current amount of the open document records (excluding zero balances), the test will PASS; otherwise, it will FAIL.
Detail Records Reconcile to Accounts Receivable Transaction Record Amounts: The sum of the Accounts Receivable detail records (grouped by detail document number and vendor) should be equal to the sum of the Accounts Receivable open document records. If the total of the detail records are equal to the current amount of the open document record, the test will PASS; otherwise, it will FAIL.
Open Accounts Receivable Beginning and Ending Dates Match Dates in Detail Records: The beginning and ending dates of the Accounts Receivable open document records (grouped by document ID, document number, and vendor) should match the beginning and ending dates of similarly grouped detail records. If beginning and ending dates match, the test will PASS; otherwise, it will FAIL.
Open Accounts Receivable Records Match Document Detail Records: The document ID of the Accounts Receivable open document records (grouped by document ID, document number, document date, and vendor) should match the detail document ID in the detail records. If the document ID of the open Accounts Receivable record matches the detail record document ID, the test will PASS; otherwise, it will FAIL.
Check All Segment Open Accounts Receivable Transactions Records for Blank Account Codes: Each General Ledger, Fund, and Balancing Segment in the Accounts Receivable open transaction table must have a valid Account Code. If an Account Code exists for all open transactions records, the test will PASS; otherwise, it will FAIL.
Check Non-Balancing Segment Revenue and Expense Open A/R Transactions Records for Blank Account Codes: Each Non-Balancing Segment Revenue and Expense record in the Accounts Receivable open transaction table must have a valid Account Code. If the Account Code exists for all open transactions records, the test will PASS; otherwise, it will FAIL.
Check Restrictions Segment Revenue, Expense, and Equity Open A/R Transactions Records for Blank Account Codes: Each Restrictions Segment Revenue, Expense, and Net Equity/Asset record in the Accounts Receivable open transaction table must have a valid Account Code. If the Account Code exists for all open transactions records, the test will PASS; it will FAIL.
Budget Records Reconcile to General Ledger Balance Records: Each Budget record in the General Ledger balance table should have a reconciling record in the Budget transactions table (excluding all System Opening "SO" records). If the total of Budget records in the General Ledger equal the sum of those in the Budget, the test will PASS; otherwise, it will FAIL.
Budget Records Match Document Detail Records: The document ID of the Budget document records (grouped by control ID, document number, and document date) should match the detail document ID in the transaction records. If the control ID of the Budget document record matches the transaction record document ID, the test will PASS; otherwise, it will FAIL.
Encumbrance Records Reconcile to General Ledger Balance Records: Each Encumbrance record in the General Ledger balance table should have a reconciling record in the Encumbrance transactions table (excluding all System Opening "SO" records). If the total Encumbrance record amounts in the General Ledger equal the sum of those in the Encumbrance transactions table, the test will PASS; otherwise, it will FAIL.
Encumbrance Transaction Records have a Supporting Document Record: Each Encumbrance transaction record should have a matching record in the Encumbrance open document. If matching Encumbrance document ID records are found in the Encumbrance open document table, the test will PASS; otherwise, it will FAIL.
Encumbrance Transaction Record Amounts Reconcile to Document Record Amounts: The amount of the Encumbrance transaction records (grouped by document ID, document number, and vendor) should be equal to the current amount of the Encumbrance open document record. If the total of the transactions records are equal to the current amount of the open document record (excluding zero balances), the test will PASS; otherwise, it will FAIL.
Open Encumbrance Beginning and Ending Dates Match Dates in Detail Records: The beginning and ending dates of the Encumbrance open document records (grouped by document ID, document number, and vendor) should match the beginning and ending dates of the similarly grouped detail records. If beginning and ending dates match, the test will PASS; otherwise, it will FAIL.
Detail and Encumbrance Transaction Records Reconcile to Open Encumbrance Record Amounts: The sum of the Encumbrance transaction records (grouped by detail document number and vendor) and the Encumbrance detail records should be equal to the sum of the Encumbrance open document records (to include liquidations processed through Accounts Payable). If the total of the transaction records plus the detail records are equal to the amount of the open document record, the test will PASS; otherwise, it will FAIL.
Open Encumbrance Records Match Document Detail Records: The document ID of the Encumbrance open document records (grouped by document ID, document number, document date, and vendor) should match the detail document ID in the detail records. If the document ID of the open Encumbrance record matches the detail record document ID, the test will PASS; otherwise, it will FAIL.
Check TblOrgDataDictionary for Multiple OR Records: The system verifies that only one OR record is located in the tblOrgDataDictionary. If multiple records are found, a message will display directing you to seek assistance in removing the superfluous record. If only one OR record is located in the tblOrgDataDictionary, the test will PASS; otherwise, it will FAIL.