Select Page
How to Manage Epicor Part Replacement

How to Manage Epicor Part Replacement

One area of Epicor consulting that we frequently get asked about spins around engineering change orders. Engineering updates to the part master once the company is live has been likened to working on a car’s engine while speeding down the freeway. This is especially true when creating new parts to replace existing parts in existing Bills of Materials. It would be an understatement to say that parts are rather important to ERP systems—even novice Epicor consultants know that parts are one of the foundational building blocks upon which everything else rests.
Epicor Part Replacement Management

How to Introduce Engineering Change Order

Shake-ups to the part structure invariably have tremor effects on the upper decks, so you would want to minimize these by following a careful approach to introducing engineering change order. Such an approach involves two steps: carefully understanding the exposure of the legacy parts to be replaced and planning the update accordingly, and then systematically executing the necessary updates to pull off the switch. In one case you might be renaming a part or a number of parts, to ensure consistency across your part master. But such changes affect a number of areas, so the steps to execute such changes need to be well planned out and executed. The following is a guide to do just that—planning and executing Epicor part replacement within your business system.

 

 

Planning and Review: Steps for Replacing Parts in Epicor

Before making changes, it is a good idea to plan through the changes you wish to make and ensure that all areas of the system that might be affected by these part changes will be addressed. The following tasks should be performed before a change is implemented:

  • Review any cases where the part exists on an open sales order and review any related allocations.
  • Review any cases where the part exists on an open purchase order or purchase order suggestion.
  • Review any cases where the part exists as a job material—this might include open firm jobs and unfirm jobs.
  • Review any cases where the part exists as the part to be made on a job header— this might include open firm jobs, unfirm jobs, and even part suggestions in the planning workbench.
  • Review the cases where the part exists in the BOM of another part.
  • Review the cases where the part is located in a Part Bin as on-hand inventory.

Execution of Part Replacement in Epicor

Once ready to execute the changes, care should be taken to ensure the proper steps are done, and in the proper order:

  • Create the new parts, revisions, MOMs, part costs, etc.
  • Run an update to replace the material parts in any part Bills of Materials.
  • Remove any Sales Order Allocations. Run an update to replace the parts in any Sales Order Lines.
  • Run an update to replace the material parts in any open, firm Jobs’ Bills of Materials. Delete any unfirm Jobs that contain the legacy parts as materials.
  • Run an update to replace the Job Header parts in any open, firm Jobs. Delete any unfirm Jobs for the legacy part. Delete any Part Suggestions for the legacy part.
  • Run an update to replace the parts on any open purchase order lines. Delete any PO Suggestions for the legacy part number.
  • Run a quantity adjustment update to remove the on-hand quantities of the legacy parts. Run a quantity adjustment update to add the on-hand quantities of the new parts, using the legacy part quantities that were previously on-hand.
  • Inactivate the legacy part.

 

Playing the Part in Epicor Part Replacement

Above all, care should be taken to make sure that sufficient communication has been made across the organization, beginning with your designated Epicor consulting team and extending throughout your entire company’s infrastructure. As you can see, such a change affects multiple modules, so you can anticipate that many people and departments will likely be affected by such a change in Epicor. As such, make sure to communicate accordingly. Following the proper steps, you can help keep your part master clean, and your business system running smoothly.

 

 

Looking for more tips from our Epicor consulting team?

Read our white paper on Epicor Part Setup.

Get an Epicor ERP Part Setup & Manufacturing Best Practices Whitepaper Today

Name(Required)
Email(Required)
Epicor Administration & Helpful Tools of the Trade

Epicor Administration & Helpful Tools of the Trade

A Day in the Life of an Epicor Admin

One of the best parts of working as an ERP consultant is the opportunity to work with so many smart people, and you’ll find many working in Epicor administration. Companies are successful for a variety of reasons, and the strengths, skills, and character of individual employees are at the core of organizational performance. The privilege of working with devoted coworkers makes it all worthwhile. As they say, iron sharpens iron — and even should a few sparks fly, I am thankful for the grind. Epicor admins come with a toolset capable of managing the application’s configuration, performance, and architecture — administration responsibilities that demand precision and prowess.

Epicor Administration

What exactly is an Epicor admin?

Of the many ERP positions I’ve encountered, none are so perplexing and nebulous as those responsible for Epicor administration. What I have come to understand is that the Epicor Administrator is as thankless a role as it is undefined. In my years as an Epicor consultant, I’ve encountered countless ERP administrators, and their skills and responsibilities extend in all directions.

 

For example, an average day for an Epicor admin might look something like this:

  • Address system errors first thing in the morning.
  • Perform an ad hoc backup of the production database and restore it over the test environment to give new employees a place to train.
  • Troubleshoot intermittent MRP issues.
  • Educate the engineering department on correct part setup.
  • Deploy yesterday’s dashboard tweaks.
  • Blow away some pesky personalizations that have been flummoxing a particular user.
  • Help the finance department with some BAQs in anticipation of the coming month’s end.
  • For free time, work on a chip-away-at SSRS report.
  • On the way out the door, kick off a DMT run to mop up some of last week’s indiscretions.

What does tomorrow bring for the Epicor administrator?

 

Every admin I’ve met hosts a similar blend of firefighting, process improvement, and general oversight. And in spite of the tremendous breadth that such a position demands, I have encountered many an admin whose depth of knowledge has matched their breadth. Over the years, I’ve done my best to learn from them and to document what I’ve learned. As such, here are a few Epicor administration tricks I’ve picked up along the way that you can bookmark, revisit, and share.

 

Need your BAQ to return more than 10,000 rows? BAQ Execution Settings help Epicor administrators get more data.

Have you wondered how to manage the multiple sessions flag in user security works?

Do you need to enable new functionality through the admin console? Check out our post on Epicor licensing.

Looking to launch a form’s custom version from a right click or an MES button? Learn more about binding Epicor customizations using process calls and menu IDs.

Trying to work out auto-login? Review Epicor sysconfig files and auto-login capabilities.

Need to relate UD tables to their parents? Learn how the SysRowID fields relate parents to children.

Are you running into the “CGCCode Mismatch” error when importing dashboards in Epicor 10? Learn how to edit a dashboard definition.

Are you looking to deploy customizations in a multi-company environment?

Beyond Epicor Admin

Are you looking to go beyond administration knowledge?

Sign up for a free consultation with an Epicor consultant by chatting with us now.

Epicor BAQ: Returning Too Much of a Good Thing

Epicor BAQ: Returning Too Much of a Good Thing

Epicor BAQ

The Epicor BAQ (Business Activity Query) toolset allows you to leverage the mounds of data that your system generates. But the problem with mounds of data is its volume—when we say mounds, we mean… mounds. As such, Epicor has built in a feature to its BAQ designer to limit the number of rows returned.

 

This feature prevents a “runaway query” from tanking a company’s performance. This functionality was especially helpful when I first delved into queries, as it prevented me from needlessly tanking my environment. Looking back at some of my early queries, they certainly were tank-worthy.

 

But for experienced Epicor users working with large datasets, this limitation can be… well, limiting. When a query generates a dataset that is more than 10,000 rows, the following warning message displays:

 

Severity: Warning, Table: , Field: , RowID: , Text: Test results are forcibly limited to 10000 rows to prevent the application server memory overload:

 

Activity Query Epicor BAQ

 

This can be immensely frustrating to Epicor super-users, for there are cases when the entire dataset needs to be returned, to gauge the efficacy of a given BAQ. In the past, the workaround to this limitation was to embed the BAQ in a dashboard, as the 10K row limitation disappeared when the BAQ was part of a dashboard.

 

But such an additional step seemed like an unnecessary contrivance—scaling the fire escape when all you needed was a step ladder.

 

Fortunately, Epicor modified the BAQ designer to allow the person creating the BAQ to modify the Execution setting that limited the number of returned rows. The steps to make this possible are below.

 

From the Actions menu, select “Execution Settings”:

 

Activity Query BAQ Execution

 

Click the new icon to create the new execution setting.

 

This creates a new execution setting that needs to be defined. Then you can perform the following additional steps:

  • For the “Setting Name” select “RemoveTestRowLimit”
  • Set the Setting Value to “True”
  • Check “Persist In Query”
  • Click OK:
BAQ Query Test Execution

 

Thereafter, the BAQ will return all the available rows:

 

Epicor Activity Query Designer

 

The execution setting needs to be defined for each query for which you wish to return more than the default number of rows. Make sure to save the query after the execution setting has been defined.

 

Ready for a quintessential query?

 

Successfully navigating the Epicor application is rarely a matter of taking one great leap forward. More often than not, it is a series of small, incremental steps. With Epicor BAQ, your goal is to take your data and turn it into information—without getting lost in the volume.

 

 

To learn more about Epicor management and administration, please watch our video on cloud ERP by clicking here.

Part Master Best Practices? Ask Brad

Part Master Best Practices? Ask Brad

Part Master Questions

Epicor Part Master Q&A

Q: What are some of the first things that someone should consider when setting up parts in Epicor?

 

A: We could have a long, harrowing conversation about part naming conventions, but arguments over part naming philosophies have ruined more friendships than heated discussions over the latest Star Wars movies—so I’m going to leave that one alone. In terms of Epicor part master setup, probably the first and most important consideration is the Non-Stock checkbox. The Non-Stock Flag is one of those “big-little” checkboxes that drive a ton of downstream behavior. This one flag will affect how a part will be handled on a sales order, a purchase order, and a job, whether as the top-level assembly or as a component material, and basically determines whether the related transaction will be processed through the system’s inventory module or processed directly in a “to-order” manner. This flag is fundamental for companies looking to operate in mixed-mode manufacturing. Most companies, even companies working in highly-engineered environments, rarely intend to manufacture all components “to-order.” Often there are economies of scale to consider, and components can be used on a broad array of higher-level assemblies. As such, some parts will be handled in a “to-order” manner, while others will follow a traditional inventory-based approach. For that reason, we have to place special consideration on the setting of the Non-Stock flag.

 

Q: Phantom BOMs are a topic of disagreement—do you have any recommendations on the use of Phantoms?

 

A: In general, a phantom is a part that carries a method of manufacture, but is not itself manufactured discretely. Rather, the part “explodes” when it belongs in a work order—the top level part disappears and is replaced by its components. Phantoms really are system-specific, for the rules for handling phantoms differ by ERP system. Within Epicor, a few general rules could be suggested when deciding if a part will be flagged Phantom BOM. Firstly, if a part is stocked, it should not and cannot be flagged Phantom BOM, as it is assumed that a phantom part not be stocked. Also, if a part is made independently from its parent, in a different place and at a different time, it should not be flagged Phantom BOM—it should be either a material or a subassembly, so its manufacture can be managed independently from its parent. When component parts are made at the same time and place as their parents, I’ve seen customers use phantoms to manage the components, to simplify production, while retaining the basic product structure defined by engineering.

 

Q: More specific to Epicor, the Pull-as-Assembly flag is a source of confusion and disagreement—do you have any recommendations on the use of the Pull-as-Assembly flag?

 

A: A Method-of-Manufacturing defined for a Part Revision can differ significantly when you pull the revision into a Job and get details. These differences are largely due to the Pull-as-Assembly flag. This flag essentially defines whether a component part will be manufactured independently from its parent part, or as part of the same Job as its parent, as a subassembly. One can suggest a few principles when choosing to flag a part as Pull-as-Assembly. If the part is stocked, do not flag the part Pull-as-Assembly, as you will be supplying the material from your on-hand inventory. If the component part in question is Non-Stock, and the intent is to supply the materials through a separate Job, uncheck the Pull-As-Assembly flag. But if you wish to supply the Non-Stock part with a subassembly, allow the Pull-as-Assembly flag to remain checked.

 

Q: Can you explain how the settings on the part master flow through to a bill of materials and ultimately to a work order?

 

A: It’s easier to explain this with a visual…

 

Part Master Flow

Please fill out the form below to get a white paper on Epicor Part Setup and Best Practices sent right to your inbox!

Get an Epicor ERP Part Setup & Manufacturing Best Practices Whitepaper Today

Name(Required)
Email(Required)
Epicor Engineer-to-Order at Your Service

Epicor Engineer-to-Order at Your Service

The Role of Order Entry in ETO and CTO Environments

Epicor Engineer-to-Order environments are their own special breed. Based on an almost infinite notion of product variability, their business models are hard to shoehorn into an ERP system. I once had a job shop employee describe his product variability with ultimate pliancy: “If they want us to wrap it in toilet paper, we’ll wrap it in toilet paper.” That would be a costly proposition these days. In light of this, I often get requests from my customers for “best practices” in handling various Epicor ETO environments.

Epicor Engineer-To-Order

The If-Then-This-That of E10

When it comes to questions regarding Epicor Engineer-to-Order, I always preface my answers with a de facto “it depends” before diving deeper into all the variables at play. Best practice for one company might not be the same for another. Ironically enough, it is almost as if I need to configure an answer for my customer, and discussions tend to take on the following format: “If this and that and/or this or that, then do this…”

 

One such question came to me recently from an Epicor customer, with regard to the role of Order Entry/Customer Service employees in an Engineer-to-Order organization. The company was debating the benefits and liabilities of having their inside sales staff perform rudimentary engineering activities as part of the entry of a sales order. In such companies, product details tend to arrive comparatively late in the quote-to-cash cycle, and the folks responsible for pounding in the orders often find themselves as the purveyors of this information, as received from the customer. These changes often require tweaks to manufacturing methods for a given product, and companies struggle in determining who should own these changes.

 

The In-the-Know of ETO

Who do you know on your team who could best own these changes? As I’ve noted above, “It depends.” But what does it depend on? I can think of a few of the variables that you would consider when deciding whether Order Entry should handle Engineering tasks:

  • Technical efficacy and product knowledge of the Order Entry team: The higher the efficacy, the more liberties you can give someone to alter MOMs when quoting. In some environments, where the estimators are highly technical, Engineering is strictly focused on new product development, and Sales owns what is sometimes called “project engineering.” In other environments, this role is staffed by folks in the engineering department.
  • Complexity of the product: The higher the complexity, the less you’d want Order Entry muddling with the engineering of the product. In low-complexity job shops, I’ve seen order entry or customer service staff handle the engineering implications of order changes.
  • The implementation of Epicor: There are a number of ways in Epicor to get from a Quote to a Job, and few companies in the CTO/ETO world do it exactly the same. Depending on the overall architecture, the MOMs in question might be modified through the quote module, the part master, or in the jobs themselves. This architecture will affect the processes needed to make changes: do you need to modify MOMs through the quote, or will you perform modifications to the Part Revision through the engineering workbench? Quote MOMs are much more apt to be modified by sales staff than are part master records.

In general, I have found that in most environments, Order Entry is focused on specifying product characteristics, features and options and that Engineering is responsible for defining the engineered product to satisfy these requirements. I often recommend that Engineering be the party responsible for what we normally understand to be the engineering function.

This model works well as companies sufficiently standardize their product offerings to support Epicor Configure-to-Order business models, as the delineation between features and options vs. product design are more pronounced in these environments. But there are certainly cases in which the composition of the entire sales staff, the nature of the product, and the system architecture determines that Sales is the optimal department to make these changes.

Are you a company in an Epicor Engineer-to-Order or Configure-to-Order environment? For help with your Epicor implementation or upgrade, please reach out to our team.

EstesGroup and Alliance Machine Interview (Video)

EstesGroup and Alliance Machine Interview (Video)

Bryan Provo, President

Alliance Machine, Inc.

Bruce Grant, President & CEO

EstesGroup

Bryan Provo explains why working with EstesGroup is critical to his success

 

Alliance Machine’s Bryan Provo is President of his family’s 2nd generation manufacturing business based in Elk River, MN, north of the Twin Cities. For 30 years, his company has delivered high-value solutions to the aerospace, defense, medical and technology industries. 

 

When EstesGroup originally engaged with him over 5 years ago, Bryan’s mind was fixed on having hardware on-site (exactly where cybercriminals could access it). In conversation with Bruce Grant, Bryan explained his transition from wanting full access to his own hardware to wanting complete IT and security management from EstesGroup experts.

 

Bryan explained the challenging times that brought on his IT change: “I felt it was too difficult to manage the hardware portion.”

After a nasty ransomware experience two years ago, Bryan set out to find a managed IT service provider and, after many phone calls and after reaching out to multiple vendors, he partnered with EstesGroup. He realized, in his own words, “They had exactly what I was looking for.”

 

Bryan summarized the success of bringing EstesGroup fully aboard for his IT needs: “It’s been an absolute heaven-sent.”

As you will hear in the interview, Bryan has experienced, and thoroughly knows, how difficult server crashes were before EstesGroup began managing his IT. Please listen to Bryan Provo explain various strengths of his partnership with EstesGroup in the following short videos, taken from the full interview with Bruce Grant:

Why EstesGroup Managed IT?

Why EstesGroup Cybersecurity?

Need help with your ERP or IT systems? Contact us today.