Select Page
Best Practices for Evaluating a Next-Generation B2B Platform

Best Practices for Evaluating a Next-Generation B2B Platform

How to Think about E-Commerce as a Manufacturer

E-commerce continues to be a pivotal topic in the manufacturing world – distributors caught on to e-commerce comparatively quickly, as the demand for streamlined processing became a core competency. But in the manufacturing world, where product complexity is many times greater than the items delivered over traditional distribution channels, the acquisition and fulfillment of complete, complex, and high-dollar products becomes much more complicated.

B2B E-Commerce

Manufacturing companies that successfully leverage e-commerce as part of their overall go-to-market strategy do so in a variety of ways and seek to achieve a variety of benefits. That said, I thought it would be beneficial to cover some of the ways in which manufacturing companies are successfully leveraging e-commerce solutions to the benefit of their bottom line and their strategic initiatives.

Expanding Your Spare Parts Business

As a consultant, I once noticed an interesting trend when it came to system configuration – customers routinely spend an inordinate amount of time configuring their ERP system around their finished goods. And then they go live, and we all realize that the vast majority of their orders are not for finished goods but rather for spare parts. In many organizations, these orders amount to a significant revenue stream. Why is that? The margins achieved by service parts, replacement parts, spare parts, and related value streams are generally much higher than they are for finished goods. When a customer is in a bind, their machines are down, and product is not getting out the door, the demand for simple components goes way up, and as a result, the asking price similarly climbs.

To that end, e-commerce systems can streamline the process for finding the right part you need and expediting the fulfillment process, getting the order in the queue, without the need to chase down a customer service rep.

Expedited Warranty Processing

The flip side of the spare parts business is the world of warranty. In these cases, customers need some form of service part to address an issue covered by the original product’s warranty, often at no cost. Deploying your warranty parts to your e-commerce system allows your customer base to get a hold of the parts they need as soon as possible and helps cut down your own warranty costs by reducing the degree of human interaction. The net result is a better overall service offering, without the increase in overhead.

Finished Goods Acquisition

While our discussion has thus far centered on the acquisition of component parts, many manufacturers have extended their e-commerce offerings to include finished goods. I’ve seen customers readily deploy their highly standardized and stocked finished good products to their e-commerce systems, and in doing so, provide another avenue for customer service and order taking. This can be of great value to organizations that cater to both a B2B and B2C community. It can also service the lead-time needs of existing customers – in cases where companies are short-staffed on the order entry / customer service front, an e-commerce connection allows your customer base to get “first in line” when placing an order. In many industries, such a priority can shorten order-to-deliver lead times, which can be of great value to a given customer.

Customer Portal

The ability to stay on top of your orders has become of increasing importance to customers in B2B relationships. This includes but is not limited to orders that were placed online. When a customer places an order, they often expect online status information, to be able to track their orders through the fulfillment process. This can be important both for quick-turn items, where delivery timing is of the essence, or for large, long lead time items, where status at various stages becomes critical to know. E-commerce solutions provide a natural way to provide customers with updates to order status, whether the order was placed online or through a customer service representative. This allows you to provide an easy means of constant status to your customers while saving your own team.

Dealer Interaction

One important customer channel for many manufacturers is the dealer-distributor network. Dealers and distributors are a strange blend of outside sales and end customers, and their needs overlap the two. A goal for many organizations is to make their dealer-distributor network as much an extension of their own organization as possible. How is this done? Through seamless communication, often fostered by an e-commerce-enabled dealer portal. Dealer portals often combine elements of traditional e-commerce with elements that betray the intimacy that dealers need and expect from their manufacturing partners. Are you looking to better service the needs of your dealers and distributors? Give e-commerce a try.

24/7 Customer Service

As you might have noticed, many of the above circumstances have referenced difficulties in getting your order placed. This is surprisingly common, and I am forever shocked and surprised by the challenges many companies have in finding reliable customer service and order processing resources. Customer service is a difficult business, and many workers who might have posted for these roles have found other options. That said, the time it takes for your customers to get their orders into your system and “into the queue” can be a deal maker or a deal breaker. 

Providing an easy means to enter orders and get them immediately into the fulfillment cycle can be an enticing option. Also, in our increasingly remote world, where employees routinely look to get tasks done at odd hours, the ability to provide 24/7 customer service can be of great value to many organizations. When your customer is in a pinch due to an emergency or machine downtime, the ability to immediately get in front of you can be of immense value.

Separating the Best from the Rest

As you can see, e-commerce has grown in breadth and depth over the years to cover an increasing number of avenues and solve a variety of problems for customers. But now that we know what a world-class e-commerce solution can do for you, the question remains: what are the best practices for evaluating a world-class e-commerce solution? In our webinar on October 25th, 2023, our friends at Parttrap can help you see what you need to look for when evaluating an e-commerce solution.

B2B
Unlocking the SYSPRO System Audit Query

Unlocking the SYSPRO System Audit Query

System Audit Query – A SYSPRO ERP Administrator’s Go-To Report for SYSPRO Security Events

Being an administrator of an ERP system is no easy task. Thankfully, SYSPRO ships with several convenient programs that allow an administrator to actively monitor important events that are taking place within the system. One especially useful tool that stands out is the System Audit Query program (IMPJNS).

SYSPRO System Audit Query

SYSPRO System Audit

What You’ll Find in the SYSPRO System Audit Query Program

SYSPRO creates security logs automatically as events take place throughout the ERP. These logs are created to assist system administrators to better manage and review security related incidents in SYSPRO. The System Audit Query program is the place where these logs can be retrieved and analyzed. The program allows you to filter a time period for various security and system health-related events such as:

  • Access having been denied to a company or a program
  • Any security changes made to Groups, Roles, or specific operators
  • Logins attempted and any related error messages
  • Multi-Factor authentication changes or errors
  • System setup changes and activity related to licensing

Along with information about these events, the report can tell you which operator triggered the event, any notes associated with the event, as well as the name of the computer where the activity took place.

SYSPRO Security System Audit Query

One particularly important event that the System Audit Query program can identify for you is client-server disconnects. These are common problems reported by SYSPRO users and they can be highly complicated to investigate. SYSPRO generally has limited information about these events so the System Audit Query log is one of the few places where you can obtain valuable information about when/where they occur.

Along with the use of System Audit Query, you can investigate specific events even further by using the Job Logging Query program (IMPLOG). This program allows you to review and monitor general operator activity throughout SYSPRO.

For instance, if the System Audit Query reports technical issues relating to a specific operator, you can use the Job Logging Query program to analyze whether a specific program or user behavior is the cause of the problem. Be warned that the Job Logging Query program can take a long time to process if you choose to generate the report without filters. In a busy SYSPRO environment with a high number of daily users, the activity logs for operators will be dense and can take time to compile.

SYSPRO Job Logging Query

SYSPRO ERP Job Logging Query

A Day in the Life of a SYSPRO Admin

From the perspective of a SYSPRO administrator, actively monitoring the System Audit Query program is essential for ensuring the integrity of both the overall security and general stability of your ERP environment. The role of an ERP system administrator is undoubtedly challenging, requiring constant vigilance to ensure the smooth operation of crucial business processes.

Fortunately, SYSPRO equips administrators with a range of invaluable tools to actively monitor and maintain the system’s integrity. Among these, the System Audit Query program (IMPJNS) shines as a beacon of efficiency and reliability. With SYSPRO and its robust capabilities, administrators can confidently navigate the complex landscape of ERP management, ensuring their organizations operate seamlessly and securely.

Unlock the Full Potential of SYSPRO ERP Security with EstesGroup! Discover How Our Expert Consulting and Cutting-Edge Cloud Technology Services Can Help Your Business!

SYSPRO UI & Layout Problem Solving

SYSPRO UI & Layout Problem Solving

Troubleshooting user interfaces and personal layout issues in SYSPRO

Throughout the various releases and versions of SYSPRO, user interfaces and layout issues are common. Despite several significant changes to the methods of how SYSPRO stores and saves user settings, these issues are still frequently occurring even in the latest SYSPRO releases. User changes not being saved, pane locations not sticking to where they were configured, and SYSPRO windows appearing off screen are a few of these types of problems. To effectively combat these issues from a SYSPRO administrator perspective, it is important to understand how SYSPRO handles files relating to user settings and program layouts. All these issues begin and end within a folder called “Settings”.

SYSPRO UI User Interfaces Cloud

SYSPRO stores personal operator settings in text files within a folder found both locally on the client machine and on the SYSPRO application server. The folder is called “Settings” and can be found in the following locations:

  • Client machine – “C:\SYSPROClient\Base\Settings”
  • Application Server – “C:\SYSPRO\Base\Settings”
SYSPRO User Interfaces

When a user closes out of SYSPRO on their client machine, any changes made to their layouts or personal settings will be saved to this directory. The client machine syncs the files to the application server and overwrites any non-identical files for that user. The settings are stored on the application server to serve as a backup in case the user gets a new computer or signs in from another machine.

When the user signs in to SYSPRO again, the client machine compares the local setting files to the ones on the application server and restores any missing files or updates existing ones based on the modified date of the files.

As this back-and-forth process takes place, it is possible that settings files become corrupt due to various reasons such as a disconnect between the client and the app server. Thankfully, it is almost always the local files on the client machine that are corrupt and not the ones on the application server. What this means is that it is possible to clear and “refresh” a user’s settings by renaming the client-machine’s “Settings” folder (ex, “Settings_old”). By doing so, SYSPRO notices that the folder is no longer there and recreates a new “Settings” folder based on the files stored on the application server. This is an effective solution to a variety of issues that an operator may experience in a SYSPRO client environment.

Instead of renaming the entire “Settings” folder, it is a good practice to target specific settings files first. For instance, if it relates to an issue within Sales Order Entry (IMP040), you can search the “Settings” folder for IMP040 specific files and try removing those first. When the user signs-in to SYSPRO, the app server files will be restored to the client as they are detected as missing. If this doesn’t resolve the issue, you can then attempt the full renaming of the “Settings” folder.

If you choose to target any specific files, be sure to back them up and restore them to the folder if removing them did not resolve the issue.

Troubleshooting application server file corruption

If corruption is suspected with the application server files, then there is little that can be done in terms of restoring or recovering the user’s settings. As explained above, the app server replaces the files on the client machine in the event of any discrepancies between the user’s settings files. If they are corrupt on the app server, they will transfer and overwrite the local files and remain corrupt. In this case, we recommend seeking support from SYSPRO’s support team itself as modifying the “Settings” folder on the application server can result in potential loss of layouts and user settings for all operators in your SYSPRO environment.

Also, note that SYSPRO is and have actively been updating the amount of information stored on the application server and in the SQL database with each new SYSPRO release. Prior to SYSPRO 8 2021 R1, many types of settings are only stored locally and cannot be restored by the app server. You can try this suggested fix if you are dealing with an older SYSPRO release, however, there is no guarantee that the app server has a copy to restore so the user’s layout may reset to default.

If this fix does not resolve the user’s problem, you can try to either “Repair” or uninstall and reinstall the SYSPRO client on the user’s machine itself. This may help resolve corruption within direct program files unrelated to personal user files. If you renamed the “Settings” folder and it did not resolve the problem, be sure to restore the prior settings folder by renaming the original folder back to “Settings”.

Looking for more help with SYSPRO UI & other ERP system or IT issues? Schedule a free one-on-one consulting session with a SYSPRO ERP or IT consultant today!

Employee Retention: The Attrition Mission

Employee Retention: The Attrition Mission

There’s a significant shift occurring in the job market. And our manufacturing and distribution industries will not escape the impact.

For the past few years, it has been an employer’s market and many workers were unable to find jobs. But that has changed in the last 18 months and there are growing concerns about employee retention.

In the past 5 months, over 15 million US workers have quit their jobs.

Plus, in recent surveys, 40% of employees are considering leaving their jobs in the next 3-6 months. Rather than cooling down, there are projections that more attrition is coming.

There are many reasons this could be occurring. And many strategies to consider. What’s clear is that if your organization is not understanding the root issues, it will increase your employee attrition rate rather than reduce it.

Before we can answer what it takes to retain your best employees, it’s important to understand the dynamics of the situation.

Employee Attrition vs Attraction Recruit and Retain Gears

Differing Perspectives

A recent article, by McKinsey and Company, explored this topic. It noted several disconnects between organizations and employees. These disconnects are likely contributing to employee dissatisfaction.

The article highlights that organizations often focus on increasing compensation and financial perks as a first step to stop employee attrition.

But is that scratching the itch that employees are feeling? What if there is “more at work” (pun intended) than making more money? And if compensation is not the driving issue, how should your organization respond?

Let’s start with the emotional toll of the last 18 months during the pandemic. Behind it we can learn more.

Most employees have experienced rapid change. Illness, online meetings, hospitalizations, new work procedures, vaccines, deaths, politics, changing recommendations, school closings, and daily unknowns have been their daily diet. At work their relationships were frayed by new routines and rules. Constant fear contributed to few social interactions, no get-togethers and limited travel. And with it the use of masks limited our ability to communicate visually.

Employee Expectations

The result has been a change in employee’s work needs. Studies are showing that employees are looking for these benefits in their work:

  1. A sense of value from being in the organization
  2. The potential for advancement
  3. Having caring and trusting teammates
  4. Options for a more flexible work schedule
  5. Feeling more valued by their managers
  6. A sense of belonging

Shared Expectations

Both employers and employees do agree on some things. They both believe that these issues need to be addressed:

  1. Work-life balance
  2. Unmanageable workloads
  3. Feeling disengaged at work
  4. Help with caring for families

Organizational Focus

This leaves us to consider whether employers are right in focusing primarily on these issues which may not be valued by employees:

  1. Creating more opportunities
  2. Accommodating more remote work
  3. Improving the health of employees
  4. Discouraging employees from looking for new jobs
  5. Taking steps to limiting poaching by competitors

Suggested Focus

The McKinsey and Company article recommends that organizations start by listening to employees and including them in discussions. This signals that employees are valued.

That doesn’t happen when management decisions are handed down without employee input. Such decisions are often seen as indicators that management is uncaring and disconnected from employees. And who wants to work in a place like this?

There are positive things that can change the tone in organizations. And they involve asking hard questions about your organization and then moving to address any problems.

  1. Is our organization sheltering toxic leaders who do not value, inspire or motivate their employees?
  2. Are the right people in the right roles in both our management and non-management ranks?
  3. How can we make our culture more collaborative and open to conversations?
  4. How do we replace transactional approaches with relational approaches that stress collaboration and value?
  5. Are our company benefits aligned with employee priorities that are top-of-mind?
  6. What career paths and development opportunities do our employees really have?
  7. How can we build community at work by encouraging better relationships?

From Ideas to Action

Each of these questions focuses on increasing the collaborated relationship across the organization. They send the message that the organization is empowered by trusted relationships and a shared future.

So, what can we say at this point?

First, it is clear is that the employee/employer relationship has changed over the past 18 months. Employees are wanting a more relational approach to their work, more connectivity and more value from their workplace.

Secondly, there are real opportunities for your organization. Those manufacturing and distribution organizations which lead with dialogue and listening will find ways to benefit from the changes.

They will retain top performers because they communicate value, a shared future and positive opportunities.

Now, what can you do to get this moving with your team?

Ask the Author

Rob Mcmillen ERP Consultant

Rob McMillen is a Senior Project Manager with EstesGroup. He has worked in the manufacturing industry for over 30 years supporting multiple implementations of new ERP systems and leading projects. Because his mom was an English teacher, he grew up with a love of writing. Combined with his working experience, he has written articles for LinkedIn and User Groups, and has published numerous blog posts. He is also a co-author of a book on technology and working collaboratively. He currently lives in the DFW area.

Preventing Ransomware in the Automotive Aftermarket

Preventing Ransomware in the Automotive Aftermarket

How to Secure the Automotive Aftermarket

To help develop awareness of cybersecurity needs in the manufacturing and distribution industries, EstesGroup conducted a joint education session with the Specialty Equipment Market Association (SEMA). SEMA is a trade association composed of manufacturers, distributors, retailers and specialists focused on automotive specialty parts and accessories.

Preventing Ransomware in the Automotive Aftermarket

The educational session,“Preventing Ransomware in the Automotive Aftermarket,” focused on the steps that SEMA members can do to mitigate cyber threats. These steps can help any business improve digital security, so I’d like to review some of the material covered concerning the landscape of cyber threats.

What is the Threat?

Threats to organizations are widespread and increasingly prolific. According to the 2021 Malware Report from Cybersecurity Insiders, 88% of a survey of 500,000 IT professionals and 76% of 30,000 small and medium-sized business owners say that cyberthreats are a significant and growing risk. The attack vectors are multifaceted, including spear phishing emails, domain spoofing, and man-in-the-middle attacks.  

Cyberthreats are impacting organizations at all levels. On the business side, malware attacks caused both an increase in IT security-related spending and a decrease in productivity. At the IT operations level, ransomware is forcing cybersecurity professionals to update IT security strategies to focus on mitigation, as they struggle with data loss, downtime, and business continuity.

Watch the Specialty Equipment Market Association (SEMA) of “Preventing Ransomware in the Automotive Aftermarket”

Ransomware Questions, Security Answers

One might beg the question: Why is this happening? The reasons are surprisingly straightforward—the business of cyber warfare is a low-barrier, high-reward enterprise. The “startup costs” for a hacker who already has the necessary technical acumen are comparatively low, when compared to a traditional business environment.

The Reward is a Handsome Ransom

Cybersecurity is not merely an IT problem. It’s an enterprise-wide issue. As business owners, we do things to make our enterprises more integrated and efficient, and share information across the organization. But this creates new potential opportunities for exploitation. Moreover, since March of 2020, we and our fellow employees have been accessing our work environment from an increasingly remote context, further complicating company networks and creating new vulnerabilities.

Where are the Attacks Coming From?

The threats that proliferate our contemporary cyber landscape can be described as “hidden in plain sight” — the threat is as broad as the number of connected users, connected devices, and connected programs. It is not an exaggeration to say that every touchpoint is a potential threat. Some of the most common infiltration paths include the following:

  • Email: Email is a constant target of schemes and scams, and the attacks are getting more nuanced and personalized.
  • The Internet: Online infiltration dressed as information continues to be a source of attacks, with increasing attempts from hackers to disguise malicious domains to appear like the familiar sites that you know and love.
  • Programs & Applications: Within daily business operations, a company uses a surprising number of discrete applications. Whether online or installed on your devices, every program that we use for business purposes is a potential threat.
  • Integrations: The integrating of core systems with third-party applications increases the threat risk. We want the benefits of interconnectivity—for instance, we want our e-commerce system to speak to our inventory system so we know what is available to sell and ship. But in the hands of a hacker, that is a dangerous amount of information to possess.
  • Authentication: The credentials that users apply when accessing company resources can be a significant source of risk. Weak user credentials, simple passwords, and basic authentication policies can allow for significant system breeches.
  • The IOT Movement: The “internet of things” or “IOT” movement increased points of connectivity, and the number of viable targets. Who would have ever thought that you could get hacked by your refrigerator!
  • The BYOD Movement:  The “bring your own device” or “BYOD” movement lowered the bar for device management. Increasingly, smartphones and other devices are accessing social media social media to access system resources.  The risk here should be self-evident.
  • Remote Access: VPNs (or virtual private networks) provide extensive access to company networks. VPNs often provide more access than a user actually needs—it’s like providing access to the entire gymnasium just so you can reach the janitor’s closet.
  • COVID: The pandemic expanded the threat landscape, by increasing the number of remote users connected from a broader array of devices, many of them being inadequately-connected. On a broad scale, shared family devices were suddenly connecting to company headquarters.

The Future of Preventing Ransomware in the Automotive Aftermarket

As you can see, the threats are abundant, and the targets are many. The future of security in the automotive aftermarket depends on you and on your cybersecurity strategy. There are some simple steps that companies can take to mitigate the challenges of our current cyber landscape. To see what companies are doing to secure their organizations from threats, and what you can do to secure your future, please watch the recording of the SEMA educational session and come to our managed IT experts with any questions you have about current best practices for threat mitigation for businesses.

Let’s talk about cybersecurity and compliance regulations specific to your industry. Chat with us now to schedule a free technology assessment.

Manufacturing in America, Made in Colorado

Manufacturing in America, Made in Colorado

Made by Colorado Manufacturers

Like many areas in the US, the Colorado manufacturing scene has been scrambling to adjust to the ongoing movement of the pandemic and its aftershocks. Changes in demand, fluctuations in labor, and radical shifts in supply and availability have resulted in new and unexpected challenges, and manufacturers across the state have, out of necessity, worked to devise clever solutions to a shifting array of problems. 

Made in Loveland Colorado

Made at the NOCOM Manufacturing & Trades Show

The NOCOM Manufacturing and Trades Show 2021 conference, coming soon to the Larimer County Fairgrounds in Loveland, exemplifies one such clever strategy, which is actually an old methodology that we sometimes forget we have — in-person, mind-to-mind, heart-to-heart collaboration. It’s this type of energy that has not only kept the manufacturing industry afloat during the pandemic, but also allowed many of us to survive the seemingly endless virtual office hours.

At the recent P21 CONNECT conference, an in-person Epicor Prophet 21 user event, I realized how much I missed the benefits that come from being able to gather under the guise of a common association. There is a surprising amount of value that can be gained by the act of simple collaboration.

There are great benefits to sharing challenges facing one company (or an entire industry), and it often takes a community to surface the steps needed to prevail. Together, companies can work to delineate the quick and effective measures that can be taken and perform the actions required for mitigating risks. In the distribution industry, with community knowledge at the core, Prophet 21 consulting is largely revolving around supply chain issues, cybersecurity threats, and the shift from on-premise servers to cloud-based technology. 

As we’ve seen in our preparation for NOCOM 2021, the manufacturing industry is facing similar challenges: supply and demand shifts, ransomware and malware threats, and cloud availability amid outdated technology trends. 

So, what is your manufacturing strategy, and how has the pandemic changed community involvement in your business culture?  

The sharing of the intellectual property of daily problem solving is something that just didn’t translate into online forums and Zoom calls. As we stagger back into some semblance of “normal” life, we look once again to share the value of in-person business meetings and socialization.  

As we’ve faced together more than a year of volatility, we’ve learn that the solutions to problems in one industry might have applicability in another. We’ve learned that our problems may not be things that we have to bear on our own. In manufacturing and distribution, the ability to adapt quickly results in success. 

There’s an old saying that goes “you are your friends” or “you are only as good as your friends.” In enterprise resource planning (ERP) consulting, we learn from our friends, so that we can adapt and succeed in our projects. 

What can we learn from our friends as the Colorado manufacturing industry reopens?

The “Made in America” movement continues to find new applicability, as companies struggle to supply products locally, products that have been historically outsourced. The reactions are inconsistent — in some commodities, I hear of manufacturers and supply chain companies switch back to offshore supply as soon as it becomes available.  

In other cases, I discover commodities that may remain in North America after the dust has settled. Increasingly, I stumble across products that have been crafted in Colorado, products new to the state. Colorado, like the rest of the nation, is learning to make things again, and this is one adaptation that you’ll see in the NOCOM community, whether you’re still following along from your virtual office or attending the in-person event this year. 

Next week, EstesGroup will once again be returning to NOCOM in person. While we had fun at the virtual conference last year, we’re looking forward to the friend-to-friend interactions that can only be present while walking together, sharing dinner together, exchanging stories together. Providing cloud and IT services for manufacturers and distributors throughout the pandemic has taught us much about the resolve of the nation as we work with the companies as they reshape themselves to take on the needs of a reopening world.

If you are a manufacturer facing the challenges of reopening in 2021, 2022, and beyond, EstesGroup’s ERP and IT consultants would love to help you understand industry trends. Our team will be at NOCOM 2021 BOOTH 62 on September 23rd, and we’re hoping to see you there!

Are you a manufacturer struggling with cyberthreats? We fully support manufacturers remotely and in person! Our coast-to-coast consultants circle out from our Loveland office, supporting Colorado manufacturing and beyond, even throughout Canada!