Tips, Tricks & Tutorials: Drilling Down from Financial Statements & Snapshot of your Customer’s History

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

Drilling Down from Financial Statements

In this tutorial, you’ll learn how to drill down from your financial statements to see the underlying transactions.
Duration: 2 min 20 sec

Use the Company Summary Report for a Quick Snapshot of your Customer’s History

A very useful feature in Sage CRM is the Company Summary report that provides a snapshot of a customer’s interactions with your company. In this tutorial, we’ll show you how to access and customize this report.
Duration: 3 min 16 sec

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

Optimize Your Business with ERP

As companies continue to grow, they increasingly rely on processes, activities and systems to help run their businesses. These likely include a number of manual and automated workflows and procedures as well as a variety of applications and databases that are poorly integrated.  While this approach may have served its purpose in the past, at some point it can become burdensome.  And in today’s dynamic and highly competitive marketplace, it can dangerously impede productivity, profitability and growth.

Common Problems

While every company faces its own unique challenges, at some point along the way most will experience some or all of the following problems:

  • Slow production cycles,
  • Inefficient scheduling of resources (labor, machines and equipment),
  • Slow inventory turns and high carrying costs,
  • Uncontrolled purchasing procedures,
  • Inefficient materials management,
  • Data inconsistency across multiple repositories,
  • High overhead costs,
  • Poor on-time delivery rates,
  • Decreasing customer loyalty,
  • Delayed financial tracking and analysis, and
  • Limited strategic planning capability.

Over time, experiencing any of these can negatively impact the bottom line.  Being subjected to several at the same time can paralyze the business and make it impossible to survive in today’s competitive economy.

With disparate systems hindering growth and profitability, companies can benefit from the ability of the ERP system to help define best practices, optimize activities and gain control over processes. In fact, the most significant benefit of ERP software may be its ability to streamline operations. By automating business processes, which in turn improves accuracy of information and accelerates data flow, an ERP solution helps companies streamline day-to-day tasks and free up staff to focus on other more complex issues that require more personalized attention. As a result, productivity can increase and operating and overhead costs can be dramatically reduced.  But how does the ERP system do this?  Learn how an ERP system can do all of this and more by contacting us today.

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

With Business Intelligence, Integration is Key

In today’s dynamic business environment, every staff member needs the right information to perform their job effectively.  From high level executives who determine the strategic direction of the company to customer service agents on the front line who must react quickly to customer issues, when employees have access to the most accurate information at the time they need it, they are able to make more timely and better informed decisions.  And as the quality of decisions improves, the business realizes improved operational results.

Business intelligence facilitates this process by consolidating data from disparate sources in order to provide users with meaningful indicators.  But connecting multiple databases to the BI system requires often complex integration projects, and still, the information within the multiple databases can provide conflicting data.  By integrating all your information and business transactions in one coherent database, ERP systems provide a solid foundation for decision making tools.

Do You Need a Business Intelligence System?

Companies in need of business intelligence often have trouble accessing the information they need when they need it.  Though all the critical data they need to make better decisions are already within their company’s management system, users often struggle with complex queries and inappropriate export formats to retrieve basic reports about their business.  Compare the time and effort it takes to feed your management system with accurate data and the value you get in return.  Is it worth the pain?  See if any of this sounds familiar:

  • You don’t remember which of your multiple sales analyses in Excel is the most current.
  • You have to ask IT to create reports and, by the time you receive the reports, the information is no longer current or useful.
  • Employees have to run multiple queries to produce a single report.
  • You are unsure of where the numbers come from.
  • Mission critical data is spread across disparate systems and databases and accessing the information you need is difficult.
  • You spend too much time collecting data and creating reports manually for analysis rather than making important business decisions.
  • Complying with government reporting requirements is cumbersome and time consuming.
  • You make important decisions based on instinct instead of accurate current and historical data.
  • You can’t identify business trends.
  • You’re not sure where to focus your efforts to achieve your goals.

Business intelligence enables companies to better understand, analyze and predict what’s occurring with their business.  It provides managers with meaningful information to make more informed and timely decisions by monitoring the business environment, focusing on exceptions and consolidating data sources.

Staying on top of today’s dynamic business conditions is important.  Not only will you be better prepared to respond to circumstances that could negatively impact your business, but you also will be in a better position to take advantage of opportunities that can benefit your business. deca steroids

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

Let Your Voice Be Heard regarding Sage 300 ERP

Are you currently using Sage 300 ERP (formerly Sage Accpac)? Do you have any suggestions for future improvements or feedback for the software developers? If so, now is the time to let your voice be heard!

Visit the Sage 300 ERP Ideas Web Page to present your ideas to the Sage team for consideration in future product versions. Submit your own ideas or vote for product improvement suggestions submitted by Sage 300 ERP users just like you.

Take advantage of this opportunity to influence new product developments, and get the most out of your Sage 300 ERP solution. steroide anabolisant musculation

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

AXIS Named to Accounting Today’s Top 100 VARs

Axis Global Partners has been named to Accounting Today’s Top 100 VARs for 2012. The top 100 companies are selected from organizations specializing in the sale and execution of Enterprise Resource Planning (ERP) and business accounting software.

Seth Fineberg, Technology Editor of Accounting Today comments, “The VAR landscape is clearly changing and we are pleased to showcase those that remain at the top of their game. This list is truly representative of the top performers in the field and we are proud to have been recognizing them for over a decade.”

“It is an honor to be recognized as one of the Top 100 VARs,” said Manny Buigas, Principal of Axis Global Partners President. “Our dedication and hard work have paid off. Receiving this award is a testament to the quality of our entire team and we are excited to be recognized among this elite group.”

“We have intentionally built a culture that promotes trusted relationships with our customers in addition to excellent employees and strong solutions,” comments Tony Chiodo, Principal of Axis Global Partners. “We are excited that this effort has brought us this award for the third consecutive year and consider it an honor to be on this list.”

Posted in News, Newsletter, September 2012 | Leave a comment

Is Your Warehouse Operating at Maximum Efficiency?

Small to medium sized manufacturers and distributors are forced into examining their operational capabilities with environmental changes and growth. This could be a new generation of ownership, need for outside investment to fuel growth plans, selling new suppliers on product-line exclusivity, bringing on new customers with complex requirements, converting or adding new channels (on-line vs. distribution vs. retail) or competitors gaining market-share because of low-cost distribution models. Frequently, a tipping point is reached with struggles through the latest peak season, resulting in the need for operational changes that will ease growing pains.

Inevitably, this causes some reflection on internal capabilities.

  • Can my warehouse handle the increased business that we are projecting? How many warehouse employees will we need to hire? Could we hire enough resources to keep up with the business; is there a point of diminishing returns? Ultimately, what is our cost of processing an order and how does it change with volume?
  • Can we react quickly enough to changing variables within our business? How quickly can we react when our key performance indicators fall outside of acceptable tolerances?
  • What areas of our business are affected by compliance: customers, shippers, government?
  • Are we cost-effectively managing compliance? Do we have documented, adequate warehouse processes in place to feed our compliance systems?
  • Should we take on a new set of suppliers to offer a broader product line to our customers?  Can the warehouse handle more SKUs? How many? What is our capacity?
  • How does our operational performance compare with the rest of the industry? Are we getting scale from our operations? How does our scalability affect shareholder value?
  • Should we consider outsourcing our logistics to a 3PL?

There is an underlying “chicken and egg” scenario that arises from these questions; measuring a company’s warehouse operational effectiveness requires the tools to do so. Data needs to be captured in real-time at a warehouse functional level to objectify the answers and empower decision making. For example, how can a company compare efficiency levels between multiple distribution channels without understanding the average time it takes to pick an order? These kinds of questions will never be answered without real-time data collection or time-in-motion studies over a period of time.

Large Manufacturers
The implementation of real-time data collection in a warehouse is a foregone conclusion in large organizations. In fact, they recognize that not all data collection systems are created equal. They know that the only way to achieve “best in class” is to implement a WMS (warehouse management system) that will not only collect data, but optimize warehouse processes.

Unlike small to mid-sized manufacturers, large manufacturers spend significant amounts of money on data analysis. Specifically, they leverage experts in the field to understand optimal warehouse layout, volumetric calculations, engineered labor standards by warehouse task, and equipment utilization. This data preparation enables them to predict optimal process flow in their distribution center, combined with changes in facilities layout and network optimization.

The result of this analysis is the investment of millions of dollars in Tier 1 Supply Chain Execution (SCE) software with mass customizations to ensure that these processes are tightly followed. This benefits the large manufacturer through the synchronization of disparate warehouse tasks for improved equipment and labor utilization.  In addition, optimized processes result in seconds shaved off individual tasks and significant, aggregate bottom-line savings.

Small to Medium-Sized Businesses
It is astounding that many small to medium-sized manufacturers and distributors are still collecting data using pen and paper. The implication is not only that they don’t have adequate data for complex decision making; they also don’t have the tools to improve warehouse processes and thus cannot effectively drive costs out of their operations.

Most small to medium-sized businesses understand the need for change, which is often triggered by the catalysts described earlier in this post. However, given that small to mid-sized businesses are not prepared to significantly invest in the up-front discovery process in the same way as their large organization counterparts, the task shifts to mid-tier SCE vendors to not only differentiate their products, but to educate SMEs on their decision making.

As a result, the small to mid-sized business SCE software buying process becomes daunting for both the vendor and customer, given that there are hundreds of small to medium-sized applications on the market with differing value propositions. Competitive pressure and lack of buyer knowledge can result in misleading expectations during the sales process, thus dissatisfaction for both parties during the implementation phase of the project.

Small to mid-sized businesses can also benefit significantly from the improved processes available within SCE applications (in addition to data collection). However, the small to mid-sized business does not have the capital or internal resources to shepherd in a large-scale SCE implementation (of similar magnitude to the large business). This means that they need to seek alternative solutions to the Tier 1 providers that can provide similar benefits with reduced up-front costs and reduced stress on the small to mid-sized organization during the implementation phase of the project.

Contact us to learn more about how Supply Chain Execution (SCE) software can help your warehouse operate at maximum efficiency.

Posted in Newsletter, September 2012, Warehouse Management Systems (WMS) | Leave a comment

Tips, Tricks & Tutorials: Options for Printing, Exporting & Distributing Documents & Easily Add Selection List 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

Options for Printing, Exporting & Distributing Documents

Clicking the print button in Sage Accpac ERP not only allows you to print, but also provides you the ability to export your forms, document and reports in a number of formats and email them as well.
Duration: 3 min 16 sec

Easily Add Selection List Fields to Screens in SageCRM

Sage CRM Enables you to configure your own data fields with ease. In this tutorial, we’ll take a look at how easy it is to add a selection list field to a screen in Sage CRM.
Duration: 4 min 12 sec arnold schwarzenegger steroidi

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

The Key to Making Sales Tax Less Taxing

Managing sales tax compliance manually is a drain on resources and can put your business at risk of an audit. Most companies would never even consider handling payroll compliance internally; yet often take greater risks with the more complex tasks associated with sales and use tax.

Audits are expensive, time consuming and distract from core business activities. Many businesses turn to custom-built or on-premise solutions, which are expensive, burdensome to maintain and do not contribute to the overall bottom line of their business.

Your business is probably spending more time managing sales tax compliance than what’s necessary – and risking negative results as well. Use this ROI calculator to estimate the resources you are currently dedicating to this function and see the cost-savings of using automated compliance solutions.  If you like the Return on Investment and would like to learn more, contact our office today.

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

Properly Manage Your Assets with ERP Software

While it is true that no ERP system can fully protect cash, customer invoices, or hard assets, ERP provides process and reconciliation tools that reduce the risk of assets being mismanaged, lost, or stolen. Here are some examples of how ERP systems can protect your assets:

  • “Positive payment” exports to the bank as an external control to prevent altered or stolen checks from being paid
  • Bank reconciliations that track outstanding checks and deposits-in-transit
  • Accounts receivable aging and collection notes along with specific credit memo codes that identify the reasons for why invoices were discounted or written off
  • First-Expired, First-Out (FEFO) picking and potency management to reduce the risk of inventory write offs
  • Inventory transaction journals that provide a trail of all receipts and issues, including those related to unidentified physical count adjustments
  • Project accounting that allows construction costs to be accumulated before a new asset is completed and transferred to fixed assets for depreciation

System Security

Certain fundamental program logic and set-up parameters also provide control in the ERP environment. Restricted user access is an important function. User profiles can be developed to allow the user to create and/or edit master or transaction data based on defined roles. “View only” or authorization to generate certain reports may be granted to others on a “need to know” basis. For example, while the customer service representative must be able to review customer contacts and product pricing, the buyer often does not need access to that information.

ERP systems will not allow a document to be deleted once it is created. Although a transaction such as a purchase order, work order, sales order, or check could be cancelled or voided, it cannot be deleted or the serial number sequence would be broken.

Inventory records can be associated with lot and/or serial numbers and tracked by location and stock status, including quarantine. Through backward traceability, an enterprise can follow the history of a shipped product to in-house and subcontracted manufacturing operations, inspections and testing, and the origins of subassemblies and components. The document attachment feature can be used to store a digital copy of receiving paperwork such as a country of origin, heat treat, or sterilization certificate.

Finally, because of the integrated nature of ERP systems, different transaction records are tied to other records. One example is a return to vendor (RTV) shipment for non-conforming product that links to a debit memo, receiver, and the original PO. Another one is a customer return merchandise authorization (RMA) that links to the credit memo, shipment, and original sales order. Often the chain of recordkeeping can be accessed easily via a “drilldown.”

While there are numerous features in ERP systems that help companies protect their assets and keep them accountable, ultimately the integrity of an organization is in its people. Systems training, standard operating procedures (SOPs), codes of conduct, informative reporting, management by exception, and prompt action on auditors’ recommendations are all vital for the well-being and reputation of any company.

Contact us today to find out how ERP can protect your company while at the same time improve efficiency, visibility and collaboration. 

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

What are You Looking for in an Operational Business Intelligence System?

Any business that has been in operation for more than a few years can attest to the fact that they have more data than they know what to do with. While it may seem that the data collected through the years is no longer valuable, companies need to realize that tools such as business intelligence systems can help unlock profit-earning potential from the old data once deemed “useless”.

Operational business intelligence is a subset of business intelligence designed to give more people in an organization faster and easier access to more information to make better business decisions at the operational level. If you’re considering investing in an operational BI system, here are a few things to look for:

  1. A single management application that eliminates multiple point solutions. Entering data in multiple places is one of the least efficient things a business can do. A good BI system will help create a way for data to reach one central place and be accessed by people company-wide.
  2. Simple-to-use tools. You don’t want to be inundated with an overly complicated solution that creates more problems than it fixes. Choose something that’s easy to operate while still offering the solutions you’re looking for.
  3. The ability to capture data as it’s created. This will allow you to work without fear of losing any of your achievements and assure that you can always quickly and easily recall anything you’re done – whether it was six months ago or six minutes ago.
  4. An innovative organizational system. In general, it’s more valuable to businesses to be able to organize data by topic, function or business value than it is to organize it by date, size or location.
  5. A centralized management policy. It is critical for companies to use a centralized management application, rather than a handful of point solutions, so that data retention and protection policies can be enforced across all departments and areas of the company. The policy should stay in place for the lifecycle of the information, including deletion, should it occur.

Business intelligence is a great way for companies to make the best use of old data. It may seem like you don’t need all those old hard drives anymore, but actually, you can unlock a lot of value for all that achieved information if you use the right BI system.

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