The transaction integrity check tool is used to achieve a comprehensive data integrity check of the transactions table. There are 2 types of integrity checks:
- Orphaned Transactions
- Posted Records
Running the integrity checks
- Navigate to the "Integrity Report Entries" Tab. Clear any existing entries. This step is optional, but considered a best practice.
- To run an integrity check, navigate to the "Accounting Settings" tab.
- Click on the "Integrity Reports" sub tab.
- Select the accounting period you wish to run the integrity check for.
- An email notice will be sent to you when the integrity check is complete. Any problem records will be entered as Integrity Report Entries. Navigate to this tab to take next steps.
Orphaned Transactions Check
Transactions without a reference to one of the objects in Table A or B have been orphaned, and are in danger of reporting inaccurate data. The entry into the GL Integrity Check Log would be listed without any reference to the source transaction. The code would read as follows: "The transaction has been orphaned and is in danger of reporting inaccurate results. Please find the transaction and delete it from the transaction log."
Posted Record Integrity Check
This check performs the following tests on the 8 source objects to the transaction table listed in Table A and 4 source objects in the ERP product listed in Table B if applicable. This utility will enter an error record in integrity report entries object if any of the three conditions below are met:
1. The source entry is posted, and has no transactions related to it.
2. The source entry is posted, and the debit entries do not equal the credit entries.
3. Any of the transactions related to a posted source object are missing an accounting period or GL account.
Table A - Core Accounting Source Objects
- Journal Entry Line
- Billing Line
- Cash Receipt
- Billing Cash Receipt
- Account Payable Line
- Cash Disbursement
- Scheduled Revenue Expense
- Time Card Day
Table B - ERP Solution Objects
- Purchase Order Inventory Movement
- Inbound Inventory Movement
- Manufacturing Inventory Movement
- Outbound Inventory Movement