Select Page
Epicor ERP Data Management Tool, The Tool That Keeps On Giving

Epicor ERP Data Management Tool, The Tool That Keeps On Giving

I like to peruse the Epicor-related message boards on a semi-regular basis. Usually, I’ll find something nice, and occasionally I can help someone with a problem they’re having.

Sometimes, a poster will suggest using DMT to solve a problem and the person says, “We don’t have DMT licensed.” It usually takes me a while to get over the shock.  Well, shock is a strong word. Dismay, disbelief, incredulity, maybe.

 

Epicor’s Data Management Tool is just too handy an appliance for a customer not to have. Sure, there are ways to get data into the ERP system without it.

First, there’s the manual way: put your fingers on the keyboard and get cracking. Your great-great-grandchildren will be colonizing Alpha Ceti 6 before you get done.  Paste insert/paste update is a good way to get certain lists entered, especially for setup tables. Units of measure, FOB, AR Terms, etc. are good uses for this handy functionality.

 

But for crunching in the big stuff like customers, vendors, parts, and manufacturing methods, where the record counts grow, you must have it.  Consider that a typical manufacturer might have 10,000 – 20,000 parts, 25,000 operations and 100,000 bill of material records. This data management software makes this possible in a reasonable time frame.  And it handles the complexity so you don’t have to.

 

Here’s an example. When you enter the bill of operations, it’s one Excel sheet. Epicor ERP’s Data Management Tool in the Epicor 10 upgrade sets up the main record, plus all the default resources, etc. in several tables.  You don’t have to worry about it.

 

DMT interfaces with Epicor’s “business objects” to make sure your data follows the rules.

Try to enter a BOM record without its related operation? No can do. Operation without a part revision? Customer with no sales person set up? Uh-uh. The data has to go in its natural order, just as if you were manually typing away.  DMT respects the logic of the Epicor business objects.

 

With direct SQL updates (just say no), you can unintentionally corrupt your database. While you can add or delete records you don’t mean to (it’s a powerful tool, after all), it’s really hard to damage your database with DMT.

 

Some folks use the DMT as a part of their daily business processing. You can load transactions up in an Excel file, and away you go.  It has great utility “utility,” too. I’ve seen a bad inventory part record where you couldn’t open it in Part Maintenance. Just load it into DMT and update something, the part description maybe. It doesn’t even have to change. Boop! Problem fixed.

 

Not sure you need DMT? Think it’s too difficult to master? Give us a shout. We’ll walk you through its benefits and operation.

 

Learn from our Webinar Replay:

De-Risk Your Epicor ERP upgrade

Author Bio:

Joe Trent is a Senior Consultant with The Estes Group. He has over 35 years of experience in manufacturing and distribution systems, in software development,
implementation and use.

Digital Transformation Warming up to Change and Change Management

Digital Transformation Warming up to Change and Change Management

From Beetles to Butterflies: Why ERP Digital Transformation Matters More Than Ever

Digital butterfly symbolizing transformation in technology and business<br />

“Digital transformation” is a phrase that’s gotten a lot of air time lately—and not without a fair share of suspicion. That’s no surprise. From the moment humans began putting thoughts to paper (or clay or stone), we’ve been wary of change.

Consider the Roman poet Ovid. In Metamorphoses, he catalogs the tragic transformations of mythic figures—humans turned into animals, trees, constellations. These changes weren’t celebrated; they were punishments, warnings, laments. Transformation, in Ovid’s view, was often a fall from grace. I personally wouldn’t mind being a tree, at least until a Roman arborist came lumbering by with an axe and a sense of purpose.

Fast forward to the 20th century and Kafka’s Metamorphosis. One morning, Gregor Samsa wakes up to find he’s no longer a man but a giant, grotesque insect. Yesterday you’re stepping on bugs, and today—you are the bug. Small wonder Kafka didn’t get a lot of Saturday night invitations.

The point is: writers and thinkers have long been skeptical of change. They’ve searched for the timeless, the eternal, the unmoving. ERP digital transformation is the antithesis of that quest. (And for the record, Socrates wasn’t much of a businessman. Just ask Asclepius about the rooster he was owed.)

But business? Business has no such luxury. Businesses can’t afford to romanticize stasis—because stasis doesn’t keep the lights on. In fact, it’s usually what shuts them off.

I once met with a company in the middle of scaling up. “We’re trying to go from being a big little company to a little big company,” one of the leaders told me. That meant changing the way they operated. It meant redesigning business processes. It meant reconfiguring their ERP system to support growth.

Another company I met was struggling through the early phases of an ERP implementation. For decades, they’d relied on paper-based processes—familiar, yes, but unfit for a modern, digital marketplace. Their world had changed: their customers had changed, their suppliers had changed, and they realized they couldn’t keep up without changing too.

For companies like these, digital transformation isn’t an abstract concept. It’s not literary. It’s not philosophical. It’s survival. It’s the practical reality of building the systems today that will support the business tomorrow.

At EstesGroup, we see ERP digital transformation as more than a software install. It’s a reinvention. It’s the restructuring of business processes, data flows, and organizational roles. It’s change that is both technical and cultural.

And yes, it can be painful. Change often is. But we’re here to help guide it.

Sometimes, implementing a new ERP system or redesigning your application architecture feels like being a caterpillar sewing itself into a cocoon. There’s a period of quiet, intense work—then, if all goes well, a butterfly emerges.

Of course, it doesn’t always go well. The risk is that you emerge as something else entirely. Another beetle, perhaps.

But with the right partners, and the right plan, digital transformation can be a true metamorphosis—for the better.

ERP Digital Transformation: From Consultation to Change

If your systems are holding you back, let’s talk. Schedule a free ERP consultation and take the first step toward a better future.

Fast, Personalized, Proven IT & ERP Expertise

No spam. No pressure. Just strategic insights and clear solutions.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

Epicor Configurator Introduction: Configurator Offerings

Epicor Configurator Introduction: Configurator Offerings

Epicor ERP Configurator Questions…We Have Answers

 

Epicor’s Product Configurator is among its most enigmatic and elusive modules. Configurator has been diversely characterized and mischaracterized, as everything from the cure to all that ails you to the straw that broke the company’s back. This presents a daunting task for Epicor customers operating in engineer-to-order and configure-to-order environments, for there are a lot of answers and partial-answers out there, and getting to an answer specific to a given business is more easily said than done. Different companies, in different markets, have specific questions, and Epicor’s introductory materials tend to serve a general audience. Moreover, the experiences of customers from different industries and earlier versions of configurator may or may not apply to a company looking to implement or upgrade to the current Epicor release. The place of the customer within the Epicor implementation lifecycle also greatly affects their needs. For companies implementing Epicor for the first time in version 10.1, the questions may relate to the applicability of Epicor’s Product Configurator module to the company’s product offerings, or to the ease with which Product Configurator instances can be constructed and maintained. For companies moving from Vantage 8.03 or Epicor 9.05 versions, the questions may relate to the ease with which they can convert their configurators from Epicor’s older architecture to its new platform, and how to get their staff ready to maintain them, moving forward. Customers already in the heart of an implementation effort may just need someone to look over their shoulder and ensure that best practices are being followed, or even help expedite the configurator design and development.

 

For these reasons, The Estes Group tailors its Epicor ERP implementation services to meet the specific needs and circumstances of the client in question:

 

Configurator Upgrade Assessment: For existing Epicor customers considering the move from Vantage 803 or Epicor 905, but are concerned about the ramifications to their existing configurators, an assessment of their current use of Epicor’s Product Configurator module is often of great value. Estes’s consultants have configurator experience going back to Vantage 803 and moving forward into its current 10.1.600 release. Moreover, Estes’ consultants have experience uplifting and rebuilding configurators from earlier versions to Epicor’s current architecture, capturing the business requirements from the original versions, while leveraging Epicor’s new features, such as the expanded user interface, the elaborated method rule architecture its user-defined method capabilities and its highly-flexible configurator lookup table competencies. Such an assessment is most often a combination of remote and onsite effort, analyzing the existing solution and mapping its requirements to the Epicor 10 configurator.

 

Epicor ERP Configurator Business Process Review:

 

New or existing customers often benefit from the traditional business process review (BPR) format, tailored to the areas affecting or affected by Epicor’s Configurator (quoting, order entry, planning, manufacturing). The goal of a Configurator BPR is to help the client understand whether Epicor’s Product Configurator module will address their business needs. It is common to incorporate a Business Process Review at the onset of an upgrade assessment when working with existing Epicor customers. These events normally extend from a few days to a week in duration, depending primarily on the size and complexity of the business and follow a detailed agenda, designed to explore the customer’s products and processes from multiple angles.

 

Epicor ERP Configurator Proof-Of-Concept:

 

For new customers in greater need of verification, or for customers looking to get a jump-start to their implementation, a Proof-Of-Concept activity (POC) is often the appropriate direction. Normally performed on the heels of a BPR, POC events involve a configurator and a production consultant working with the client team to develop a working prototype that can be processed through the quote-to-ship cycle, for purposes of business process prototyping and configurator verification. For companies in need of a definitive answer to specific questions, a Proof-Of-Concept activity is the most concrete way in which to provide them. And for companies struggling to gain project momentum, these events can be highly beneficial in gaining much-needed project traction.

 

Configurator Development Support: For customers in the midst of an Epicor implementation, but in need of some “extra muscle” in the area of Product Configurator, Estes offers trained consultants who can step in, roll up their sleeves, and immediately assist with design review, configurator development, and related system consulting. These activities can be performed remotely or onsite, based on customer need, and can vary in scope from a few remote hours a week, to an onsite intensive session, to ongoing engagement.

 

Ask us any question you have about Epicor ERP Configurator. We have answers.

Your Distribution Business Runs Better With Prophet 21 ERP

Your Distribution Business Runs Better With Prophet 21 ERP

Transforming Your Distribution Business for Today’s Digital Age

Markets are evolving at an unprecedented pace, presenting both challenges and opportunities for distributors. The landscape has been fundamentally reshaped by several factors: the acceleration of e-commerce adoption, supply chain digitalization, artificial intelligence integration, and shifting customer expectations around sustainability and personalization. These transformative forces are compelling distributors to rethink their traditional business models. In today’s fast-paced distribution landscape, maintaining optimal ERP performance isn’t just an IT concern—it’s a business imperative. EstesGroup’s EstesCare ERP subscription service delivers peace of mind through proactive system monitoring, rapid issue resolution, and ongoing optimization from certified experts who understand both the technical and business aspects of distribution.

How will you position your business in this rapidly evolving landscape? Will you merely react to changes as they come, or will you proactively embrace digital transformation to create sustainable competitive advantages?

To thrive in today’s distribution sector, focus on these six strategic imperatives:

  • Deliver an omnichannel experience that seamlessly blends digital and traditional channels
  • Leverage AI and analytics to attract and retain customers
  • Build resilient and transparent supply chains
  • Become the sustainability leader in your target verticals
  • Optimize operations through automation and digital workflows
  • Strengthen your market position through data-driven decision making

Central to achieving these goals is implementing the right technology stack, with Epicor P21 remaining a cornerstone solution for modern distributors.

Today’s Epicor P21 Platform

Epicor P21’s latest iteration combines familiar usability with modern cloud capabilities. Its interface maintains the intuitive Microsoft-style experience while incorporating contemporary design elements and mobile-first functionality.

The Enhanced Digital Capabilities of Prophet 21

The latest platform now offers:

  • Cloud-native architecture supporting hybrid and remote operations
  • Advanced API integration capabilities for seamless third-party connections
  • Real-time analytics and AI-powered insights
  • Enhanced cybersecurity features and compliance tools
  • Sustainable operations tracking and reporting

Mobile Solutions for Your Distribution Business

The modern mobile suite includes:

  • Advanced POD (proof of delivery) with real-time tracking
  • Route optimization using AI algorithms
  • Digital documentation management
  • Mobile inventory management
  • Customer self-service portals

Intelligent Customer Service

P21’s customer service capabilities now incorporate:

  • AI-powered predictive maintenance
  • IoT integration for equipment monitoring
  • Automated service scheduling
  • Digital contract management
  • Customer success analytics

User Experience & Customization

The platform maintains its user-friendly approach while offering:

  • Modern, responsive interfaces
  • Customizable dashboards and workflows
  • Low-code/no-code customization through enhanced DynaChange
  • Integration with collaboration tools
  • Mobile-first design principles

The Evolution of DynaChange

DynaChange has evolved into a comprehensive low-code development platform that enables:

  • Drag-and-drop interface customization
  • Workflow automation
  • Custom report creation
  • Integration management
  • Mobile app development

Implementation for Success

At EstesGroup, we understand that technology is an enabler of business success, not just an IT investment. Our comprehensive implementation approach aligns your digital transformation strategy with concrete business objectives while ensuring smooth change management and user adoption. We emphasize data-driven process optimization and sustainability integration, all within a framework of continuous improvement that evolves with your business needs.

7 promises we make when we work closely with you to implement Epicor P21:

  1. We promise to accelerate your digital transformation
  2. We commit to enhancing operational efficiency
  3. We won’t stop until we improve your customer experience
  4. We work with your team to drive sustainable growth
  5. We promise to increase your profitability
  6. We take extreme caution to help you maintain regulatory compliance
  7. We love the world so we take environmental initiatives by using clean data centers for cloud infrastructure

By partnering with EstesGroup, you gain access to deep industry expertise and a proven implementation methodology that ensures your P21 implementation delivers measurable business value and positions your distribution business for success in the digital age.

Ready to take the next step to secure success for your distribution business?

The distribution industry continues to evolve, and with the right technology partner and modern ERP solution, you can turn market challenges into opportunities for growth and innovation.

 
 
 
 
 

ERP Support Services for Distribution Business Success

Instead of dealing with unpredictable costs and response times from ad-hoc support, distributors can rely on a dedicated partner committed to maximizing their ERP investment and supporting their growth. With EstesCare, you gain a strategic advantage through continuous system improvements, regular health checks, and priority access to specialized expertise that keeps your operations running smoothly and efficiently.

Learn more about EstesCare Support Services today.

EstesCare ONE | EstesCare Plus | EstesCare Guard | EstesCare ERP

(888) 300-2340 | [email protected]

Our Virtual CIO Services Will Help Your Business Run Better

EstesGroup Virtual CIO

Many IT departments are multifaceted, and they don’t have the time to properly take care of everything, including planning for the future of technology. Virtual CIO services allow you to extend your IT leadership for additional executive guidance when needed.

 

For example, many customers feel their ERP system is upgraded simply by adding big hardware. However, IT is actually an investment, not an expense, and includes resources that extend far beyond the initial technology purchases. To help companies with the investment of IT, whether in hardware or in software, our IT experts start with infrastructure planning, virtualization advice, virtualization tuning, and security assessments. We need to look at the security of your system overall and by application. We need to evaluate your IT process and develop maintenance planning strategies because all machines and software require some maintenance.

 

Virtual CIO Epicor ERP Database Management

All databases require management on a weekly, if not daily, basis.

Our IT services team can help you with database management. In addition, we can set up a schedule so that it’s ongoing for you. We can even be a remote person when you need external expertise.

 

Performance management

Every good ERP system needs an ERP performance management review. We can help you with essential IT requirements for any ERP:

Everyone talks about disaster recovery, yet very few people ever implement it. It has to be done. Look at it as a matter of when disaster’s going to strike, not if. What is a good business continuity plan? How’s the business going to run after you’re down? We need to talk about these items. Do you need security for virtual office workers? We can and will be your customer advocate. If you have issues with anything involving your IT, we can help you work your way through this and plan it.

 

 

What has been slowing your business down? We know technology should not, and we will ensure it will not again.

 

Performance Testing And Tuning Your Epicor and IT | EstesGroup Epicor Partner

Ben Nixon, Vice President of the Enterprise Technology with the EstesGroup.

I am here today to speak to you a few moments on IT performance testing and tuning.

You know, everyone wants your IP system to operate efficiently. I’ve got 17 years of Epicor experience, and this service can help you identify and eliminate as many hardware and configuration bottlenecks as possible.

Are these negatively affecting your assisted performance?

Have you ever thought about the cost of downtime?

These are items we could help you with. You know, a little time spent now can make your operation much more efficient.

Have you ever looked at the cost of downtime? How much does a down man-hour cost? Many people do not look at these items. Take a look at that. It doesn’t take long to realize we can make things much more efficient. We can come in, and we can help you test your servers, tune them, set up maintenance plans, identify bottlenecks, review your resources to see if they’re configured properly. We run the Epicor performance diagnostics tools to see if your application is performance and Epicor’s quality assurance performance benchmarks.

How much does a down man-hour cost? Many people do not look at these items. Take a look at that. It doesn’t take long to realize we can make things much more efficient. We can come in, and we can help you test your servers, tune them, set up maintenance plans, identify bottlenecks, review your resources to see if they’re configured properly. We run the Epicor performance diagnostics tools to see if your application is performance and Epicor’s quality assurance performance benchmarks.

Many people do not look at these items. Let’s take a look at these issues in your business. It doesn’t take long to realize we can make things much more efficient. We can come in, and we can help you test your servers, tune them, set up maintenance plans, identify bottlenecks, review your resources to see if they’re configured properly. We run the Epicor performance diagnostics tools to see if your application is performance and Epicor’s quality assurance performance benchmarks.

Is your SQL maintenance plan very much forgotten?

 Everyone thinks SQL’s plug and play, do you? It is not.

SQL’s a great database. It needs some maintenance. We can help you do that. We can and will review your virtual configuration. It often — one little setting can make a difference. Upon completion, we give you a detailed report of what you’re gonna need. Uh, more satisfied users. User complaints come to a slowdown. These are all items that will help you, um, enabling your employees to do their jobs faster, providing better customer service, quicker diagnostics.

And the nice part is, I love to work with your people, your-your IT people. We’ll train them. We’ll show them what to look for, how to help keep this going. Give me a call for a free 30-minute consultation. Let’s see what Estes can do for you. Make your business run better with our Epicor training.

Tell us how we can help, what has been slowing your business down? We know technology should not, and we will ensure it will not again.

Estesgroup is a 100% Certified Authorized Partner with Epicor ERP.