ERP Implementation Partner Selection Tips and eBook
How to Find the Right ERP Implementation Partner Working with the right ERP implementation partner will be critical to the success of your ERP...
4 min read
Sage 300 Consultant: Running Data Integrity Checks in Sage 300 (formerly Accpac)
Maintaining your data integrity in Sage 300 on a routine basis may feel a little like going to the doctors for a check up when your not feeling sick. Preventative maintenance is critical to making sure your systems runs optimally. More importantly, data integrity checks helps fix small bugs or glitches don't become a much bigger pest or crash your system. When it comes to data integrity "an ounce of prevention is worth a pound of cure." We have run across some Sage 300 customers who have put off this essential task because it can be time consuming depending on the size of your data files. Hopefully, your data integrity plan is prioritized right along with your backup plan. Be sure to follow these steps when maintaining your data integrity. Hopefully, this article will help you avoid unproductive and expensive disasters in the future.
Whether you have data integrity procedures in place or not, it's not too late to get started. Please review these steps to make sure your data is not compromised and is protected. As always, if you have questions about the content of this blog, contact your certified Sage 300 consultant. If you are unsure about the instructions or do not work with a certified Sage 300 consultant, please feel free to contact us.
9 Tips for Running Data Integrity Checks in Sage 300
1. Fix problems while they are small – If you run data integrity on a regular basis, you can find and fix problems while they are still small and manageable so you avoid a data crash.
Note: Sometimes the smallest error in data integrity can be caused by something big happening (e.g. server communication issues, running out of space on a server, a glitch in the hardware and/or software). These issues need to be identified and fixed before they turn into a server crash. If you have a backup, the recovery time for a data crash is 1-2 days; without a backup, it’s 5-10 days.
2. Identifying incorrect procedures - If you run data integrity on a regular basis, you will quickly discover if your users are properly inactivating records, deleting and/or updating information.For example, if you inactivate a customer in Accounts Receivable, and don’t inactivate any corresponding Ship To Locations, you will cause a data integrity error. This error is easily fixable, but it’s important to notify your staff as quickly as possible about changes they need to make to their procedures before one small error becomes thousands of records that need to be fixed.
3. Save time and money – When you are proactively keeping your data clean, your upgrade process will be less expensive. If the data is corrupted in your accounting system, it will need to be fixed before an upgrade will successfully run. Thereby costing you more time and money.
2. Identifying incorrect procedures - If you run data integrity on a regular basis, you will quickly discover if your users are properly inactivating records, deleting and/or updating information.For example, if you inactivate a customer in Accounts Receivable, and don’t inactivate any corresponding Ship To Locations, you will cause a data integrity error. This error is easily fixable, but it’s important to notify your staff as quickly as possible about changes they need to make to their procedures before one small error becomes thousands of records that need to be fixed.
3. Save time and money – When you are proactively keeping your data clean, your upgrade process will be less expensive. If the data is corrupted in your accounting system, it will need to be fixed before an upgrade will successfully run. Thereby costing you more time and money.
4. Make sure you have a backup! Whenever you are running a large process in Sage 300, it is important to verify that you have a good backup of your database before you proceed.
5. Make sure everyone else is out of Sage 300 before you start – Data Integrity can be a performance hog, so we recommend that you run it after hours. Otherwise, it can affect performance for everyone on that server.
6. Do not select the ‘Fix option’ check-box!!! Please contact your Front Line consultant before checking this box! We have had situations where a client ran data integrity with the fix option checked, and the system found orphan transactional records. Instead of fixing the orphan records it deleted them entirely from the system – causing huge transactional discrepancies.
7. Set your print destination to preview before you run data integrity - Once data integrity is complete, the system will print a report showing you what errors it has found. By setting your print destination to preview, you can then export the report to pdf.
5. Make sure everyone else is out of Sage 300 before you start – Data Integrity can be a performance hog, so we recommend that you run it after hours. Otherwise, it can affect performance for everyone on that server.
6. Do not select the ‘Fix option’ check-box!!! Please contact your Front Line consultant before checking this box! We have had situations where a client ran data integrity with the fix option checked, and the system found orphan transactional records. Instead of fixing the orphan records it deleted them entirely from the system – causing huge transactional discrepancies.
7. Set your print destination to preview before you run data integrity - Once data integrity is complete, the system will print a report showing you what errors it has found. By setting your print destination to preview, you can then export the report to pdf.
Note: Review the report, looking specifically for any errors mentioned. If you know how to fix the errors, please do so. But if you have any questions about what the report says, please email the report to your Front Line consultant so they can help you determine the best strategy for fixing the errors. While it is very rare for someone to run data integrity and not see at least a few errors, it is important to stay on top of the errors and keep your data as clean as possible.
8. Front Line Systems highly recommends the TaiRox Fast Data Integrity software – The standard data integrity in Sage 300 can take quite a long time to run, depending on the size of your database. Which is why we highly recommend the TaiRox Fast Data Integrity software solution. It is reasonably priced at $800 and can run the same data integrity in very little time. We ran the standard Sage 300 data integrity against one module for a client and it took 2 hours to run. The TaiRox Data Integrity did the same job in 20 seconds. The error messages are practically identical. (Don Thompson who created the TaiRox software was one of the original architects of Sage 300.) We recommend that all Front Line Systems clients use this software for their data integrity checks.
9. Please run data integrity routinely – If you have a larger database, you may want to look into TaiRox’s Data Integrity Software. Whether you choose to use the standard Sage 300 data integrity checker in Sage 300 or TaiRox's solution, we suggest you check with your Sage 300 consultant on how often you should run the data integrity check for all your modules.
9. Please run data integrity routinely – If you have a larger database, you may want to look into TaiRox’s Data Integrity Software. Whether you choose to use the standard Sage 300 data integrity checker in Sage 300 or TaiRox's solution, we suggest you check with your Sage 300 consultant on how often you should run the data integrity check for all your modules.
For more information on how to proactively take care of data integrity in your Sage 300 system, contact Front Line Systems at 866-435-0243 or visit us at www.flsinc.net. We look forward to serving you.
About Front Line Systems
Front Line Systems is an ERP consulting firm (specializing in Sage 300) with headquarters in Minneapolis, Minnesota. We are passionate about helping businesses solve their accounting, CRM, manufacturing and warehouse concerns. We believe that your business has an amazing capacity for innovation and growth, and that technology can help you realize that capacity. Front Line Systems is a technology partner that solves problems and creates solutions for the life of your business.
We provide Sage 300 support (including implementation, support and consulting services) in Minnesota, Wisconsin, Virginia, DC, Maryland and Connecticut (New England). We serve clients across the US. Contact Front Line Systems at 866-435-0243 or visit us online at www.flsinc.net. We look forward to serving you.
Another version was posted on Front Line Systems blog on September 28, 2016 - What You Need to Know About Data Integrity in Sage 300
Photo courtesy of freedigitalphotos.net
Are You Outgrowing Your ERP Manufacturing Software?
3 Tips for Finding the Best ERP Manufacturing Software for Your Business If your manufacturing company is outgrowing your software the search for...
5 Ways a New Manufacturing ERP Helps Your Business Grow
Grow Your Business with a New Manufacturing ERP Solution The economy is constantly changing, and manufacturing companies have been hit hard by recent...