Category: data integration

Posted on

Data Gets Lonely When It’s Isolated

EDI Helps Manufacturers Increase Efficiency and Improve Profitability

More efficient processes yield more revenue, it’s that simple. Imagine being able to seamlessly integrate data across the entire supply chain and then imagine how that integration could increase the efficiency and deliver more revenue to each link in the chain.

Every manufacturing CEO wants to increase operational efficiency and lower costs, helping to boost revenues and improve profitability. Yet there is an area which has often been overlooked by businesses, and this is the area of B2B integration. While some methods have delivered degrees of success, broad-based solutions remain elusive to many.

The problem is in the number and types of data sources a manufacturer deals with on a regular basis. With a network of partners and suppliers, each using their own data formats and transfer methods, the volume and variety of information flowing can be overwhelming. The result is siloed data, increased pressure on information technology and management resources, disconnected workflows and slower processes.

IDC’s Manufacturing Insights’ webcast IDC FutureScape: Worldwide Manufacturing Predictions once suggested that nearly 30% of manufacturers would make significant investments toward increasing visibility and analysis of information exchange and business processes, within the company and with partners. That was in 2015. Today, data integration and process improvements continue at a fevered pace as technology is helping businesses gain new data that brings new insight and sparks change.

The integration of Electronic Data Interchange (EDI) is a fundamental first step in improving how a business works with trading partners as well as internally. EDI has been around for many years and refers to the transfer of structured data between two organizations or “trading partners” using a set of standards that define common information formats to facilitate the exchange. By adhering to the same standards, two different organizations can electronically exchange documents (POs, invoices, shipping notices etc), seamlessly and regardless of geographic location.

Simplifying business processes, reducing operating costs, increasing end-to-end visibility, reducing errors, and speeding up operations and responsiveness… these are the many benefits to be experienced when EDI and non-EDI information streams are processed in the same manner when it comes visibility, exception-handling, notifications, role-based access etc.

Unfortunately, not all trading partners use EDI (or implement it in the same manner). To get their documents into a usable format, manufacturers find themselves using manual processes or writing custom scripts. Either way, it means that documents are flowing through entirely different processes for EDI and non-EDI business partners, which significantly complicates matters and adds unexpected costs and complications. Addressing this is one of the reasons why modern manufacturers are finding an increased need for connecting with organizations like Mendelson Consulting who can help identify and address situations that out-of-the-box EDI does not.

The pressure is mounting for manufacturers to produce more with less resources. Mendelson Consulting understands what makes EDI complicated and has the experience and expertise to help growing enterprises overcome challenges in design and implementation, making broader integration possible and greater improvement achievable.

jm bunny feetMake Sense?

J

Posted on

When a Business Outgrows QuickBooks Enterprise

Small and midsized businesses use QuickBooks software to manage finance and operations. Since growing past 90% market share in 2008, Intuit QuickBooks proved over the years that businesses adopt accounting and finance software if it is affordable and easy to use. While Intuit’s focus today may be on gaining market share with the web-browser-based QuickBooks Online edition, QuickBooks Desktop Enterprise continues to serve the needs of companies requiring more robust functionality than QuickBooks Desktop Pro/Premier or QuickBooks Online editions offer.

Over the years the QuickBooks product line has grown to support larger businesses, with the Enterprise edition scaling to 40 users and boasting a load of features that fully support operational processes. Inventory management, order processing workflows, construction management, and other features give encouragement to businesses needing support for more complex processes. QuickBooks Enterprise allows the flow-through of product use knowledge, stored data and integration with other business solutions to be seamless and consistent when moving up from QuickBooks Desktop Pro or Premier editions.

When a business finds that it may be outgrowing the capabilities of QuickBooks, it does not necessarily have to abandon the product line in lieu of a larger framework such as with alternative ERP systems. While the larger web-based systems may boast greater capabilities, they often come with much greater cost of service and implementation.

For businesses invested in QuickBooks Enterprise, it makes sense to look at alternative technical or platform solutions to address certain operational needs rather than shifting to different finance and operations software. The cost and complexity of an entirely new ERP software implementation is often more burdensome and costly than is needed to meet the real business demand. Also, the value found in business data can be lost when converting from one solution to another, and the cost of change is often so burdensome that many businesses simply abandon their projects if they even get started.

When using QuickBooks, at times it is the platform — the local network, computers and server — that is not geared to handle more users, processes and applications working with QuickBooks and a more robust and agile situation is required. Businesses should also explore integrations or extensions that can address the functional requirements, supporting advanced and complex workflows with greater agility while retaining the full value of the historic data.

Some challenges with QuickBooks may indicate a business needs a more robust and scalable solution, but that does not necessarily indicate that the business has truly outgrown QuickBooks. Instead, it may be a situation best handled by extending QuickBooks through application integration with a more robust subsystem to address specific business needs, to add scalability, and to build on the existing history and business intelligence previously developed in the enterprise.

Large transaction volume, extensive inventory management, or performance issues can easily create the impression that a business has outgrown QuickBooks Enterprise. In most cases, these conditions are overcome by extending QuickBooks with solutions geared specifically to handle the complexities and volume of heavy inventory management processes. These solutions not only address the in-depth functionality required, but also tend to utilize more agile and robust database structures that can scale far beyond the capacity of any QuickBooks edition alone.

Some businesses wishing to provide more advanced reporting and analytics, along with delivering realtime insights, may initially consider QuickBooks reporting to be insufficient for their needs. Yet there are integrations available which make QuickBooks financial and operations data as accessible and usable as the most robust enterprise applications. Satisfying the need for highly customized reporting and analytics far beyond QuickBooks standard reporting, these solutions create visibility and give meaning to QuickBooks data in ways that cannot be accomplished within the application alone.

Mendelson Consulting understands how businesses can outgrow the core functionality of QuickBooks and provides the tools and solutions to address growth in practical ways that do not diminish the value of data, training and operational intelligence that has been so costly for the business to acquire. We help businesses expand their capabilities and improve efficiency without losing their investment in QuickBooks, addressing the needs of growing and complex businesses without forcing the change to more extensive and expensive solutions.

jm bunny feetMake Sense?

J

Posted on

Competitive and Profitable Construction: What’s it take to get there and stay there?

The short answer is… update your operations and transform the business. It’s time to modernize and embrace the cloud.

Construction firms need to be more data-driven, analyzing and responding to conditions revealed by the various systems supporting the business operation. Turning a profit on complex projects means applying automation to manual processes and workflows, introducing more collaborative tools, and delivering real-time data to gain greater insight into the operation’s performance and profitability. The foundation for all of this is the cloud platform, extending connectedness beyond traditional boundaries.

Digital transformation and the adoption of agile and connected cloud platforms can result in productivity gains of 14 to 15 percent and reduce costs from 4 to 6 percent. These improvements are the way to address fading profits even as the pace of business increases. https://www.mckinsey.com/business-functions/operations/our-insights/decoding-digital-transformation-in-construction

There are several factors that typically weigh down the operation and cause profits to fade. Strained IT resources is a big item for most construction companies, where technical people spend far too much time building and maintaining on-premises servers and networks. Maintaining on-premises servers adds up fast. A single IT manager can easily cost around $150,000 per year, and the “cost of cybersecurity compliance raises the price by an additional $200,000.” (5 Reasons Contractors Need to Modernize Their Operations to Stay Competitive and Profitable by Trimble Viewpoint)

Even when you factor in the costs of hardware, software and IT personnel, those costs don’t include the hidden expenses that come with the use of on-premises servers, like disconnected and siloed data that requires manual processes to use, duplicated data entry requirements (increasing the potential for human error) and more costs for labor. When you figure in all the capital costs and expenditures, on-premises solutions can cost up to four times as much as their original purchase price. On the other hand, NOOBEH cloud servers, deployed on the Microsoft Azure platform, offer reliable, cost-effective solutions to support the variety of important business applications and integrations that high-performance operations require.

NOOBEH cloud services focuses on addressing the pain points businesses have with their IT. We help businesses implement services that promote real collaboration for real use-cases, and we look for ways to connect projects and operational data so it can be analyzed to unlock greater value across the entire enterprise.

Disconnects cause inefficiency, delays, errors, and reduced productivity. Lack of insight on the labor and equipment side leads to uncontrolled resource utilization and a lack of predictability. Jobs get delayed and profits fade. Lost productivity due to duplicate entry of information is leveled at 10%-30% (or more), and these rates are not uncommon. https://www.eckerson.com/articles/hidden-costs-of-duplicate-data.

Clearly, automation, connected workflows, cloud platforms and real-time data are essentials in the transformation and improvement effort. Let in-house IT focus on activities that bring value to the business, finding ways to innovate and improve how things get done. Replace cumbersome, manual processes with software and systems that facilitate greater automation and integration, eliminating redundant data entry and improving the quality of information.

Construction projects are becoming larger and more complex, and project owners want the latest technologies, real-time reporting, and comprehensive approaches to compliance. Today, industry-leading contractors are embracing connected cloud technologies so they can scale and future-proof their businesses.

The modern contractor takes advantage of connected platforms, automation and real-time data that feeds data analysis and business intelligence… innovations only available with the cloud. That’s what NOOBEH delivers.

jm bunny feetMake Sense?

J

Posted on

Is Your Business IT Ready for Industry 4.0?

Over the past several hundred years there have been trends which revolutionized industry and manufacturing around the world… steps taken in an industrial revolution which advanced the evolution of civilization and life as we know it. The first revolutionary phase was combining mechanization with steam and waterpower, and the second was the combination of mass production with electricity. The third was the rise of electronics, IT systems and automation. We are now at the start of the fourth phase of industrial revolution.

PwC’s Insights suggests that Industry 4.0 “refers to the fourth industrial revolution, which connections machines, people and physical assets into an integrated digital ecosystem that seamlessly generates, analyzes and communicates data, and sometimes takes action on that data without the need for human intervention.”

This next phase advances on concepts introduced through digitization and connected frameworks, tying in the industrial IoT (Internet of Things) and smart manufacturing. This meshed model relies on interconnectivity of systems, lots of automation at high levels, machine learning and AI… all collecting and generating data in real-time.

Where physical operations and production join with smart digital technologies, big data, and machine learning, businesses can forge systems which focus directly on manufacturing and supply chain management, gaining new insights and getting actionable data at all levels.

Virtualizing physical resources and digitization of analog data is now coupled with improved access to and management of the platforms. Rather than building out on-prem physical servers and systems, businesses are finding that the agility, scalability, and fault-tolerance of the cloud is necessary when designing an operation that connects, communicates and collects data, performs intelligent analyses, and potentially acts without people getting directly involved.

Every company is different, but all face a common challenge — the need for connection and access to real-time insights across processes, products, and people.

The consulting team at Mendelson Consulting and our NOOBEH cloud services group know how to get businesses in the best position to implement the tools and services that will propel the operation forward. From the most popular and powerful small business financial software to cloud platforms which enable connectivity in applications and workflows, we understand what it takes to help small businesses transform.

jm bunny feetMake Sense?

J

Posted on

Good Housekeeping for Healthy QuickBooks

QuickBooks desktop software is very easy to install and use, and that is precisely why it is the standard for small business bookkeeping and accounting. QuickBooks is simple to use.

Getting QuickBooks on your computer is also simple. You can just buy the software from wherever – your QuickBooks solution provider, a retail outlet or an online store. Then you download it to your PC and run a setup application, and voila! It’s there on your PC ready to help you do your books.

When just a single user needs to use QuickBooks, things are very straightforward because there is no networking to worry about and no multi-user access required. On the other hand, there are many businesses using QuickBooks that experience a lot of frustration with trying to install QuickBooks on a network and managing the software that must be installed on multiple computers.

Other than networking QuickBooks desktop software, it seems that the majority of issues users experience can be attributed more to poor software habits and a lack of PC housekeeping

QuickBooks desktop software has been engineered over many years to be as simple to use as possible, but at the same time has grown to be a product with lots of features, add-ons and extensions.  People have found ways to make QuickBooks do things it wasn’t really designed to do, which is sometimes a good thing and sometimes a bad thing. When it works, it works great.  When it doesn’t work, it’s beyond frustrating.

Yet there are a few things that QuickBooks desktop users should be doing regularly to keep their QuickBooks software and data in good working condition. While these items are very important to keeping your QuickBooks system working for you, they will never overcome problems with your network, the server or any of the workstations connected to it.

To solve these networking, software management and other IT platform issues, I recommend moving to a virtual cloud server on the Microsoft Azure cloud platform. NOOBEH’s QuickBooks on Azure service is just that… your QuickBooks software and data running securely on your own private cloud server in your own account on the Microsoft cloud, fully managed and supported by experts. With NOOBEH’s service, you don’t have to worry about server failures, network problems or hardware problems any longer, and we eliminate the issues surrounding multi-user, multi-location, and remote access for QuickBooks.

When it comes to PC housekeeping and other chores, I cannot stress enough the importance of keeping the QuickBooks company file in good condition

What’s the accounting and financial data worth, after all?  A little time spent taking care of the file can save on a lot of time and headaches trying to recreate or reenter the data. A QuickBooks company file is a database and is a complicated framework for keeping track of all sorts of related information.  Anyone who has used QuickBooks desktop products for a while understands that the data file can get messed up for a variety of reasons, and it can mean lost time, work and revenue when it isn’t working correctly.

What many users don’t realize that QuickBooks has built-in utilities to check and fix data problems in the company file, so it makes sense to periodically use them to check for problems.  Like a check-up with the doctor, these utilities can help diagnose issues with the data file before they become big issues. They are easy to find in the software… simply go to the File menu and select Utilities.

Run the file Verify any time the file starts to act slow or if QuickBooks crashes when the file was open, and if the Verify tells you there are errors, you should run a Rebuild to fix them. Note that a rebuild may have to run multiple times to fix all the issues in the file, and even then, may not correct everything. Some manual work may even be required to resolve all errors.

You should also back up the company file to a “portable” type file periodically, and to then restore it for use.  This doesn’t need to be done very often, maybe once a year or so. This process can not only validate the integrity of the file, but it also helps condense and condition the file.  Conditioning the data file periodically can help prevent data corruption and/or loss of data.

A very important housekeeping item for QuickBooks desktop is the file backup. Backups don’t just make copies of your company file for safekeeping, which is important to have, but when you run a backup with complete/full verification, the process also reduces the file size of the TLG file. For QuickBooks, the TLG file is a transaction log, and when it gets too big the file can perform poorly and even get corrupted.  Run backups more frequently if you have a lot of transactional activity, or less often if there is not so much going into the company file.

When you do the file backup, it is a good idea to consider where the backup will go. Keeping the backup files on your PC is convenient, but it also does nothing to protect your data if your PC gets hit with malware or has a hardware problem. Put the backup file in a protected location that isn’t stored on your PC, like Microsoft OneDrive, Google Drive, Dropbox or even a removeable USB device. You can’t put your live QuickBooks company file in this type of location, but you can store the backup files there. This way, if your PC does have a problem, you’ll have backups of your company file that you can use to get yourself back in business.

Close the company file and exit QuickBooks occasionally, please

Users who leave their computers on all the time are not allowing the computer to run periodic power-on self-tests, which means the machine or operating system could have an issue that isn’t recognized until computer restarts.  For this same reason, programs and their data files should be closed when not being used – so they can run through their own startup and validation routines before you use them.  Also, leaving the program open means it is active on the computer, and leaving the data file open means that it’s available (available=vulnerable).  A random by passer accessing the computer, a program crash, a machine crash… loss of power or a furry kitty running over the keyboard could each result in catastrophic damage to the application and/or data.  It’s just better and safer if the files and programs are closed when not being used.  Maybe use a screensaver with a password, too, or at least lock the keyboard when the machine is on but not in use.

QuickBooks and VPN / WAN are not awesome together

Just because a user can connect their remote PC to the office network doesn’t mean the PC will work like it’s in the office.  In the office, it’s a Local Area Network where the machines are all cabled together and communicate with nearby machines (e.g, Local). The speed of LAN communications is fast enough to allow multiple computers to share a QuickBooks company file in multi-user mode.  When there is a remote PC to connect, businesses often elect to utilize a VPN to provide local area network access to the remote computer. This turns the Local Area Network connection into a Wide Area Network connection, where the network has been extended to include the remote computer.

Unfortunately for QuickBooks users, the WAN connection is NOT fast enough to allow the remote user to open QuickBooks and use it like others in the network.  QuickBooks multi-user access is designed to work on a local network where local means the machines are in the same locale and on the same LAN. This is why many companies elect to use remote-access/remote-control software to access to QuickBooks desktop remotely.

Use NOOBEH QuickBooks on Azure to get remote access, managed service, update support, and the ability to run any other applications or add-ons your business needs. When QuickBooks desktop and the other software a business uses are hosted on the company’s Microsoft cloud server with NOOBEH, the QuickBooks application and the company files are all on the same environment so it works exactly as it is supposed to for all users no matter where they are located.

Use Automatic Update

New features and enhancements are provided, new technologies and operating platforms must be supported, and security and privacy must constantly be addressed in the software. What this all means is that software products necessarily change over time and users will be expected to update their products or lose out. While some IT departments may desire to prevent software from updating itself, QuickBooks users should recognize that the software’s proper function often depends on timely updates. Especially when payroll or banking is involved, it is important to keep the software current.

QuickBooks has a feature that allows the software to automatically download and install updates as they are released by Intuit. Leaving this feature turned on allows the software to check with Intuit periodically to see if there are updates available. If so, they are downloaded and readied for installation on the computer.

Updates are changes made to an edition and year version of the software. Upgrades, on the other hand, are changes from one year version to another (2021 to 2022, for example) or a change in QuickBooks edition (like Premier to Enterprise). Automatic updates manage the changes to the currently installed edition/year version, but do not upgrade the software.

Customers using NOOBEH’s QuickBooks on Azure service have their QuickBooks updates and their QuickBooks upgrade installations managed for them, as well as the other applications installed on the customer’s private cloud server.

Doing maintenance on your QuickBooks software and the company file can help keep them free from poor performance and potential corruption

It’s worth spending a little time on chores occasionally so that you avoid what could be a costly problem down the road. Some good housekeeping to keep your QuickBooks healthy is just good business.

jm bunny feetMake Sense?

J

Posted on

Better Platform, Better Data, Better Performance

Information management paradigms are rapidly changing, so businesses seeking to achieve maximum performance and profitability must look at increased efficiency and innovation in their IT platforms. Cloud platforms help business operations to be more effective and agile, supporting the various processes and workflows which make up the operation. From finance to order processing, shipping and customer service, the platform needs to be flexible enough to handle the wide variety of needs of the company.

Today’s technology-enabled flow of business opportunity requires modern infrastructure and IT services. Where many would believe that web-based applications and “cloud” versions of software solve the problem, more often the business finds the solution lacking features and usefulness. Tried and failed plug-ins and extensions may leave the system attached to a spiderweb of connections and services behind the scenes, reducing or eliminating the ability to fully control the flow of data to or from the system.

The real issue to address is the infrastructure and IT foundation, not just the applications. Certainly, the software matters greatly, but too often businesses believe they must migrate to new applications and adopt new processes simply because they wish to have remote access and more flexibility in how and where users and information connect.

Cloud platforms and services enable many things for a business, not the least of which is collaboration and co-working. With centralized access to applications and data, workers can get the information they need regardless of where they are, and the workflows and processes may be improved and expanded because all users can participate as required.

Enabling connectivity for the platform is as essential as for the applications. When applications and processes can connect seamlessly, the data flows through the business better and there’s less chance of it getting damaged or lost. Re-keying data increases the opportunity for errors, and manual import/export processes can fail due to simple mistakes. With the right integration and sync tools and an IT platform that fully supports them, the business can improve the speed and accuracy of data moving throughout the system.

There is a growing need for accounting and business professionals who understand how these data connections can work and assisting businesses with selecting and implementing the right ones. This used to be more in the domain of the CIO, information systems guys and data analysts, but it is falling more to the accounting and finance teams these days.

For many years, accounting and finance were just the final dumping ground for after-the-fact financial data. Operationally, things could be humming along in the business and looking just fine, but the business was losing money, and nobody knew it before it was too late. Now, business owners and managers have come to understand that virtually EVERYTHING in business has a financial impact and leaves an imprint on the business: every action and activity, every relationship and interaction.

When cloud platforms, applications and integrations are in place for the business, business intelligence comes not just from after-the-fact silos of historical data, but from current and real-time information that is the key to unlocking a deeper understanding of business performance.

jm bunny feetMake Sense?

J