Select Page
SYSPRO ERP Utilities – Utilizing the Data Dictionary Viewer

SYSPRO ERP Utilities – Utilizing the Data Dictionary Viewer

SYSPRO’s Data Dictionary: Efficient ERP Database Management

Software systems such as Enterprise Resource Planning systems (ERPs) consolidate so much functionality into a single application. This means that the database structure they work with is equally as encompassing and can be overwhelming to familiarize yourself with. SYSPRO alone uses over 1000 database tables and knowing exactly where to look for certain can be a tough challenge. Thankfully, SYSPRO has a built-in tool called the “Data Dictionary Viewer” that can help put descriptive labels on otherwise complicated database elements. 

You can find the Data Dictionary Viewer program in SYSPRO’s program list by going to Utilities Data Dictionary Viewer.  The program will load a list of all tables in your SQL Server database. Along with the table names and file codes, it will include descriptions to highlight what the purpose of the table is. The list is long so to help you find the exact table you are looking for you can use CTRL + F to open a “Search” tab. You can then type in parts of what you are looking for and SYSPRO automatically filters the list. 

SYSPRO Data Dictionary

Data Dictionary Going Deeper

To go a level deeper, you can highlight a table record and click the “Table Properties” toolbar button. This will open a new window with details about the table, its columns, and key structure. The information found on this screen can be particularly helpful if you are creating custom reports but can’t figure out which exact field contains the data you are looking for. 

SYSPRO ERP Data Dictionary

Leveraging SQL Querying Tools in SYSPRO for Enhanced Data Management

While the program also contains a feature to display the data found in the database table, we recommend you instead use actual database tools. The built-in tool is no replacement for proper SQL querying tools. Many tables in SYSPRO can have a significant number of columns and not to mention millions of data records based on your business’ usage of SYSPRO. Using SQL to query and filter will make it much easier to navigate this data. 

What Does the SYSPRO Data Dictionary Viewer Do?

The Data Dictionary Viewer enables both SYSPRO experts and newcomers to quickly find and learn about the database tables that contain the data held within SYSPRO ERP. Next time you build a custom report or macro script, try using this tool and see how easy it can be to narrow down a massive database to exactly the few datapoints you need!

 

SYSPRO ERP Utilities, particularly the Data Dictionary Viewer, stand as indispensable aids in navigating the intricate landscape of database structures within the system. With over a thousand database tables to contend with, the challenge of pinpointing specific data elements can be daunting. However, the Data Dictionary Viewer offers a solution, providing descriptive labels and organizational tools to streamline the process.

By accessing this tool through SYSPRO’s program list and utilizing features such as table properties and search functionality, users can gain deeper insights into the database architecture, facilitating tasks like report generation and macro scripting. While the built-in feature for displaying data may suffice for some purposes, the recommendation to leverage dedicated SQL querying tools underscores the complexity and scale of SYSPRO’s database infrastructure.

How EstesGroup Helps Customers With SYSPRO

Ultimately, the Data Dictionary Viewer serves as a bridge between SYSPRO experts and newcomers, empowering them to efficiently harness the wealth of data housed within the ERP system for enhanced decision-making and operational efficiency. Embracing this tool can unlock new levels of productivity and precision in leveraging SYSPRO’s capabilities, ensuring that users can extract meaningful insights from the vast expanse of data at their disposal.

For businesses seeking comprehensive support in optimizing their SYSPRO ERP system and navigating its intricate functionalities, EstesGroup offers a wealth of expertise and tailored solutions. Our team of SYSPRO consultants brings extensive experience in database management, including proficient utilization of tools like the Data Dictionary Viewer to streamline operations and drive efficiency. 

Beyond database management, EstesGroup provides a wide array of IT services, encompassing cloud solutions, cybersecurity measures, system integrations, and more. Whether it’s implementing customized reports, fine-tuning database configurations, or migrating to cloud-based infrastructures, our consultants are equipped to address diverse needs and challenges. With a commitment to delivering holistic support and maximizing the value of SYSPRO ERP investments, EstesGroup stands ready to empower businesses on their digital transformation journey.

SIGN UP FOR A CLOUD DEMO TODAY

"*" indicates required fields

Name*
Email*

EstesGroup Champions Data Privacy Week 2024

EstesGroup Champions Data Privacy Week 2024

EstesGroup proudly announces its commitment to Data Privacy Week 2024 as a Champion. This initiative underscores the importance of educating businesses on best practices for data collection that respect privacy and promoting transparency in data handling.

Data Privacy Week

Security Means Privacy

In addition to its commitment to Data Privacy Week, EstesGroup reinforces its dedication to data security through SOC 2 (Service Organization Control 2) certification. Achieving SOC 2 compliance is a testament to EstesGroup’s commitment to maintaining the highest standards in information security, confidentiality, and privacy. This certification assures clients and partners that EstesGroup has implemented rigorous controls and procedures to safeguard their sensitive data. 

With SOC 2 compliance, EstesGroup not only prioritizes data privacy but also demonstrates a proactive approach to ensuring the security and integrity of the systems and services it provides to all business, including the most complex manufacturers and distributors. This certification further underscores EstesGroup’s unwavering commitment to delivering reliable and secure IT and cloud solutions to its clientele.

Data Privacy Day vs. Data Privacy Week

Data Privacy Week 2024, an extended effort stemming from Data Privacy Day, takes place from January 21 to 27, 2024. The primary objective of this week-long campaign is to raise awareness about online privacy for both individuals and organizations. It aims to empower citizens by highlighting their ability to manage their data while emphasizing the significance for organizations to responsibly steward personal information

In today’s digital age, data is the lifeblood of success. At EstesGroup, we are not just embracing Data Privacy Week, we are championing it because we recognize the critical role data plays in driving business growth. Our commitment goes beyond compliance – it’s about empowering businesses with the knowledge and tools to safeguard their most valuable asset: the people behind the data. By participating in Data Privacy Week 2024, we affirm our dedication to being stewards of your trust. Together, let’s navigate the digital landscape with confidence, ensuring that your data remains secure and your business poised for lasting success.

How to Take Control of Your Business Data

As part of our commitment to Data Privacy Week, EstesGroup encourages individuals to take control of their data. In an era where online activities generate extensive data trails, it is crucial to be mindful of the information shared. This includes personal data such as Social Security and driver’s license numbers, as well as health data collected by devices like smartwatches. While complete control over data processing may not be possible, individuals have the power to make informed decisions about sharing their data.

EstesGroup offers the following steps to empower individuals in managing their personal information:

  • Be Informed: Understand the types of data collected about you.
  • Review Privacy Settings: Regularly check and update privacy settings on websites and apps.
  • Limit Data Sharing: Be selective about sharing personal information and consider the necessity.
  • Protect Passwords: Use strong and unique passwords to enhance data security.

Data Privacy Week is a reminder that digital transformation is a necessary step toward maintaining privacy and security in a world where ransomware is becoming more prevalent. EstesGroup recognizes the value of personal data and encourages everyone to be discerning about data management. 

EstesGroup offers a comprehensive suite of managed IT services designed to equip businesses with the essential tools needed to thrive in today’s dynamic digital landscape. Our services encompass a wide range of critical areas, ensuring holistic support for optimal IT performance. 

From robust cybersecurity measures and data backup solutions to proactive network monitoring and efficient cloud services, EstesGroup tailors its managed IT services to meet the unique needs of manufacturers and distributors. Our expert team collaborates with clients to implement cutting-edge technologies, streamline operations, and enhance overall IT efficiency. 

By providing services such as IT infrastructure management, software updates, and responsive technical support, EstesGroup empowers businesses to focus on their core operations while maintaining a secure and resilient digital environment. 

With our comprehensive suite of managed IT services, EstesGroup stands as a trusted partner in navigating the complexities of the modern digital landscape and ensuring sustained success for our clients.

For more information about Data Privacy Week and how to get involved, please visit Data Privacy Week.

About EstesGroup

EstesGroup is a prominent ERP, IT, and cloud services firm, dedicated to providing comprehensive solutions for manufacturers and distributors. With a commitment to excellence, EstesGroup empowers businesses with innovative technologies to drive growth and success.

About Data Privacy Week

Data Privacy Week originated as Data Privacy Day in the United States and Canada in 2008, extending the celebration of Data Protection Day in Europe. Commemorating the signing of Convention 108 on January 28, 1981, the week is an annual effort led by the National Cybersecurity Alliance (NCA) to promote privacy and data protection awareness.

About the National Cybersecurity Alliance

The National Cybersecurity Alliance is a non-profit organization on a mission to create a more secure and interconnected world. Advocating for the safe use of technology, the NCA educates individuals on protecting themselves, their families, and organizations from cybercrime. For more information, please visit National Cybersecurity Alliance.

Frenetic to Kinetic: 5 Tips for Epicor Kinetic Upgrades

Frenetic to Kinetic: 5 Tips for Epicor Kinetic Upgrades

Transforming ERP Upgrades into Smooth Operations

As your manufacturing company considers upgrading its current Enterprise Resource Planning (ERP) system to Epicor Kinetic, the prospect of navigating potential challenges and complexities might seem daunting. However, with the right approach, this transition to advanced enterprise software can be a smooth and beneficial process for your organization.

Epicor Kinetic Upgrades ERP Project

Preparation for ERP Upgrade Team Success

Begin by thoroughly preparing for the transition to Epicor Kinetic. Evaluate your ERP needs, customize the solution to align with your requirements, and identify any redundant aspects of your current system. Gain a comprehensive understanding of Kinetic’s new features and formulate a detailed upgrade plan tailored to your company.

Utilize Documentation for a Stress-Free Epicor Upgrade

Leverage available documentation and industry best practices to make the upgrade to Kinetic a stress-free experience. Conduct an initial consultation to walk through the planning and upgrade process, ensuring your team is well-informed and prepared for the transition.

Adopt a Three-Stage Approach to All ERP Upgrades

Implement a three-stage approach to streamline the upgrade process. Develop checklists, tools, and data fixes that align with the flexibility and customization needs of your current system. This approach minimizes disruptions and ensures a seamless transition during each stage of the upgrade.

Harness the Power of ERP Upgrade Tools

Prior to your upgrade, use tools to identify necessary customizations and anticipate potential obstacles. Post-upgrade, utilize tools to understand your new configurations and operating system. This analytical approach enables your team to make well-informed decisions throughout the transition. Software is alive, and Epicor Kinetic upgrades often become part of a holistic digital transformation process, and the abundance of tools will help your team optimize every digital step. 

Invest in Employee Learning for Optimal Performance

Maximize the performance of your updated system by investing in employee learning. Develop a comprehensive training plan to ensure that your staff can fully utilize the functionality of the new Epicor Kinetic system. Proactively schedule training sessions to facilitate a smooth transition and enhance overall workflow and productivity.

By adopting these strategies and focusing on internal capabilities, your manufacturing company can smoothly transition to the Kinetic upgrade. Navigate each step with careful planning, industry knowledge, and a commitment to optimizing your ERP system for enhanced efficiency and productivity. Embrace the benefits of a newly customized system without hesitation, and position your company for success with Epicor Kinetic.

Totaled Tip: Choose Your ERP Cloud Wisely So You Don’t Crash

When considering the Epicor Kinetic upgrades, businesses often find themselves deliberating between the private cloud deployment and the Software as a Service (SaaS) web-browser version. The private cloud option provides companies with a dedicated environment, offering greater control over customization, security, and data management. It is an ideal choice for organizations with specific compliance requirements or those seeking a tailored solution. On the other hand, the SaaS web-browser version, being a cloud-based option, offers flexibility and accessibility. With this model, businesses can benefit from reduced infrastructure costs, automatic updates, and seamless scalability. The decision between private cloud Kinetic and SaaS depends on factors such as organizational needs, preferences, and the level of control desired. While private cloud ensures a more personalized approach, SaaS brings the advantages of convenience and agility in adapting to evolving business requirements.

Are you looking for help with Epicor Kinetic upgrades and updates?

Chat with us now for immediate help, or schedule a free introductory consultation with one of our Epicor experts.

Freight Forward to the Future: P21 Web UI Migration Options

Freight Forward to the Future: P21 Web UI Migration Options

Transitioning to the P21 Web UI Version

Keeping your Prophet 21 ERP system up to date poses numerous challenges, especially when dealing with upgrades. The testing, retesting, troubleshooting, and remediation processes can be time-consuming and demanding. Transitioning to the P21 Web UI introduces even greater challenges, with larger changes, increased risks, and heightened frustrations for end users. Consequently, the adoption of the P21 Web UI has been progressing slowly, akin to molasses in January, as they say in Canada.

Prophet 21 P21 Web UI Migration Distribution Warehouse

In November, EstesGroup sponsored the Southeast User Group chapter of the P21WWUG, presenting on P21 Infrastructure Best Practices and the elusive topic of Web UI Migrations. Our polls revealed that two-thirds of customers have yet to fully migrate from the P21 desktop application.

For customers still tethered to a desktop version seeking a way out, we recommend two approaches when planning a P21 Web UI migration: incremental or big bang.

An Incremental Approach

For those committed to the last branched version (2021.1) and hesitant to fully transition from the P21 desktop, an incremental approach is advisable. The customer creates an ecosystem as a live testing model, gradually shifting from the old to the new through the following steps:

  • Develop an adoption plan for “branched” usage, initially allocating specific hours for web UI use.
  • Configure a branched deployment in the live environment, allowing parallel use of desktop and web UI.
  • Instruct users to incrementally operate on the web UI during designated hours.
  • Address reported shortcomings incrementally through IT or ERP administrator intervention.
  • Create a remediation work plan for identified issues and initiate resolution.
  • Conduct remediation and testing cycles until all issues are resolved.
  • Increase web UI usage until reaching a predefined cutoff amount of time.
  • Attain user and management signoff, and officially transition all users to the web UI.
  • Stabilize the live cutover environment and provide ongoing support.

A Big Bang Approach

For customers seeking a more significant leap to a web-only version (2022+), the big bang approach is recommended. This involves an implementation-level cutover executed in one decisive move:

  • Deploy the Web UI to a middleware-only test environment.
  • Conduct user testing, addressing and communicating issues as they arise.
  • Create a remediation work plan and resolve identified issues.
  • Document remediations and compile into a cutover plan, expanding the testing pool.
  • Conduct a mock cutover (CRP), regression testing, and address any remaining issues.
  • Attain user and management sign-off for the “go live” decision.
  • Repeat the cutover to the new version in the live environment with Web UI.
  • Stabilize the live cutover environment and provide ongoing support.

The Weight (and Freight) of Risk in P21 Migrations

The choice between incremental and big bang approaches depends on your risk tolerance and desired rewards. If you seek to minimize risks, choose the incremental approach. For maximizing rewards, opt for the big bang. Each approach comes with its own set of risks, rewards, and characteristics. If you need assistance with your Web UI Migration, please reach out to us!

Connecting the Clouds: Website vs. ERP Hosting

Connecting the Clouds: Website vs. ERP Hosting

Manufacturers and distributors can benefit significantly from a Managed Services Provider (MSP) managing one website or kin websites as part of an integrated IT services, IT security, and enterprise cloud strategy. An external IT provider ensures that the world will view web-based company representation with optimal performance, scalability, and security, reduced downtime and enhanced user experience. Through robust IT security measures, a cloud provider like EstesGroup safeguards sensitive data, mitigating the risk of cyber threats. Additionally, integrating enterprise cloud solutions facilitates seamless data access, collaboration, and scalability, enabling manufacturers and distributors to focus on core business functions while staying agile and competitive in the digital landscape.

Website vs ERP Hosting

For businesses, websites serve as crucial repositories for sharing information, necessitating proper hosting and data management to connect with customers, ensure security, and facilitate growth. When exploring website hosting services and ERP hosting solutions, businesses encounter various cloud options, with managed hosting and shared hosting being the primary types. Understanding the distinctions in the website vs. ERP hosting conversation empowers businesses to make informed decisions aligning with their unique identities.

Is your website hosting forgotten data?

While your IT team is focusing on critical tasks, your website might go unnoticed, opening the path to vulnerability and chaos. In the realm of website hosting, discerning between managed hosting and shared hosting is essential. Managed hosting is ideal for businesses seeking comprehensive control and responsibility, with the service provider acting as a dedicated IT department overseeing all aspects of the website. Conversely, shared hosting accommodates businesses needing performance and security but may lack the size or budget for full-service management. Multiple businesses share resources like RAM and CPU under a shared server, potentially impacting performance during traffic surges. Managed hosting suits larger enterprises prioritizing ultimate performance and security, while shared hosting remains viable for budget-conscious smaller businesses.

Managed Hosting vs. Shared Hosting vs. Managed ERP Hosting

Businesses should consider several key differences between managed and shared hosting for websites and ERP hosting for enterprise resource planning applications. Here are a few things to keep in mind as you unravel your web of business data.

  • Resources: Managed hosting provides dedicated server resources, ensuring optimal performance, while shared hosting involves resource-sharing, potentially leading to performance issues during high traffic.
  • Customization: Managed hosting offers customized solutions, tailored to specific business needs, whereas shared hosting tends to be more one-size-fits-all.
  • Security: Managed hosting prioritizes security, protecting individual businesses, whereas shared hosting may compromise security if one business on the shared server experiences a breach.
  • Optimal Performance: Managed hosting eliminates performance issues associated with shared resources, providing consistent and optimized performance.
  • Updates: Managed hosting ensures prompt updates and security patches, while shared hosting may require businesses to schedule updates themselves.
  • Email: Both hosting types offer email services, with managed hosting providing premium plans for enhanced features.
  • Cost: Shared hosting is more affordable, making it suitable for smaller businesses with budget constraints, while managed hosting, though more expensive, offers superior performance and security.

How ERP Hosting Gets Tangled in Your Website Web

The discussion on website hosting parallels ERP hosting, where businesses can opt for a managed service provider to host their ERP software in a remote, cloud-based data center. This centralized approach provides cost-effective, secure, and scalable solutions, enabling businesses to focus on operations rather than maintaining on-premise infrastructure.

Businesses must comprehend the disparities between the many available cloud options to make informed choices for their website and ERP hosting needs. While managed hosting excels in performance, security, and support, startups or small businesses with budget constraints may consider shared hosting initially. Managed hosting proves invaluable for businesses seeking to eliminate on-premise responsibilities, allowing them to concentrate on optimization and growth.

Complex Cloud Hosting Environments

Experience seamless business operations with our fully managed ERP hosting, ensuring optimal performance, security, and scalability as we take charge of your ERP software in a secure, remote, and cloud-based environment. Ready to tackle website vs. ERP hosting? Elevate your online presence with our fully managed website hosting, where a dedicated IT team handles every aspect, providing tailored solutions for peak performance, robust security, and unmatched support. Trust EstesGroup to streamline your technology infrastructure, allowing you to focus on growth and innovation without the burden of managing complex hosting environments.

SYSPRO Error Message: Operator Already Logged In

SYSPRO Error Message: Operator Already Logged In

A warning message that most SYSPRO users will commonly see is the “Operator already logged in” prompt. Under normal circumstances, this message means exactly what it says! The operator is already signed in.

SYSPRO Error Message Operator Sign In

However, the error message can appear for other reasons that may be puzzling to the user. It is most typically associated with users not exiting SYSPRO through normal means (crashes, forced computer shutdown, etc). It is good for both the ERP administrator as well as the end-users to know what this error means and why it may appear despite the user not being signed in.

SYSPRO Error Message Operator Logged In

What does this “SYSPRO Error Message – Operator Already Logged In” message mean?

SYSPRO’s database has a table called AdmOperator. Inside this table there is a column used to indicate whether a SYSPRO operator is currently signed in. The column value is set to “Y” when a user signs in and is cleared when SYSPRO is closed out normally by the user. The “Y” value can linger in the database if the user fails to close out of SYSPRO “gracefully”.

In that case, the “Operator already logged in” message will appear. The user has the option to proceed which will clear any lingering operator entries. If the user is in fact already signed in, any previous session is terminated by the system.

What causes this “Operator already logged in” message?

Besides the intended circumstance of the operator already being signed in on another computer, the message also appears if a user fails to close out of SYSPRO “gracefully”. Examples of this could include:

  • The user shuts down their PC while SYSPRO was running. 
  • The user closes SYSPRO forcefully using the Windows Task Manager. This is common in the event of SYSPRO freezing or crashing. 
  • Network failures between SYSPRO and the app server causing communication errors. 
  • If the user closes their web browser when using SYSPRO Avanti without using the logout functionality in the application.

Some of these events may also result in “Unknown Processes” lingering in SYSPRO. These will have to be closed out using administrative tools in SYSPRO. To learn about these processes, see our article on Handling Unknown Processes in SYSPRO.

So, what should you do about this message?

Clicking “OK” to proceed is all you need to do! If the warning appears because the user is in fact already signed in, that previous session will simply be terminated. If it appeared for any of the other reasons outlined above, the database fields are cleaned up from any incorrect flags and reset to their intended status. It is good to inform users that this error means no harm and that they can safely proceed if they do not believe that their operator is signed in anywhere else.