The best method of ensuring consistency when it comes to business data would be to use a data validation process. This can be set up as a standardized user interface that runs business logic routines. Within the data validation methods, you can have the methods listed below.
• Batch Totals: This allows a program to check for missing records.
• Cross-system consistency: The system you set up can check to ensure consistent data in the fields are filled in properly.
• Logic Checks: A program that checks the input for logical errors.”