Code collaborators

Software gives programmers access to complex platforms

Above: Epicor 10 software makes inventory tracking easier as any changes are instantaneous using the software on tablets.

Software gives programmers access to complex platforms

January 2015 - For most users, being able to manipulate the back end of a software program is of no interest nor would a nonprogrammer know where to start. But as the marketplace advances, companies are recognizing the value in branching out into new markets. The ability to manipulate and customize software is allowing shops of all sizes to gain a competitive edge.

Previously using in-house created DOS-based software, Humtown Products in Columbiana, Ohio, realized it needed to upgrade its program. “We knew we’d have to get software that allowed customization,” recalls Brenda Mohr, solution provider and programmer at Humtown. 

The initial search began about five years ago. After selecting Austin, Texas-based Epicor, the software was implemented three years ago. Humtown noticed immediate differences in reporting abilities. “We used to run a lot of spreadsheets to keep track of various operations and their status, but found Epicor’s software to be much more robust,” Mohr says, citing the configuration of internal costing and pricing systems. A breakdown of costs for each job is now available as it is completed. 

MM-0115-software-image2

When Mohr began using Epicor software, the programming language was new to her, but she was able to research and teach herself the software language. Then, “we started manipulating and writing programs for pricing and quoting,” she explains. “Once we came up with the application, I was able to pass on any questions to Epicor support and they helped us through it. Even though I had never worked with this program before, I was able to learn and go a long way with a little bit of knowledge.”

Fluid transitions

Orders at Humtown vary from customers requesting the same amount of product each week and others that change from day to day. The family-owned business serves the foundry industry throughout the Midwest. This includes industries ranging from agriculture, construction, manufacturing, mining, national defense, public utilities and transportation, with research in additive manufacturing and prototyping. Humtown’s pattern shop uses aluminum, carbon and stainless steel, cast iron as well as other materials such as wood and tooling board.

“Each job we do is very intricate and using an internal application, created within Epicor’s platform, we are allowed to do even more customized work,” Mohr says. When working with a customer to create the best “recipe” for creating individualized sand cores, “we may change the type of sand or amount of chemical used. We can change one detail or all details as needed, which allows us to be very agile.” Sand cores are used by foundries to create the holes in metal castings. After the metal is poured, the cores are broken, often by shaking them out, leaving cavities.

MM-0115-software-image1

“Using Epicor makes things faster and the biggest thing for us is that we can customize it,” Mohr continues. “We used to have to manually quote jobs, which in itself can take hours, but with the addition of the configurator from Epicor, our sales staff can quote a job within minutes, get customer approval, have the order placed and the job sent to a machine on the floor and ready to run production in as little as 15 minutes.”

ERP vendors handle quote to cash, explains Dick Schultz, director of product marketing-manufacturing at Epicor. Quote to cash is the business process that starts when creating a quote that vendors hope turns into an order. Confirmed orders are manufactured and shipped, the customer invoiced and cash is collected. “It’s the ‘circle of life’ for any manufacturing company,” says Schultz. Humtown keeps inventory on hand because customers often ask for products unexpectedly and the company wants to fulfill those requests with quick turnaround times. Using a configurator Mohr programmed within Epicor’s platform, quoting jobs allows the company to stagger orders for customers that want parts throughout the week. 

Another benefit from a programmer’s perspective is Epicor’s Service Connect tool, which can be used to extract data both in and out of software. One way Humtown took advantage of this tool is by having truck drivers email shipping documents from the MM-0115-software-image4computer tablet they carry along during deliveries. 

“When the driver drops off an order, customers sign the digital documents on the tablet which are then emailed directly to us,” Mohr explains. “Any attachments are automatically attached inside Epicor. I have a little program I wrote in the business processes area of Epicor that makes sure an invoice isn’t approved until all the necessary documents are attached.”

Calls to customize

More companies want to customize, according to Schultz. “There is a need to have a nontechnical person be able to maneuver the software as well as someone able to specialize it,” Schultz says. Companies want to provide reports and add fields “but also [input] more complex, incremental logic or try subsystems so their own programmers can work and rewrite within them.”

Epicor ERP version 10, the latest upgrade, allows users to focus programming on executing the steps necessary to accomplish certain tasks. “When you need to change a report, it isn’t as easy as it sounds; there are complex subsystems underlying those reports,” explains Schultz. “We’ve built tools for programmers to access key business data so that they can customize dashboards.” People at an operational level on the shop floor can look at data that provides an overall picture of inventory, giving them a better idea of what items are running low and where they can better streamline processes.”

When approving quotes, for example, there is often a hierarchy of approvals that companies use to ensure approvals move through the correct sequence. The Epicor system allows programmers to include those levels of approval through tailored workflows, so the right people receive the information needed in order to make  timely and informed decisions. 

The biggest leap for Epicor 10 from version 9 is that everything works within the Microsoft platform in the Epicor ICE framework, “exposing all our business logic that gives more technically advanced customers the ability to write code. They have the ‘keys to the kingdom’ to go in the back end and make the adjustments they need without modifying source code,” Schultz adds.

MM-0115-software-image3

Planning scheduling using Epicor 10 includes forecast driven MRP with infinite planning, capacity-driven finite schedules and pull manufacturing with kanban techniques. The visual board allows manual “on-the-fly manipulation on the schedule,” Schultz adds.

People are usually good at one part of the quoting, approval and production process or another, Schultz says. “As far as mid-market ERP vendors, reporting tools have become pretty good. But a lot of those use third party add-ons for a lot of their features or have grown to the point where there are two, three, sometimes four different technologies—then you really have to get technical,” Schultz says. “With Epicor, you learn just one and then study the business problems so you can go in the back end and customize.”

While most ERP systems function well on the simple end of the spectrum, they struggle with product coverage and completeness as the tools become more complex. Epicor is on one platform. 

Because jobs at Humtown differ so much from day to day, the value in being able to adjust software to meet the company’s unique needs is invaluable, says Mohr. “We’re very fluid. It’s hard to say what a typical day is at Humtown but Epicor allows us to do whatever the day calls for.” MM

Sources

Epicor Software Corp.
Austin, Texas
phone: 800/999-1809
www.epicor.com
Humtown Products
Columbiana, Ohio
phone: 330/482-5555
www.humtown.com