Tag: integrated solutions

Posted on

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Accounts and ProAdvisors: Make sure you “enable” only those who need it

In this wonderfully interconnected world of hosted and online applications and the integrations which complement them, it is important to not let the excitement of connectivity and collaboration replace reasonable control.  While there is much conversation on this topic when it involves file sharing and similar services, the discussion of data synchronization and data integration doesn’t often come up.  However, it has been my experience that there is usually a misunderstanding in how, exactly, a particular sync or integration should be applied and who should have access to the functionality when it is deployed as an extension of the QuickBooks desktop financial software.

An example of the problem might be seen when QuickBooks desktop editions are set to integrate or sync data with a web-based solution such as Method Integration or Santrio Open for Business Order Bridge.  Solutions like these, which extend the functionality of QuickBooks through extending access and integrating data, rely upon QuickBooks integration functionality move data between their solutions and the QuickBooks database.  These solutions are quite beneficial for businesses because they can affordably deliver support for various business functions via a true web application and incorporate QuickBooks data in those application views.  Additionally, this type of solution is able to push information from the web application to QuickBooks, allowing for complete integration of financial and other relevant data.

While having this type of integrated service is beneficial, there are a lot of businesses who don’t fully understand how to appropriately implement the solution and end up creating a great deal of difficulty for themselves.  One of the most frequent failures I have seen when implementing this type of solution is where the customer doesn’t really understand who should or should not have the integration.

When a web-based solution exchanges data or syncs with QuickBooks, a path is created to communicate between the two systems – the web solution and the QuickBooks application and data file.  This path must be open, and both sides of the communication identified, in order for data to sync.  The most important thing to remember is that there should be only one controlling entity on each side handling the integration.   What this means for QuickBooks users is that only one installation – one PC accessing QuickBooks – should be configured to facilitate the primary integration with the QuickBooks company file.

To illustrate, consider an implementation of Method Integration and QuickBooks that was done for a business some time ago.  This business used Method-based applications for a variety of business functions, and those applications used data sync’d from QuickBooks desktop.  Just after implementation, it was discovered that system sync’s were not happening as they should, and sometimes when they went to sync data, it would take a huge amount of time (which was not supposed to be normal behavior).  In short, the system proved to be problematic and, at times, unusable.  But the problem didn’t have anything to do with the Method Integration system, nor the technology.

The problem was that all workstations in the office were set up to sync data between QuickBooks and Method.  QuickBooks was installed on all the PC’s, even though most of the users did not use QuickBooks (they used the Method Integration system to do their jobs), and each PC had the Method Integration sync engine installed and set up to run.  This caused the system to be frequently overloaded with sync requests and caused QuickBooks to behave erratically or crash.  In addition, users who did not need (and should not have had) access to QuickBooks financial information were starting up QuickBooks and opening the company file every day because they thought it was required to allow them to access or use QuickBooks data in the Method Integration system.

The benefits of using web applications which can connect to and integrate data with QuickBooks is that a business can give users functionality and data access required to get the job done, but not expose those users to more software or data than they need.  In most cases, if not all, QuickBooks is not necessary for users of the web application (saving you the cost of purchasing and installing QuickBooks for these users).  Further, to ensure proper functionality and to remove any possible conflict or confusion in the sync process, only one workstation with QuickBooks should be set up to sync data to/from the web solution.  While it makes sense to have a “backup” PC setup with the ability, syncing should remain inactive on this machine unless the primary “sync machine” is out of service.  The key element to remember here is that the data coming from the web application is being added to the QuickBooks company file.  Once the data is in QuickBooks, QuickBooks users may access the data from QuickBooks and do not need the connection to the web application.

When deploying this combination of solutions with a hosting service provider, the same rules will apply.  Only users who need the sync capability require service with both QuickBooks and the integration installed.  In some cases, this may make selection of host services more affordable, as only those who need the “additional application” (being the sync solution or integration tool) require customized service, and the rest of the QuickBooks-only users need standard QuickBooks service.  *It might also be worth noting that many hosting providers do not support “persistent” connections – sync connections which continue to run even when you are not logged in), so syncing of data would only be able to occur if the primary user was logged in to QuickBooks and had the sync integration active on the host solution.

Accounting professionals, QuickBooks ProAdvisors, and small business consultants can help their clients understand the value and potential of extending QuickBooks desktop editions with connected web-based solutions.  The additional value these professionals bring to the conversation is the understanding of the need for structure and control of the data flowing into and out of the financial systems, offering their expertise to ensure that the accountability and appropriate treatment of the information exists throughout the business.

Make Sense?

J

Read more …

There’s a lot of legacy ERP out there, and it’s not going anywhere any time soon

https://coopermann.wordpress.com/2012/05/29/theres-a-lot-of-legacy-erp-out-there-and-its-not-going-anywhere-any-time-soon/

Compliance in the Cloud – their system, your responsibility

https://coopermann.wordpress.com/2012/05/23/compliance-in-the-cloud-their-system-your-responsibility/

Beyond Bookkeeping to Total Business

https://coopermann.wordpress.com/2012/05/25/beyond-bookkeeping-to-total-business/

Posted on

Knowing Your Options: Hosting QuickBooks for Shared and Remote Access

Intuit’s QuickBooks financial applications, the desktop editions in particular, are the most popular small business accounting solutions on the market.  The QuickBooks Online Edition, Intuit’s cloud-based contender, is not quite as accepted among accountants and advisors for a variety of reasons.  Being in the cloud isn’t necessarily one of those reasons, if you consider the growing demand for access to multi-user cloud-hosted QuickBooks desktop editions.  Mostly it comes down to functionality and how the application operates.  QBO just isn’t like good old desktop QuickBooks and isn’t the preferred solution for many financial professionals or their clients.  Yet these users still want and need remote access and mobility.  This is where hosting comes in.

QuickBooks hosting and creating the ability to access QuickBooks applications and data remotely is something that a lot of businesses can benefit from.  Whether it’s to outsource the management and maintenance of servers and systems to a 3rd party, or to create the ability for remote workers or contractors to collaborate with real-time applications and data, there may be a need for a hosted application approach.  Business owners and IT managers need to give consideration to the level of service and support they and their users will need before selecting their provider.  Knowing what the provider will handle and what the subscribers are responsible for might make all the difference in determining the right approach.

In-House DIY Hosting

Local networks and PCs allow users in the same location to share resources, like printers and data storage locations.  Typically, desktop computers have application software installed on them, and use the network to access shared data.  When users work outside of the network, getting access to applications and data might not be so easy.  Even extending the network via VPN access doesn’t solve the problem when the desktop applications are not designed to access data over remote connections (desktop applications like QuickBooks).  It used to be that the only reasonable way to allow remote users to access and run QuickBooks as if they were inside the LAN was to set up remote desktop or application servers (terminal servers).  MyQuickCloud is a product that addresses this need very gracefully, providing in-house personnel with the tools necessary to establish a secure cloud for QuickBooks access directly from existing on-premises systems.

Co-location and Outsourced Infrastructure (IaaS)

Instead of setting up remote access solutions in the office, many IT departments find that co-location with a 3rd party addresses a number of issues.  Leasing equipment, operating system and virtualization tools may be more cost-efficient than purchasing them directly, and the security and redundancy in most hosting facilities far exceeds what most businesses are able to afford to implement by themselves.  Co-location provides managed service for infrastructure elements, but doesn’t necessarily address business needs in terms of user security or application and data management.  These elements are traditionally left up to the subscriber; installing and configuring software applications, establishing user and application permissions, and managing updates and software upgrades.  For this reason, co-location may be a good option for a business with internal IT staff, but not necessarily for businesses seeking “full service” application hosting.

Application Service Providers (ASP) and Managed Application Hosting

Application hosting service providers handle software installation and management, user and security administration, and ongoing technical support as part of the subscription service.  Customers need only to provide their software licenses, name users and upload data in order to use the service.  The service provider does the software installation and configuration, sets up the users and establishes permissions, and connects users and applications to managed data storage.  This model allows businesses to enjoy many of the benefits of a cloud-based or SaaS solution model while also allowing them to continue to use software solutions they are already invested in, in terms of both software licensing and process development.  On the other hand, these models can be extremely restrictive in terms of the applications or integrations they will support, and can be quite costly as the number of users or applications hosted increase.

Whether you roll your own (DIY hosting) or work with a full service QuickBooks host, accessing business applications and data from anywhere is an option every business can take advantage of.

Make sense?

J

Read about the race to find the secret sauce of hosted application services for small businesses

Posted on

Cloud Hold-Out No More: QuickBooks Desktop Editions in the Cloud

When most people hear the words “QuickBooks” and “online” together, they think of the web-based solution from Intuit called QuickBooks Online Edition.  And why wouldn’t they?  With the media, industry talking heads, and everyone in information technology discussing cloud this and cloud that, all the attention is going to web-based applications, Software-as-a-Service models, and cloud platforms.  While these approaches to business software distribution and delivery are working for a lot of software vendors and their customers, there are a few hold-outs that may be keeping a lot of folks from considering that move to running their businesses “in the cloud”.  Intuit QuickBooks desktop editions used to be among this list of applications securely anchored to your local PC, but not anymore.

The desire to have remote and mobile access to business applications and data goes beyond simply getting email or syncing contacts to a mobile phone these days.   Business people in all industries are seeing the benefits of using wireless and mobile laptops, tablet computers and smartphones to handle tasks in real-time rather than accumulating paperwork, spending a bunch of time organizing and keying in data, and then submitting the information for batch-processing after the fact.  And, with services being seamlessly connected and information being shared and integrated for a variety of reasons, internet connectivity has become almost as essential to most businesses as telephone service. (Actually, in many cases, telephone service IS delivered via the IP network, so maybe that statement doesn’t make as much sense as it used to.)  Payroll isn’t calculated in the software, it’s calculated by a service online and delivered through your software.  Same with banking, accepting payments, and paying bills – many are processes handled through the software but perhaps not actually happening WITHIN the software on your PC.

As users have begun to realize that, whether they mean to or not, they are essentially “on line” with their business applications and data at some level, the consideration for outsourcing more of their IT operations and working more fully in an online model might not be so bad as long as they don’t have to give up the functionality, usability, and cost-efficiency they have come to expect with their beloved business applications – like QuickBooks.

Service providers recognized this opportunity and developed business models which would give users their desired desktop applications (like QuickBooks!), but in way that seems more like a cloud service.  As platform and virtualization technologies have evolved, businesses are finding that there are numerous options, and numerous providers, for getting their desktop and network applications installed in the “cloud”, and delivered back to them as a managed subscription service.  It is a model which is growing in popularity and demand, and it makes sense.

Small businesses in particular are moving to the cloud not because they are generally dissatisfied with the products they currently have (there’s a reason Intuit has market share with QuickBooks; there are a LOT of QuickBooks desktop lovers out there).  Small businesses are making the move to online and “cloud” models because of the business benefits of getting information when and where they need it.  Mobility is driving the cloud, and the cloud is driving software makers to change how they do things.

It will be a while before all the investments are made and man-hours are spent to rewrite or redevelop applications to run on these new platforms and in this new cloud-based service model.   In the meantime, ISVs will look to hosting providers of various sorts to help breathe longevity into their solutions while securely embracing their customers and market in preparation for a cloud-based service delivery, and customers will engage with service providers who can supply them with the legacy application hosting and management they require to achieve the level of freedom, access, and mobility they demand.

Make sense?

J