Check Sales data integrity utility
In SysManager, you can check the integrity of your Sales data by navigating to Utilities > Test Data Integrity. This utility gathers data from the sale_hdr and transact tables for the date range specified, all invoices, accounts, pmt_types and items. It then performs checks on this data and stores all the errors that are found. It does not modify data at all. If it finds errors, it presents a report.
Transact
• Checks all amounts for rounding errors (extension, discount, tax_xmt2, tax_amount, fee_amount, and all pcsplits)
• Checks to make sure the amounts add up to all the profit center splits
• If an invoice number is on the record, it verifies an invoice header exists in invoices.
• Ensures a DCI exists in items
• Ensures an operator is present and exists
• Ensures a sales point is present and exists
• Ensures a timestamp exists
Sale_hdr
• Checks all payment amounts for rounding errors
• Verifies if the payments equal the transact totals
• Verifies all the payment types exist
• Ensures an operator is present and exists
• Ensures a sales point is present and exists
• Ensures a timestamp exists
Invoices
• Ensures there is an account name and that it exists
• Ensures an operator is present and exists
• Ensures a sales point is present and exists
• Ensures a timestamp exists
Note: This report can affect performance of your system, accesso suggests that you perform this operation after business hours.
