Run Sage 50 Data Verification

Sage 50 US Data Verification is a diagnostic feature that checks your company data for data reliability and data access issues. Without verification, underlying Sage 50 data errors can cause incorrect or inaccessible records, transaction issues, or repeated errors during accounting tasks. Running the verification helps determine whether the company data requires further troubleshooting or repair. Sage 50 may display messages such as

Price List Index and data files are out of sync”

“I/O Error in the file [directory]\ [dat file]”

“Connection to the Sage Data Service has been lost”

“Queue.dta is in use”

These messages do not necessarily mean the data is permanently damaged, but they indicate that you should check the company data and review the Sage 50 US Data Verification error log. In this guide, we’ll discuss when to run Sage 50 US company Data Verification, what it checks, how to prepare for the verification, how to run it, how to review the error log, and what to do if Sage 50 finds errors.

When Should You Run Sage 50 US Data Verification?

Run Sage 50 Data Verification when you suspect missing or damaged company data, encounter data-related issues, or need to verify Sage 50 data during year-end processing. Here are the key situations when you should run Sage 50 US Data Verification:

• During Year-End Closing
• When Sage 50 Reports Missing or Damaged Data
• When You Suspect Data File Corruption
• When Sage 50 Shows Data-Related Errors
• When Sage 50 Has Difficulty Accessing Company Data
• When Data Reliability or Data Access Issues Are Suspected
• After Restoring a Backup Following a Data Problem
• After a Failed or Interrupted Year-End Process
• When Sage Customer Support Recommends Verification
• As Part of Periodic Data Maintenance

What Does Sage 50 US Data Verification Check?

Sage 50 US Data Verification checks your company data for reliability and access issues, identifying problems that could affect your accounting records. Here are the key checks performed during Sage 50 US company data verification:

• Data Reliability

Checks company files for missing, damaged, incorrectly formatted, truncated, oversized, or duplicate records and identifies data inconsistencies.

• Data Access

Verifies that Sage 50 can locate and access the required company files through the configured data path.

• Data Read and Write Capability

Tests whether Sage 50 can successfully read from and write to the company data files.

Common Sage 50 Data Verification Problems

Sage 50 Data Verification problems can cause freezes, error messages, incorrect balances, missing records, and issues accessing or reading company data. Here are the common Sage 50 US Data Verification errors:

• Sage 50 freezes or closes unexpectedly during data verification
• Error messages report damaged, missing, or unreadable data
• Reports display incorrect balances or unexpected totals
• Drop-down lists appear blank or fail to load expected entries
• Specific fields display unusual or corrupted characters
• Customer, vendor, or transaction records are missing or fail to open
• Data Verification detects damaged or incomplete company files
• Sage 50 reports data reliability or formatting issues
• Sage 50 cannot access required company data files
• Data Verification leaves unresolved errors that require further investigation

What to Do Before Running Data Verification in Sage 50 US?

Before running Sage 50 Data Verification, back up your company, confirm the correct data location, and ensure Sage 50 US can access the required files without interference. Here are the essential steps to complete before running Data Verification:

Parameters	Details
Back Up Your Sage 50 Company	Create a current backup of your company data, so you have a recovery point if verification identifies a problem.
Use the Computer Hosting the Sage 50 Data	Run the verification from the computer that stores or hosts the Sage 50 company data, especially in a network environment.
Confirm the Required Access and Setup	Make sure Sage 50 can access the correct company data path and that no other users are actively working in the company file.
Understand Your Company Data	Know where Sage 50 stores the company files and understand the records and data involved before you begin verification.
Check Data Completeness	Review important records for missing essential information, such as IDs, dates, names, or other required fields.
Review a Data Sample	Examine a representative set of records to identify obvious inconsistencies before running the full verification.
Establish Data Quality Rules	Define the expected data formats, field types, and valid ranges so you can recognize inconsistencies identified during troubleshooting.
Assign Data Responsibility	Identify the team members responsible for reviewing data issues and correcting problems at their source.

How to Run Data Verification in Sage 50 US?

To run Data Verification in Sage 50 US, first change the accounting period, then open File > Data Verification, select Both Tests (recommended), back up your data, and review the error log after verification. Here are the proven steps to run data verification in Sage 50 US.

Step 1: Change the Accounting Period

• Go to Tasks > System > Change Accounting Period. You can also select the accounting period displayed in the top ribbon.
• Choose the accounting period you want to open and click OK.
• When prompted to print invoices or checks, select No unless you need to complete this task first.
• When asked whether you want to print reports, select No unless required.
• When prompted to run an Internal Accounting Review, select No unless you need to perform the review.
• Sage 50 switches the company to the selected accounting period.

Step 2: Run Data Verification and Review the Error Log

• Go to File > Data Verification from the Sage 50 menu.
• Select Both Tests for a complete verification and click Start.
• Choose Backup, select Save, and allow Sage 50 to complete the backup. Data Verification starts automatically after the backup is complete.
• When the verification process finishes, select View the Error Log to review any reported issues and changes.
• Click Close after reviewing the error log.
• Change the accounting period back to the period you normally use.

Sage 50 US Data Verification vs. Sage 50 Data Integrity Check

Sage 50 US Data Verification checks company data for reliability and access issues, while Data Integrity Check provides advanced tests for investigating and repairing specific data problems. Here is the comparison between Sage 50 US Data Verification and Sage 50 Data Integrity Check.

Parameter	Data Verification	Sage 50 Data Integrity Check
Purpose	Checks company data for missing or potentially damaged files and verifies that Sage 50 can access the required data.	Performs advanced tests to identify and address specific data integrity problems.
When to use	Use it when you need to verify the reliability or accessibility of your company data or when Sage Support instructs you to run it.	Run it only when a Sage Customer Support analyst determines that an Integrity Check is necessary.
Who should run it	The utility is available to Sage 50 users, but Sage recommends contacting Customer Support before running the tests.	Run it only with guidance from Sage Customer Support. The support analyst determines which test to perform.
What it checks	Performs Data Reliability and Data Access tests to evaluate company files and their accessibility.	Provides File Tests, Data Synchronization Tests, and Invoice/Payment Synchronization Tests for more advanced data troubleshooting.
Changes to data	Sage 50 may make certain changes during verification and records those changes in the verification error log.	Some tests can modify or synchronize company data, so incorrect use can affect the data.
Backup requirement	Create a backup before running Data Verification to provide a recovery point if the process encounters a problem.	Create a backup before running an Integrity Check because the repair process can make changes to company data.
How to access	Open the company and select File > Data Verification.	Access Integrity Check through Sage 50’s support utilities after receiving appropriate guidance from Sage Support.

What to Do If Sage 50 US Data Verification Finds Errors

If Sage 50 US Data Verification finds errors, review the Data Verification Error Log to identify the errors and changes made during verification, then take the appropriate corrective action or contact Sage Customer Support for further assistance. Here are the steps to follow when Sage 50 US Data Verification finds errors.

• Review the Error Log

Open the Data Verification error log or DATALOG.TXT in the company data directory. Review the errors found, changes made, and any corrupt records deleted during verification.

• Run Verification on the Host Computer

If you ran Data Verification from a workstation, run it from the server or computer that hosts the Sage 50 company data. This helps ensure Sage 50 works directly with the company data files.

• Restart Sage 50 and Check the Company

Close Sage 50 completely, restart the computer, and reopen the company file. Check whether the original data issue still occurs.

• Keep a Pre-Verification Backup

Retain the backup created before running Data Verification. Use it as a recovery point if the verification process produces unexpected results.

• Check for Significant Data Changes

Review your financial reports if the verification process reports changes to your company data. If the reports change unexpectedly, avoid making additional data changes until you determine the cause.

• Contact Sage Support for Serious or Unresolved Errors

Contact Sage Customer Support if the error log contains extensive errors, financial reports change unexpectedly, or Sage 50 cannot resolve the data problem.

Note: Do not run Integrity Check on your own, as Sage recommends using that utility with Customer Support guidance.

How to Review the Data Verification Error Log in Sage 50 US?

To review the Sage 50 US Data Verification error log, open the generated DATALOG.TXT file to see the errors detected, verification times, and changes made during the process, including any corrupt records deleted. Here are the steps to review the Data Verification error log in Sage 50 US.

• From the Windows Start > Programs menu, open Windows Explorer.
• Go to the folder containing your Sage 50 company data.
• Locate and double-click DATALOG.TXT.
• The Data Verification Error Log opens in Windows Notepad.

Final Words

To run Sage 50 Data Verification, back up your company data, open File > Data Verification, select the appropriate verification tests, run the process without interruption, and review the results and error log. Sage 50 uses Data Reliability and Data Access tests to identify data problems and access issues, while unresolved problems may require guidance from Sage Customer Support. Following these steps helps you verify Sage 50 data, identify potential Sage 50 US data verification errors, review changes made during verification, and determine whether you need further troubleshooting or an Integrity Check.

Frequently Asked Questions: