If you are “Pushing the Envelope”, are you putting your business at risk?

4Signs you might need to upgrade you current business accounting software

It’s happens again and again. The phone rings and we get a call from a prospective client who sees the writing on the wall. Actually, not so much the writing, more the clock on the wall as they tell tales of the hours ticking away and their monthly close seeming like it will never end. Or perhaps the financial report that the CEO requested is taking hours to produce instead of minutes. Their current business accounting software is becoming the bottleneck to overnight success for their organization. The owners and CFO’s patience has reached critical mass – they’re as mad as hell and they’re not going to take it anymore!

If you can empathize with this scenario, then you may be ready to join the growing numbers who need to take the next step, and upgrade to a more robust solution that will grow as the business grows. The economy is picking up and smart companies are looking to change, but alas, resistance is still strong.Many firms are still making the excuse that they can’t afford to move to something bigger due to cost, or perhaps there’s a little fear factor involved. After all, upgrading your accounting system can be a daunting prospect.

Here are four signs that you may be pushing your luck if you try to push the system envelope a little further:

1. Growing Customer Needs
Starting your business with a single location and a couple of sales reps meant your back-end systems accommodated small volumes of data, and customer lists were probably tracked and kept using spreadsheets, or basic contact management systems. The sales were good and your customer base increased; enough that the business decided to add new sales channels and plan out marketing campaigns. The ability to understand the buying patterns of your customer base and access the information from a central database was a core requirement, but the sales resisted and were happy and comfortable working with their current methods.

Don’t allow the tail to wag the dog – your customers are what have grown your company, so you need to have the ability to service your market and ensure customer relations are paramount. If you need to add a customer service organization, and more sales reps, then you must have the ability to manage the processes and data associated with these activities. That means you will need good order management and inventory control systems, and eventually a customer relationship management (CRM) system.

If your current system doesn’t accommodate these growth factors, then you will be losing sales to your competitors.

2. Collaboration Challenges
It’s a fact that small organizations will always try to extend the use of their management tools as much as possible.It’s also typical that over time new applications were introduced that solved their growth requirements, such as in-house custom development, or multiple spreadsheets. This solved the short-term need, but with the growth and complexity of the business came an increase in the support or management requirements. This limited their ability to see a picture of their overall business because there were so many islands of information that needed to be combined.

This proliferation of applications or custom solutions limits the ability to make well-informed decisions. By the time you have combined the data into a business report that can answer the question you are asking, the market has changed and you’ll need to start again. Your staff may now be wasting more time finding the right data instead of using the data to make the decisions necessary to beat the market.

If your current system doesn’t provide a way to give you an integrated and comprehensive picture across all your business units, your chances of making that informed decision are limited.

3. Spreadsheet Hell
As stated, a common way to solve new growth reporting requirements is to create a spreadsheet. Although the spreadsheet is an amazing tool that is simple to use and readily accessible, companies will often use them to supplement basic accounting systems.In a recent survey, 57% of small and medium sized firms said they still use spreadsheets to run their business. This has inherent elements of danger: little or no audit trail, calculation errors and ability to change the data easily, they lack collaboration, and low security.

If your current processes include heavy reliance on spreadsheets because you don’t get what you need from your software, then take a look at the benefits of upgrading to a more integrated system and realize reductions in operating and administrative costs.

4. Performance and Functionality Degradation
As your transaction volumes increases, so does the size of your database. If your volume is increasing, then you are probably adding staff to handle the orders and the number of users logged in to the system is increasing. As you add inventory, there will probably be a need to add additional descriptive fields, and so the complexity increases. The first time you notice there is an issue is when it takes forever to create a simple report, or perhaps some users get locked up in the system. You’ve hit the performance blockade, and solving this isn’t always simple.

If your current system has ‘maxed’ out, you will be losing sales because it takes too much time to take an order, or you have started to experience increased outages. Take a look at how many orders you are losing this way and you will be surprised at how much revenue just got lost in in that performance bottleneck.

The financial side of growing your business is critical to profitability and success, but today’s economy demands that this aspect is combined with real-time visibility across the entire company. Even a minimum amount of business process automation and integration can provide high productivity gains.

Still not convinced? If you would like to discuss your specific situation in more detail, then call the Axis Global Partners office closest to you and we’d love to hear from you!

Posted in Enterprise Resource Planning (ERP) | Leave a comment

Plan Ahead for Technical Upgrades to Your ERP System

Enterprise software that supports business operations is generally the most important part of any data and tracking system. While companies spend considerable time researching specific programs and applications prior to an implementation, they tend to overlook future improvements afforded by a technical upgrade. While it is true that more planning and research are necessary when initially selecting an Enterprise Resource Planning (ERP) system, it is also important to regularly spend time mapping out future upgrades as well.

Once your company has become accustomed to your ERP technology, you may consider other expansions such as:

Mobile Devices: Adding mobile functionality to an ERP system is easier than many companies think. In fact, it only requires specific connection points to ensure the data collected by remote workers and employees on the floor of production facilities is matched with its database equivalents.

Cloud Computing:If you are unable to continue hosting your ERP solution on-site, you may want to consider accessing ERP through the cloud. Withready to use characteristics and availability, many companies are surprised to find how affordable and easy it can be to ‘rent’ the technology over the internet.

Training: Training is essential for any staff member who comes in contact with technology. Clerical workers, managers, IT supervisors and sales people all need to know how to deal with ERP systems and be informed of any upgrades the company is planning. Providing employees with continuous training will improve your system’s usability and success overall.

Infrastructure: If your ERP system is based on-premise, then you should consider advantages provided from upgrades to the operating system (OS) and hardware for workstations and servers. If your ERP system was implemented over 5 years ago, it is possible that you will still be using older versions of Windows OS, or that your hardware is has a sub-standard configuration and is reaching an out-of-capacity state. Make sure that any planning for infrastructure upgrades also considers the impact on any customizations made to the existing systems.

Regularly upgrading your ERP system will increase efficiency in the workplace and give you the most accurate information about your business. If you need assistance in planning your next technology upgrade, contact your local Axis Global Partners office today. Download this informative whitepaper – “An ERP Guide to Driving Efficiency” – to learn more about how an ERP system can benefit your company. anabolen kuur

Posted in Enterprise Resource Planning (ERP), June 2012, Newsletter | Leave a comment

Tips, Tricks & Tutorials: Import Mass Updates into Number Changers & Search Select Advanced Fields

Video tips, tricks and tutorials help you become more productive with your Sage 300 ERP (formerly Sage ERP Accpac) and Sage CRM systems. Featured this month:

View our Entire
Video Learning Library

Adobe Flash Player is required

Import Mass Updates into Number Changers

Sage 300 ERP provides utilities that allow you to change the account numbers in your General Ledger, Customer numbers in Accounts Receivable, Vendor Numbers in Accounts Payable and Item Numbers in Inventory. The Number Change utilities are easy to use whether you’re updating a single record or makeing mass updates. For mass updates, its most efficient to import your changes from a spreadsheet and in this tutorial we show you how.
Duration: 7 min 46 sec

Search Select Advanced Fields

Sage CRM provides you with a number of different field types that you can add to your screens allowing you to configure the system to meet your needs. One of the available field types is the Search Select Advanced field that allows you to search for records within an entry screen. In this tutorial, we walk through an example of adding a Search Select Advanced field to the Opportunity screen.
Duration: 9 min 25 sec

Posted in CRM Videos, ERP Videos, June 2012, Newsletter, Tips & Tricks Videos | Leave a comment

Understanding the Role of Analytics, Dashboards, Business Intelligence and Alerts

Enterprise Resource Planning (ERP), on its own, is an excellent way to keep track of data and record business transactions. Companies can save a great deal of time by automating all informational processes and storing them in the easily accessible computer applications provided by an ERP system.

While an ERP implementation can make traditional processes much more efficient, it is important to note that other programs might also be necessary to interpret the wealth of information that an ERP system can provide. Many executives turn to analytics, dashboards and business intelligence tools to help them sift through the gigabytes of data provided by their ERP systems, and get to the bottom line faster.

Analytics judge the strength of business transactions and endeavors by looking at a set of criteria and analyzing the data relative to current trends and industry standards. For instance, if a company wants to view every payment it has made in the past fiscal year, as well as the resulting impact on gross income; results can be produced which highlight all operations in this light. Analytics such as this are useful for comprehending past actions so that future decisions can be made more effectively.

Dashboards measure current processes. A dashboard can be used to view operational metrics such as daily output totals of certain products; monitor resources and the speed at which they are consumed; or simply to see how quickly orders are being processed. Dashboards identify current trends andpotential problems to help your organization function at the highest level possible on a day-to-day basis.

Business intelligence, like analytics, can be given certain criteria with which to form calculations. When provided with resource levels, product expectations and other variables; business intelligence applications indicate ways that actions can be taken to improve desired results. Important decisions that impact your company can be made more easily through the use of a business intelligence solution. While analytics peer into the past and dashboards monitor the present, perhaps the most valuable tool is business intelligence due it its ability to assist you in anticipating the future.

Alerts enhance communications from your company’s back-office, front-office, and e-commerce systems by monitoring data fields for a significant activity. The program automatically communicates specified activities to appropriate personnel. For you, that means automated processes that reduce delivery cycle time and accelerate revenue. For your customers, that means doing business with a company they can count on for efficient, reliable, and attentive service.

When used together, all of the above components will transform your company into a fast reacting and nimble enterprise that makes sound business decisions using reliable and factual data

To learn more about the best options available to enhance the information you get from your ERP system, contact your local Axis Global Partners office today.

Posted in Business Intelligence (BI), June 2012, Newsletter | Leave a comment

The Role CRM Plays in Your Social Media Marketing Plan

Generally today the first place someone turns to for information about your company is the internet, where they find all sorts of data, good and bad, warranted and unwarranted. The web provides a forum for every single person to voice their experiences and opinions. This is largely found in the medium of Social Media.

The Scope of Social Media

Company images and customer relationships can be built and maintained through the use of Facebook, LinkedIn, Twitter, and others. By connecting with customers directly, organizations are more likely to have a positive impact on their online reputation.

According to Social Media Marketing Industry Reports, more than 88 percent of marketers are using social media data in their marketing plans. Those that aren’t, are missing out on more than 800 million users on Facebook, and on the one billion pieces of content exchanged weekly. What’s more, research shows that users who “like” a company’s brand are five times more likely to visit the corporate website.

If information is published that reflects poorly on your company, it can do an immeasurable amount of damage. Customer complaints travel at rapid speeds on the web. The reach and power of services such as Facebook or Yelp can turn private criticisms into public outcries. Therefore it is crucial that you consistently monitor the internet for negative comments in order to maintain your organization’s good reputation. However many find themselves overwhelmed by this task, with so many search engines and social media sites to review.

How CRM Can Help

Thankfully, success can be found in this area through the use of a Customer Relationship Management (CRM) application. The latest CRM technology is able to monitor social media for you, streaming all comments and feedback into your system; where you can view them in one place, match comments to your customers, and work to rectify any issues before they can do damage.

Customers want to know that their opinions and experiences are heard and appreciated. Interacting with customers directly through social media via your CRM application can improve your chances of gaining – and keeping – loyal customers.

Want to learn more on this topic? Join us for our complimentary CRM webinar series.  Axis has teamed up with Leading Edge founder, Dan Kraus for our 29-minute Afternoon Break webinar series. Check back soon for more information and to register for the next webinar in the series.

Posted in Customer Relations Management (CRM), June 2012, Newsletter | Leave a comment

Business Intelligence, Big Investment?

As a consulting firm who works with small and medium-sized companies (SMBs), we have been reviewing how our clients and prospects would view this ‘Brave New World’ of Business Intelligence. Would they truly consider it a way of gaining a competitive edge, or would they hold back because they equated the term Business Intelligence with a substantial investment of time and money?

Businesses who follow the industry trends continue to see information flooding across the internet purporting that 2012 will be the year of “Big Data”. This generates more FUD in SMBs as to exactly what is Big Data, how it will affect them, and if it does what they need to do to manage it. Hand-in-hand with Big Data there is Business Intelligence solutions and inevitably, the costs of implementing and maintaining a BI solution becomes the number one concern. Vendors are telling you that you need one, but solutions targeted at large corporations are unrealistic for smaller businesses to afford and implement. Luckily, more options are becoming available to help you gain the competitive edge.

So first, what is Big Data? It can be defined as datasets that have grown so large they become difficult to work with using traditional database management tools. In the smaller company, from a volume perspective, this may mean you still export accounting data to a spreadsheet, but that mergers and acquisitions has made this unmanageable, and your business processes have not kept up with the growth. You are spending more time than you would like to combine multiple entity reports, and this time-crunch factor is limiting your ability to analyze the data in other ways.

Volume is one way to define Big Data, but from different perspective can we consider Big Data to be the one report that enables a company to reduce their cost of sales, and increase their future revenue? To them, the ability to analyze the data they do have, regardless of how many mega- or gigabytes it may be, and to turn that information into business knowledge that empowers strategic decisions, is the El Dorado they seek.

So, is it reality to suggest that companies can implement BI solutions with a minimum investment? The title of this blog suggests they can, when we consider the dollar cost to obtain the BI tool of choice. A new wave of BI products is making it cost-effective for companies of all sizes to implement tools with sophisticated functionality that enables employees at many levels to take advantage of business insight.

As we noted in a previous blog entry, finding ROI on the investment is difficult. It is really the business value, a ‘soft’ benefit that sells the system. A recent WSJ  MarketWatch article cited an average benefit of over $10 for every dollar spent on business analytics applications including BI tools. Now that’s what we call an intelligent investment.

Posted in Business Intelligence (BI) | Leave a comment

Procedure for determining if any of the database tables are locked in Microsoft SQL

Every so often, operations you perform can cause databases to have locking or blocking problems or an environment issue can cause a database table locking to occur, preventing other users from accessing or writing data to the table. Locking and blocking are unavoidable. They occur in every relational database management system (RDBMS), and SQL Server is no exception.

Blocking occurs when a single logged-on database session, or server process ID (SPID), holds a lock on a specific resource, and a second SPID tries to acquire a conflicting lock on that same resource. Typically, resource locks don’t last long. When the first user releases the lock, the second server SPID can lock the resource to continue processing a query.

SQL Server uses a granular approach to locking. It will select the appropriate locking level based on the number of records affected and other ongoing activities. By default, locks are escalated from smaller row-level and page-level locks, to larger table-level locks as needed to improve performance. While escalation is generally a good thing, it also can cause problems, for example when a Service Set Identifier (SSID) locks an entire table and prevents other SSIDs from working with that table.

If you run into an issue where you think a table or tables are locked, you can run the following script to be certain. We will be using Accpac Sample Company (SAM561) to demonstrate.

1. Open Microsoft SQL Server Management Studio and click on the New Query button.

2. In the Query window, enter the following script:
Use SAMI56
go
--to list of tables which are being locked at the moment
select
object_name(resource_associated_entity_id) as 'TableName' ,*
from
sys.dm_tran_locks
where resource_type = 'OBJECT'
and resource_database_id = DB_ID()
GO

3. Click the Execute icon to run the script

4. Review the Results screen to see the tables currently locked.

In order to produce these results, start the Inventory Control Day-End Periodic Process.

If you know someone who could benefit from our blog, or from our other resources such as the Success Newsletter or our Tips & Tricks Videos, then please forward this article to them or refer them to our website at www.axisgp.com.

Posted in "How Do I" Tips, Enterprise Resource Planning (ERP) | Leave a comment

Which is better for my business: Cloud, On-premise or maybe a Hybrid?

Top 5 issues for SMBs to consider

Is the Cloud the answer?
The gas prices at today’s pumps will make any consumer stop in their tracks and wonder why they bought that big SUV. There will be intense family discussions about the value of keeping the vehicle, or if they should trade-in for a smaller, gas-conserving model or even go with a hybrid.

The comparisons are there with some of the management decisions that small and medium-sized companies are facing in today’s economy and what direction they need to take with their ERP (Enterprise Resource Planning) systems. This is a market that has come under the microscope with the introduction of many cloud solutions, alleging to be the key when it comes to saving company dollars.

The ERP solution of ten years ago that was going to carry the company to business success mayor may not have realized its potential, but the marketing hype and glamor-ads of today all suggest that you will get more MPG with less work by moving to a SaaS (Software-as-a-Service) alternative, placing your data and effectively your business in the legendary cloud.(There are really three options to consider; on-premise, hosted, and SaaS, but in this article we’re only looking to discuss on-premise versus Saas).

But is the reality that simple, or are there hidden considerations that can cause you to hesitate? “Once bitten, twice shy” so says the familiar idiom, and firms who had unpleasant experiences with their ERP project may not want to face similar upheaval and problems again.

It’s nice to have choices
Which model is right for your organization? What are the factors to consider when reviewing your options?  Here are 5 considerations that should help at least determine if a full assessment is needed.

  1. How complex is your business?
    If you have a simple, vanilla business model then you will likely not require anything too unique that cannot be accommodated out of the box (or in this case out of the web). But if you have complex business processes then make sure that these can be adapted to a web application. You may already have implemented customizations to your on-premise system, and it can prove costly or impossible to get the same functionality from the SaaS offering, which may not be as flexible due to vendor standards. If it is early days for your business, and you haven’t defined too many processes, then adapting to the SaaS software best practices is probably the best route. As most ERP vendors provide both flavors (on-premise and SaaS), then if you find a competitive advantage later that requires some process complexity, then it may just be a natural growth progression to bring the system in-house.
  2. How many locations do you need to manage?
    Small to mid-size companies should definitely consider cloud options. Typically, cost would be a consideration for these companies, and one of the benefits of SaaS is a lower startup cost. This would mean there would be reduced onsite infrastructure to be in place, just a reliable communications provider to enable access to the internet. Beyond mid-size, and for those companies who may have a number of diverse organizations under the same corporate guidance or globally may decide that an on-premise option suits their requirements better. Primary issues here are control of their data and applications, and the ever present security concern.
  3. What level of IT skills and support do I have?
    If you have in-house IT staff, then it’s a matter of the level of skills they will have to undertake an implementation project, or how much time they are currently devoting to supporting the existing system. If you have a well-oiled machine, then your ongoing costs may already have stabilized. If you have none of this, or perhaps have your IT support outsourced, then the low cost of startup and ongoing support make the SaaS option attractive.
  4. What level of integration with other systems?
    If you have specific applications that have been, or will control unique business processes, or have a need to customize or interface with legacy systems, then on-premise is a better option. It’s partly about what level of control you feel comfortable with, and partly a bandwidth issue. With specialization there could be large amounts of data involved, and therefore response times can be of concern.
  5. Do you have high-availability requirements?
    Most online systems have high availability levels, and have taken steps to ensure redundancy is built into their network. But systems still go down, as Amazon experienced recently. From a local perspective, everything works great until you lose your internet connection. If you are in a business that demands 100% availability, then you can’t beat on-premise as you rely only on your own network and contingencies. The deciding factor here is how much revenue is at risk for every hour, or perhaps minute, that you are down.

One size does not fit all
When an IT question is asked, the answer is invariably, “It depends.” The cloud / on-premise evaluation is no different, and indeed there is even a case for the hybrid approach that can allow for exceptionally dynamic business needs. Don’t make the decisions in a vacuum. Seek outside counsel from business partners and consulting firms who specialize in guiding organizations through these types of projects, and make the right decision to match your business needs for the future.

Posted in Enterprise Resource Planning (ERP) | Leave a comment

Tips, Tricks & Tutorials: Sage Business Intelligence Report Designer & E-Marketing Campaign Setup

Video tips, tricks and tutorials help you become more productive with your Sage 300 ERP (formerly Sage ERP Accpac) and Sage CRM systems. Featured this month:

View our Entire
Video Learning Library

Adobe Flash Player is required

Introduction to the Sage Business Intelligence Report Designer

Sage Business Intelligence is now included with Sage 300 ERP and offers several optional components including the Report Designer. The Report Designer is an Excel-based extension that allows you to generate financial statements in seconds and edit or create financial report layouts using simple drag and drop functionality. In this tutorial, we provide an introduction to the Report Designer, so that you’ll be able to access it, run reports and understand its editing capabilities.
Duration: 12 min 39 sec

Setting Up An E-Marketing Campaign

Sage CRM version 7.1 and above includes Sage E-Marketing, an integrated system that makes it easy to setup and track your email campaigns. In previous tutorials, we’ve shown how to create your list of recipients, import your email template and how to insert merge fields and hyperlinks for personalization and tracking. In this tutorial, we show you how to setup an E-Marketing Campaign and send an email blast.
Duration: 5 min 55 sec

list of steroids

Posted in CRM Videos, Customer Relations Management (CRM), Enterprise Resource Planning (ERP), ERP Videos, May 2012, Newsletter, Tips & Tricks Videos | Leave a comment

How do the updated Accounts Groups in the v6.0 General Ledger affect me?

In Version 6.0, the standard set of account groups that come with Sage ERP Accpac have been modified.

To use the sample reports that come with Financial Reporter with your own data, your accounts must be assigned to the same standard account groups.

To use the new “snapshots” that are available in the Sage ERP Accpac Portal (samples below), all your accounts must be assigned to account groups and all account groups must be assigned to group categories. If you don’t want to use general ledger data snapshots, you don’t need to remap existing accounts to new account groups.

If you have not used account groups previously, note that the Account Groups form appears only if the Use Account Groups option is selected in the G/L Options form.

New Group Categories
Group categories  organize your accounting information especially for presentation in the Sage ERP Accpac Portal. The new Income Statement and Balance Sheet snapshots retrieve data from group categories that are linked to your general ledger accounts through account groups.

If you plan to use the general ledger snapshots, you must first:

  1. Ensure that all account groups are assigned to an appropriate category from the new set of group categories. (Assign group categories using the Account Groups setup form.)
  2. Ensure that all general ledger accounts are assigned to appropriate account groups. (Assign account groups to group categories using the Account Groups setup form.)

New Financial Reporter Sample Statements
Financial Reporter includes a set of sample statements that now use the new account groups.

If you want to use the new sample statements with your own data, you must ensure that your accounts use the new standard account groups. (If you use different account groups, you must customize the report forms so that they use your account groups.)

If you do not want to use the new set of sample financial statements, you can continue to use the statements that shipped with earlier versions.

If you know someone who could benefit from our blog, or from our other resources such as the Success Newsletter or our Tips & Tricks Videos, then please forward this article to them or refer them to our website at www.axisgp.com. steroiden

Posted in "How Do I" Tips, Enterprise Resource Planning (ERP) | Leave a comment