An often forgotten about process during ERP implementation, but nonetheless important, is data cleansing. One main reason most companies decide to upgrade to a new ERP system, or implement one for the first time, is usually to take advantage of good data systems and use them for forecasting and planning. Unfortunately, those data systems are only useful when the data flowing into them is up to date and relevant.
Data cleansing ensures that you’re going to get the most out of your new ERP system, especially if you’re hoping to use its prediction analytics to the fullest. This process can be long and tedious but will pay off in the end. The task is also often underestimated. Usually, data is spread across multiple systems or spreadsheets and it is hard to realize how much of it there really is when it’s not all in one place.
Deciding whether you need to tackle all those separate spreadsheets and systems can be difficult. Some companies even sit in denial simply because it is too hard to fathom going through all that information. Here are some questions to ask yourself to decide whether it is time.
Have you forgotten to delete any price quote entries?
Do you have any duplicate supplier or customer accounts?
Have any old product codes that are no longer in use still in the system?
Is there any critical data sitting in a spreadsheet that isn’t in your ERP system?
Answering yes to any of these questions means you’re probably ready for some data cleansing and consolidating. Now it’s time to figure out where you’re going to begin. This can be difficult when you’re in many different systems. Here are some good places to start:
Consolidate any data that might be duplicate information, such as addresses you might have saved under different names like “East Center Street”, “E. Center Street”, “E. Center St.” and “East Center St.”
Regularly meet with co-workers who will be data cleansing with you to discover where you might be bottlenecking or facing problems
Establish a completion date
The hardest part of data cleansing is simply getting started. Once your data is spruced up, however, your ERP system will be able to live up to your expectations.
8 TIPS FOR ERP EVALUATION
We’ve developed these 8 tips to help navigate the many choices for ERP selection.Learn More Here
Contact us to learn more about our passion for solving problems and how it drives us to deliver innovative solutions for everyone we work with!
In a simple sense, inventory optimization is what you get when you strike a balance between having enough inventory to satisfy your customer service standards while stocking as little inventory as possible. Customer service standards involve meeting demand—but not past the point that you have too much. But inventory optimization gets complicated when supply and
To keep a close eye on cash flow, most companies opt for some form of accounting software. By tracking money coming in versus money going out, accounting departments use accounting solutions to spot trends, uncover losses and otherwise make necessary financial decisions and adjustments to not only remain in the black, but to stay open