Integrity Checks

Almost every Solomon module has the options called integrity checks.  The tools in this section vary from verify/ check routines for customer balances/ vendor balances to rebuild vendor/customer balances from documents.  Clearly the rebuild tools are  very powerful. Yet these tools can be very dangerous.

Here is an example of the Accounts Receivable Integrity Checks screen:

By dangerous, I mean, the rebuild tools depend on complete or at least consistent detail for the document and transaction files for the modules.  The problem, as I see it, is that it is difficult to know if your data is consistent and complete before you start a rebuild process.  Errors have a way of creeping in to accounting systems. 

Partial lists of reasons errors creep in include:

1) When you started your accounting system in the very beginning did you create the outstanding balances with normal Solomon data entry screens or did you use the initialization process to create initial balances?  Unfortunately, other than notes or a great memory, it is virtually impossible to know how things were done in the start up process.  Yet if there are no transactions in your history files, there can be no ability to complete rebuilt document history.

2) A suspended batch, power interruptions, version upgrades, and 'back door’ use of sql utilities can all contribute to inconsistent document history. Once again, inconsistent document history can lead to incorrect rebuilding of totals.

So a word to the wise is be careful when running these utilities.  Always back up, and use the error message logs created by the verify process to check for clues as to what is wrong.  I strongly recommend running the integrity check reports in the verify mode, then checking with your main Solomon support source to help you determine the corrective actions you should take.  When you run the reports in the verify mode, there is an event file created which summarizes the results.  This event file can be viewed by:  clicking on Utilities, then event log viewer , then select the desired line.

Our company has significant experience in cleaning up reported errors.

This is a service we can provide via remote support.