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!

Elastic Computing Revolutionizes Business Dynamics

Elastic Computing Revolutionizes Business Dynamics

Cloud Resources are Changing the Manufacturing and Distribution Industry Landscapes

In the world of cloud options for businesses, elastic computing refers to the ability to dynamically scale computing resources up or down based on demand, without the need for significant manual intervention. It involves the use of cloud computing and virtualization technologies to provide flexibility and cost-efficiency in managing IT infrastructure. This allows for greater flexibility and scalability, as resources can be easily scaled up or down based on dynamic business needs. Cloud computing also eliminates the need for organizations to invest in and maintain their own physical infrastructure, such as on-site servers, reducing costs and increasing efficiency.

Elastic Computing Cloud Servers

What is Virtualization?

Virtualization, on the other hand, involves creating a virtual version of a device or resource, such as a server, operating system, or storage device. This virtualization technology allows multiple virtual instances to run on a single physical machine, effectively maximizing the utilization of hardware resources. By consolidating multiple virtual machines onto a single physical server, organizations can reduce the number of physical servers required, leading to cost savings in terms of hardware, power, and cooling.

Bringing Cloud and Virtualization Together

When combined, cloud computing and virtualization technologies offer numerous benefits for managing IT infrastructure. Firstly, they provide flexibility in terms of resource allocation. With cloud computing, organizations can easily scale up or down their computing resources based on their needs, ensuring that they have the right amount of resources at any given time. Virtualization allows for the efficient utilization of hardware resources, enabling organizations to make the most of their existing infrastructure.

Pay-As-You-Go, Quick-To-Market Technologies

At the end of the day, new cloud-based technologies offer cost savings throughout the entire business ecosystem. By leveraging cloud computing, organizations can avoid the upfront costs associated with purchasing and maintaining physical infrastructure. Instead, they can pay for the resources they actually use on a pay-as-you-go basis. 

Virtualization further reduces costs by allowing organizations to consolidate their hardware resources, reducing the number of physical servers required and the associated costs of power, cooling, and maintenance.

Additionally, cloud computing and virtualization technologies enhance the agility and scalability of IT infrastructure. With cloud computing, organizations can quickly provision and deploy resources, allowing for faster time-to-market for new applications and services. Virtualization enables organizations to easily scale their infrastructure up or down based on demand, ensuring that they can meet changing business needs without disruption.

Furthermore, these technologies improve the reliability and availability of IT infrastructure. Cloud computing providers typically offer robust infrastructure with built-in redundancy and failover mechanisms, ensuring high availability of services.

Virtualization also enhances reliability by isolating virtual machines from each other, preventing issues in one virtual machine from affecting others.

The use of cloud computing and virtualization technologies in managing IT infrastructure provides organizations with flexibility, cost-efficiency, agility, scalability, reliability, and availability. By leveraging these technologies, organizations can optimize their resource utilization, reduce costs, and improve their overall IT operations. Here are the top 10 benefits of elastic computing for manufacturing and distribution businesses:

Scalability

Elastic computing allows businesses to easily scale their IT infrastructure to accommodate fluctuating demand, ensuring that resources are available when needed without over-provisioning.

Cost Efficiency

By scaling resources up or down as required, businesses can optimize their IT costs, paying only for the computing power they actually use, reducing overall expenses.

Resource Optimization

It enables efficient use of computing resources, avoiding underutilization during periods of low demand and preventing resource bottlenecks during peak periods.

Improved Performance

Elasticity ensures that applications and systems can maintain consistent performance levels even during traffic spikes or increased workloads.

Flexibility

Businesses can quickly adapt to changing market conditions or unexpected events, such as seasonal variations in demand or unforeseen disruptions by adjusting computing resources in real time.

Reduced Downtime

Elastic computing minimizes the risk of system failures or downtime due to resource constraints, as additional resources can be provisioned automatically in response to increased load.

Enhanced Disaster Recovery

Elastic computing can support robust disaster recovery and backup solutions, enabling businesses to replicate their systems across multiple locations or cloud regions for data redundancy and resilience.

Global Reach

Businesses can leverage cloud providers’ global data center networks to expand their operations into new regions and markets without the need for physical infrastructure investments.

Resource Isolation

Elastic computing can provide resource isolation and security, ensuring that applications and data remain protected even when sharing cloud infrastructure with other users.

Agility and Innovation

With the ability to rapidly provision and experiment with new resources and technologies, businesses can innovate more quickly and bring new products or services to market faster.

The Value in Cloud Elasticity

In manufacturing and distribution, elastic computing is particularly valuable because it allows companies to handle seasonal demand fluctuations, respond to supply chain disruptions, and efficiently manage their IT costs. In today’s fast-paced and ever-changing marketplace, businesses need to be agile in order to stay competitive. This means being able to quickly adapt to new trends, technologies, and customer demands. Agility allows companies to respond swiftly to market changes, seize new opportunities, and stay ahead of the competition.

However, agility alone is not enough. Businesses also need to ensure the reliability and performance of their critical systems. These systems are the backbone of the organization, supporting key operations and processes. Any downtime or performance issues can have severe consequences, such as lost revenue, damaged reputation, and dissatisfied customers.

By combining agility with reliability and performance, businesses can achieve a winning formula. They can swiftly respond to market changes while maintaining the stability and efficiency of their critical systems. This requires a careful balance between innovation and stability, as well as a robust infrastructure and effective risk management strategies.

Agility enables businesses to quickly adapt their strategies, products, and services to meet changing customer needs and preferences. It allows them to experiment, iterate, and pivot as necessary, without being tied down by rigid processes or outdated technologies. This flexibility is crucial in a dynamic marketplace where customer expectations are constantly evolving.

On the other hand, reliability and performance ensure that businesses can deliver on their promises consistently. Customers expect products and services to work flawlessly, without any disruptions or delays. Critical systems, such as e-commerce platforms, supply chain management systems, or customer support systems, need to be highly available, scalable, and efficient. This requires robust infrastructure, rigorous testing, and proactive monitoring to identify and address any issues before they impact the business.

Why Manufacturers and Distributors are Choosing EstesCloud

Businesses need both agility, reliability, and performance to thrive in today’s dynamic manufacturing and distribution industry landscape. Agility allows companies to adapt and innovate, while reliability and performance ensure that their critical systems can support their operations effectively. By striking the right balance between these two factors, businesses can remain competitive, deliver exceptional customer experiences, and achieve long-term success.

Ready to move your business to the cloud? In the cloud and ready for a better cloud environment?

Cloud Hosting Epicor Kinetic ERP Logo
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!

SYSPRO Data Integrity: A Guide to Balance Functions

SYSPRO Data Integrity: A Guide to Balance Functions

How to Ensure Data Integrity Within SYSPRO – Balance Functions Explained

Ensuring data integrity is a top priority for any software product, especially for an ERP such as SYSPRO. As users go about performing their daily activities, various problems can arise, even with the most mature ERP systems. The most common issues seen within SYSPRO that can lead to data instability are users being disconnected, programs freezing up, or business objects unexpectedly stopping in the middle of processing. With tens (or potentially hundreds) of daily active users, it is imperative for your business that the data within SYSPRO stays consistent. So how does SYSPRO combat data integrity problems and maintain the overall stability of its data? The answer is SYSPRO balance functions!

SYSPRO Data Integrity Balance Functions

A balance function in SYSPRO is a detailed process used to correct and adjust database information if discrepancies are detected. They are built in to SYSPRO’s Period-End programs and are supposed to be run prior to posting GL entries or performing Month-End/Year-End tasks. SYSPRO’s balance functions can help “balance” a module by comparing user transaction data to its own control totals and correcting any noticed discrepancies. Some examples of these discrepancies that it can correct include:

  • GL journal entries that have not been properly completed or are still marked with “in-process” flags if they were abandoned. Users unexpectedly disconnecting from the system can be a cause of this.
  • Failed inventory transactions. Minor hiccups from bugs or networking issues during inventory transactions can result in inaccurate inventory counts. For example, a stock code may display as having available quantity on-hand but an attempt to issue or release the quantity results in errors.
  • Specific key documents being locked down by users for maintenance that fail to be released once complete. Again, a potential result of unexpected user disconnects or program errors. These are commonly encountered within sales/purchase order entry and customer/supplier setups programs.

Scheduling SYSPRO Data Integrity Tasks

While most SYSPRO environments generally only run these balance functions during their period-end tasks, it is strongly recommended to schedule balance functions to run regularly. Sites with heavy user activity (including custom business object activity) may want to run balance functions overnight several days throughout the week. The result of this will be an improved and overall smoother SYSPRO experience for all users.

Balance functions are not found separately within their own respective program. Instead, they are usually part of and located within period-end programs. The naming convention of some of these programs may not be clear and it is not easy to identify all of them. As such, here is a full list of the programs within SYSPRO that contain or can perform the functionality of a “balance function”:

  • AP Period End
  • AR Period End
  • AR Bank Deposit Slip
  • Cash Book Period End
  • Assets Period End
  • Inventory Period End
  • Sales Order Purge
  • Purchase Order Purge
  • GRN Purge
  • Sales Analysis Update

It is imperative to understand that some of these programs contain critical data-altering functionality within SYSPRO relating to period-end module closures or purging of data. You should tread with caution when accessing these programs and ensure you only have “Balance” selected. NOT any unwanted options pertaining to period-end and/or data purge functionality! 

Some of the above-listed programs may have an option called “Reset lowest unprocessed journal”. As it is not always checked by default, it is recommended to enable this option prior to executing a balance function. It performs an additional data-stability feature intended to fix GL journal issues. 

SYSPRO Data Integrity Balance Functions AR Period Example

SYSPRO environments that are not familiar with the power of balance functions can (and will) encounter unwanted issues and potentially unstable data problems. Knowing how to utilize, execute, and schedule balance functions is key to ensuring your SYSPRO environment’s data remains both stable and trouble-free.

Ready to discover how an EstesGroup ERP consultant tackles data integrity challenges & ensures your company’s success? Chat with us now & sign up for a free demo to see what your business would look like in EstesCloud!

How to Use SYSPRO Form Actions

How to Use SYSPRO Form Actions

SYSPRO Customization Station

When it comes to Enterprise Resource Planning (ERP), SYSPRO is the ultimate software choice for manufacturing and distribution companies in search of flexibility and customization. EstesGroup has an expert understanding of the SYSPRO User Interface, and our team of IT professionals is ready to help your company understand your applications and your functionality. Form actions are an important aspect of the SYSPRO User Interface that are very beneficial to your users. By understanding SYSPRO form actions, specifically how to add, remove, and customize them, users will be able to realize the full benefits of your ERP application.

SYSPRO ERP CLOUD FORM ACTIONS

What is a SYSPRO Form Action?

The SYSPRO User Interface includes implemental form actions that facilitate easier display and data entry in SYSPRO applications for its users. Form actions are “user-definable hyperlinks”, and users can find these form actions in the Action Panel at the bottom of the form.

In terms of functionality, users can configure form actions to identify a SYSPRO program and advance its parameters. Form actions are also important in initiating and advancing VBScript events.

The SYSPRO User Interface has great flexibility in allowing many form actions for each form as well as customized combinations of types. Users can display or hide form actions on a form, and hiding a form action does not negate the form action’s VBScript functionality.

Form Action Benefits for Users

SYSPRO’s User Interface is truly flexible and customizable, especially when your ERP system is deployed in EstesGroup’s Estes Cloud Hosting (ECHO) environment, positioned in our top-tier, highly secure data center. Form actions benefit SYSPRO users in many important ways including:

  • Adding program shortcuts
  • Removing program fields
  • Customizing program fields
  • Easy display and data entry
  • Quicker data entry
  • Data entry verification

How SYSPRO Users Can Utilize Form Actions

How to Add

Once users begin to interact with SYSPRO, understanding how to add a program shortcut will help streamline the experience and save time. In order to add a program shortcut on the same screen, users should follow these basic steps:

  1. Locate the SYSPRO screen where a shortcut is needed (e.g. stock codes).
  2. Select the desired field property you would like to add a shortcut to, and click on “insert form action”.
  3. Add the appropriate cross-reference.
  4. Once the screen is closed, the shortcut is saved.
  5. Open the field property and verify that the shortcut has been successfully added to the SYSPRO screen.

How to Remove

SYSPRO facilitates the easy removal of form actions if users would like to change or remove an improper shortcut. In order to remove a form action in a SYSPRO screen, users should follow these basic steps:

  1. First, locate the SYSPRO screen where a form action removal is needed (e.g. stock codes).
  2. Next, locate the form action on the SYSPRO screen.
  3. Select “add cross-reference”.
  4. A display box will appear. Select “yes” to confirm removal of the form action.
  5. Once the screen is closed, the form action removal is saved.
  6. Finally, visit the SYSPRO screen to verify that the cross-reference shortcut is no longer available.

Simplifying Your Business With ERP Customization

SYSPRO makes data entry, verification, and manipulation of form actions easy. Users will enjoy the benefits that the ERP system provides with its streamlined and time-saving processes regarding form actions, specifically adding and removing shortcuts.

Beyond this basic understanding of the SYSPRO User Interface and form actions, EstesGroup is available to help users understand these processes in even greater detail. EstesGroup’s ERP and IT professionals are available at any time of the day to assist users with their ERP software needs and questions.

Watch Our Happy Customers Discuss Their ERP Journeys