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 they would want to import. By default, it automatically selects the required fields, so it’s just a matter of adding in the fields that need 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 the command line, but it would need to be through a different methodology, such as a 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, or 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 the Industry.


Headquartered in Hixson, Tennessee, Card-Monroe Corp. (CMC) is the world’s leading manufacturer of custom-built tufting equipment used to manufacture carpets for a variety of flooring markets and applications. This ranges from residential to commercial applications of carpeting, combining a vast array of textures and color options. This includes artificial turf for sports fields and hospitality carpet with sophisticated styles found in hotels, restaurants, corporate offices, and convention centers.

Success Highlights

Challenges

  • Integrate manufacturing, inventory control, and accounting processes into one comprehensive ERP system

Solution

  • Epicor ERP
  • Epicor Data Management Tool (DMT)

Benefits

  • Improved ability to manage customer orders from quote entry throughout production, shipping, invoicing, and follow-up
  • Enhanced shop flow and collaboration among employees resulting in efficiencies that reduced assembly cycle times by 30% and machine shop work-in-process by 40%
  • Transported more than 670,000 records during implementation from differing sources into the Epicor ERP solution with complete accuracy

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 the Industry.


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 the Industry.