The Epicor Data Management Tool (DMT) is an application that many Epicor ERP clients use to import information into their Epicor systems and to make mass updates. Many clients already know how to use the tool through the standard UI interface. The command line interface allows for interacting with the DMT without the need for user intervention.

The Benefit of Accessing Epicor Data Management Tool via Command Line

By allowing us to interface directly with DMT, this allows for us developers/consultants to quickly import information into Epicor. Such information that can be imported for both new and updating include:

  • Parts
  • Material Issue
  • Return Material
  • Quantity Adjustments
  • Jobs
  • Job Receipt to Inventory
  • Many More

Under normal circumstances, we would need to utilize the standard Business Objects or APIs to make these transactions and updates within the system. This can add a lot of overhead when performing a large number of transactions at a time. Pushing these through the DMT usually allows for us to process a greater number of transactions more quickly, with only the need to write the CSV file and kick off the application.

Getting started with Epicor Data Management Tool (DMT) via Command Line

Epicor provides a good amount of information regarding the DMT and the command line interface. Here is some documentation on it, so long as you have an EpicWeb account. you can find those resources, here.

The above resource provides all of the options that can be used with the DMT.exe and some basic examples. Beyond that, I would recommend anybody who would want to use this to use the DMT to create the templates for what the would want to import. By default, it automatically selects the required fields, so it’s just a matter of adding in the fields that needs to be updated/inserted.

Kicking off the DMT via a BPM is how I had originally done this for an Encompass client in Life Sciences manufacturing and I imagine that this would probably be the most universal way for it to be used. With that said, using the DMT in this way is not viable for Cloud clients as the DMT isn’t available for execution from the server side of things.

Cloud clients can still utilize the DMT, even with command line, but it would need to be through a different methodology, such as script file or through a local application that has access to the DMT install.

For more information on utilizing Epicor Data Management Tool via Command Line, reach out to Encompass using the link below.

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.


From their inception, Enterprise Resource Planning (ERP) systems have been deployed with an overarching purpose: reduce costs by managing processes and materials. Until the middle 1980s, enterprise systems were built for narrowly defined business needs such as order management, account payables, and inventory control. The first real ERP systems integrated the data and processes once handled by individual programs into a single system capable of managing almost every aspect of running a sizable business. They transformed how modern businesses work.

The principal benefit of a consolidated ERP strategy was ensuring that data wasn’t duplicated across departments, eliminating “islands of information.” Processes once separated could now be linked, enabling enterprise-wide planning and optimization. For years, the focus of ERP was top-down implementation of this strategy: the imposition of processes and measurements from an executive perspective. As the marketplace has evolved into a global competition, where facilities, suppliers, and partners are dispersed geographically and supply and demand signals occur over increasingly complex and nuanced value networks, the top-down orientation of traditional ERP is proving to be less than adequate on its own. In this new business environment, change and innovation are accelerating; risk and opportunity are dynamic elements across networks, and business practices and processes are evolving at a pace heretofore unimagined. Response to this changed competitive landscape demands that ERP not only support the executive agenda but also the needs of individuals, regardless of where are they are in an organization’s value network. Only then can companies mobilize quickly and respond effectively to events as they occur at breakneck speed, whether in Singapore or Stuttgart or the Silicon Valley. So ERP has had to evolve into adaptive ERP.

 

Epicor-10-Adaptive-ERP-WP-ENS

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers and Distributors. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.


Epicor ERP version 10 is built on 100% Microsoft architecture. Some Epicor ERP users have developed Business Process Management (BPM)s, electronic interface modifications (SEPA), and Product Configurations using Progress® OpenEdge® ABL code. As Progress OpenEdge is no longer supported as of release 10 of Epicor ERP, these code extensions will need to be rewritten in C#. To assist our customers in the upgrade to Epicor ERP version 10, Epicor has invested in new product functionality, business analyst training and direct resources to assist you in your move to version 10.

 

Epicor-ERP-Progress-ABL-Code-Conv-WP-ENS

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers and Distributors. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.


Kadant Inc. is a midsize global supplier of high-value critical components and engineered systems for use in process industries. It focuses on papermaking, paper recycling, and other processing industries in over 18 countries worldwide—including the United States, the People’s Republic of China (PRC), and some European countries.

Success Highlights

Challenges

  • Lacked standardised global business management processes
  • China site previously had no ERP system

Solution

  • Epicor® ERP

Benefits

  • Synchronized global business on the same ERP platform
  • Improved operational efficiency
  • Avoided redundant engineering workload by over 40%
  • Simplified data retrieval process

 

Epicor-ERP-Kadant-CS-SEA

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers and Distributors. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.


Founded in 1970, Maxweld and Braze is the wholesale division of the Weldamax Group. It began as a wholesale supplier of safety wear for the welding industry. But gradually expanded to include a full range of welding equipment and consumables backed by warranties, a local service center and customer training.

High production costs in the USA and Europe meant new suppliers had to be found in the East. However, this brought further challenges in managing procurement, stock and production, whilst ensuring optimum customer service.

Success Highlights

Challenges

  • Required standardized data management throughout the Weldamax group
  • Old systems were not integrated and lacked transparency
  • Needed more control over inventory
  • The inability to forecast sales and manage purchasing accurately resulted in incorrect inventory purchasing and holding
  • Fluctuating Rand v. US Dollar exchange rate

Solution

  • Epicor ERP

Benefits

  • Streamlines operations by integrating internal processes
  • Ensures all areas of the business are transparent
  • Helps to establish processes and systems within the group

 

Epicor-Maxweld-and-Braze-CS-ENS

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers and Distributors. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.


Greno Industries hosted an onsite Epicor Value Exchange Workshop with the goal of improving their understanding of Epicor systems, prepare for an upcoming upgrade and facilitate workforce training from experienced Epicor consultants. Greno Industries, headquartered in Schenectady, NY, offers machined parts for steam and gas turbines, generators, compressors and pumps, pulp and paper, and mining, among others. They are looking to expand into other industry verticals.

Success Highlights

Challenges

  • Underutilization of Epicor 10.2.300.2
  • Prepare for upgrade to next version of Epicor ERP
  • Leverage the expertise of Epicor account professionals in-person

Solution

  • Epicor® Value Exchange Workshop – Epicor ERP Education and Training

Benefits

  • Creating better processes as Greno Industries move more into aerospace
  • Better utilization of basic Epicor functionality (Dashboards and BPMs)
  • Bring disparate systems together
  • True implementation of scheduling visibility
  • Better capture of indirect labor costs

 

Epicor-Value-Exchange-Workshop-Greno-Industries-CS-ENS

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers and Distributors. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.