Building Sarbanes-Oxley Compliance Into Accpac With Purchasing Workflow

While most people associate the Sarbanes-Oxley Act solely
with e-mail retention and document storage, SOX’s real focus is
on the management of internal financial controls. That requires detailing
the accuracy and scope of accounting procedures and certifying that the
controls are helping prevent fraud, theft and inadequate disclosure.

Well publicized business failures and the introduction of the Sarbanes
Oxley Act was the beginning of a recent trend to place much more emphasis
on managing risk throughout an organization. Given the concern of governments,
investors, regulators and the public at large, public companies have been
forced by new laws to adopt a much more proactive approach to risk management
and internal control processes. Although initially forced to implement
an enterprise risk management framework to comply with these new laws,
public companies are now realizing many other benefits from these initiatives
that are increasing shareholder value.

Although not mandatory for privately held companies and small public
companies, who can argue with an initiative that will increase shareholder
value? Consequently, enterprise risk management frameworks are being adopted
by non-publicly traded businesses as “best practices” that
provide a structured approach to help them develop their own unique risk
management systems and strategies.

To help businesses meet those needs, software companies and their Solution
Provider Partners are offering tools to manage and monitor documents and
workflows, handle electronic signatures and automate manual processes.
To date, many companies have relied on dedicated SOX applications to accomplish
these goals and paid a heavy price for doing so. These companies and many
others are now realizing that standard workflow process and audit logging
tools can do the trick at much less cost to the organization.

Unfortunately, navigating the internal processes of an organization can
be tough. Companies have been focusing on what they have to do in order
to be compliant, rather than automating the process and making it repeatable.
As a result, many businesses are far behind where they should be in terms
of compliance or “best practices”.

Compliance with Sections 302 and 404 of the Sarbanes Oxley Act requires
companies to:

  1. Document the design and methodology of the financial reporting process
  2. Assess the risks and effectiveness of those processes, which include:
    1. processes’ speed to completion, flexibility, reliability
      and timing
    2. Patterns of internal fraud/theft
    3. Corporate management structure
    4. Data complexity, volumes, predictability, value and privacy concerns
    5. Process complexity, number of databases
  3. Monitor and track processes
  4. Evaluate processes’ effectiveness and vulnerability to risks
  5. Identify the causes of weaknesses and problems
  6. Fix problems
  7. Automate manual processes
  8. Repeat every year

Most companies now agree that automating internal processes is the key
to addressing compliance with Sarbanes Oxley. One of the most important
internal processes a company can automate is the purchasing process. By
automating the creation, management and approval of Purchase Orders you
make it less costly to perform and easier to test for violations of company
policy and SOX non-compliance.

The Purchasing Workflow Suite from Pacific Technology facilitates compliance
with Sarbanes Oxley by ensuring that:

  • all purchase orders are authorized at the appropriate level of responsibility
    based on job function, budget and dollar value limits;
  • new suppliers are reviewed and/or approved by management and that
    purchases can only be procured from “approved” vendors;
  • each purchase process is documented, automated and repeatable;
  • every purchase requisition is monitored for compliance with company
    policies and verified with supporting documentation where necessary;
  • any weaknesses or omissions in the purchase approval process can
    be quickly identified and corrected.

Some of the key features of Purchasing Workflow include: Multi-Step Approvals,
an Approval Console with drill-down to source transactions for Cost Center
Managers, an Event Log to record all transaction processes and different
Management Authority levels with different dollar value limits stored
against each of these levels. Purchasing Workflow also supports Vendor
Catalogues to track “Approved” Vendors with different pricing
configurations and lead times.

The workflow engine uses configurable rules to set transaction minimum
value thresholds, checking of a user’s own authority levels and
multiple authorizations on each transaction. Each action can trigger a
user-defined notification email to one or more personnel in your company.

When Approver staff are not available for periods of time, they can set
up a substitution entry so that any transactions routed to them are redirected
to the person they have specified as their substitute approver. Substitutions
are date-based so they can be set up in advance if necessary.

Purchasing Workflow also maintains a log for all events initiated within
the system so it is possible to see who requested and who approved a specific
requisition. A completion date can be tracked and if this date is not
met then escalation processes can be initiated. Reports are available
to show overdue actions and who is responsible for acting on the requisition.

A centralized purchasing function allows Purchase Orders to be created
in bulk from Approved Purchase Requisitions by range of vendor numbers
or range of requisition numbers and can consolidate items from the same
vendor on one Purchase Order.

There are several other modules from Pacific Technology which add functionality
to the core workflow system. Funds Availability tracks budget availability
for proposed purchases. Funds Availability operates in two modes: 1) providing
a Check that is carried out as a Workflow Step to route “for approval”
PO’s being raised against a GL account that has had its budget consumed
and 2) providing an enquiry screen that shows funds availability (Budget
Amount Less Actual Expenses, Commitments and Unapproved Transactions)
for all GL accounts within a Cost Centre.

Funds Availability also provides budget overrun value limits that each
authorization level can approve. The Workflow Engine will escalate the
Source Document to the appropriate person with Budget Override authority.
Once approved, the requisition can continue through the workflow.

Internal Issues primary purpose is to process transactions where
inventory is consumed within an organization. Workflow Documents allows a user to attach any document to the PO Requisition.

Businesses should be taking advantage of what their ERP systems offer
to automate manual controls. The Purchasing Workflow suite for Accpac
ERP provides a cost effective method of streamlining and managing the
purchase process to save time, eliminate mistakes and reduce the risk
of fraud. These benefits can increase shareholder value in your company
by providing productivity improvements and reduced audit and compliance
costs.

Posted in Newsletter, September 2006 | Tagged , , , , , , , , , | Leave a comment

Could Streamlining your Warehouse Win You More Satisfied Customers? – Basic Steps in Implementing a WMS Solution that Your Clients Can Appreciate

As business managers, we are always looking for better ways of responding to our clients. Delivering quality products in a timely and accurate manner is imperative in increasing customer loyalty. Solving issues such as inventory shortages, improper shipments, customer returns and stock overages, keep business owners and warehouse managers up at night. How can some of these problems be resolved? One solution is to implement a warehouse management software solution. But what does that mean?

Warehouse management software generally tracks data within the warehouse, providing information on movement of goods by personnel assigned to handle such tasks. Often integrated with shipping systems, this software provides discipline and structure to an otherwise unstructured, frantic environment.

Any warehouse management software (WMS) has common components necessary for implementation. Let’s take a brief overview of an implementation with an integrated ERP (enterprise resource planning) solution.

First, for an integrated solution to be effective, the ERP solution must be in place and stabilized (no longer being revised or modified to an extent that would disrupt an implementation in the warehouse), with products, customers and vendor master lists established.

The warehouse needs to be configured for the hardware components to set up an infrastructure to run a WMS. This infrastructure will need to be connected to the enterprise’s overall network framework. Hardware considerations include printers and barcode handheld scanners that communicate via RF with wireless access points throughout the warehouse. The wireless access points communicate with the main network structure to connect with an ERP.

With the basic infrastructure in place, consideration must then be given to special needs of the warehouse. Are there remote locations to consider? Do special hardships (large freezer space, perishable goods) exist? What about customer returns? Will current growth rates cause expansion of the existing warehouse space within the next business cycle?

Discussions and meetings are held to document the business processes currently in place so that the initial configuration of the WMS solution can be done to handle the business flow. They often uncover inefficiencies or obsolete processes that need to be revised, discarded or replaced. This is also a time when forgotten processes come to light.

Many of these questions are addressed during the prototype phase of the project, when the initial configuration of the WMS solution takes place and is further refined by developments discovered. Once the system configuration changes have been completed, then the actual training takes place.

After a brief training period, the system is turned on in the production environment and additional support is provided during a “go live” phase.

While this summary is brief in nature, we hope it provides an insight into the process as a whole. Implementing a WMS solution is often set aside because the costs or benefits aren’t as obvious as projects in other areas of the enterprise. Contact us and we’ll walk you through a 15 minute ROI questionnaire to provide some immediate feedback on how WMS can help your enterprise. For more information, e-mail us at info@axisglobalpartners.com.

Posted in Newsletter, September 2006 | Tagged , , , , , , , | Leave a comment

EFT Processing with ACCPAC – A “New” Solution in Demand

Isn’t it funny how old things become new again? We see it all the time in consumer products – the new and improved laundry detergent, great new taste in a soft drink, more crunch in a cereal, low fat, low carb food items. In traditional marketing theory changes to product formulas or food recipes are designed to extend the life cycle of these products by making an old product appear to be something new.

Electronic funds transfer is definitely not new. It has been around for over 40 years and has not changed much but lately it seems to be enjoying a renaissance of sorts as banks and credit unions encourage businesses to pay their vendors and employees electronically rather than write checks. What is the driving force behind this phenomena?

Technology has made it easier to commit check fraud and identity theft. New color printers and scanners make near perfect copies of check stock. Banks and credit unions process millions of checks everyday through automated clearing houses. As a result, numerous studies have shown that payor signatures are not able to be verified so it is possible to cash checks in bogus accounts and disappear with the money before the bank is alerted to the fraud because of the time it takes for paper based checks to clear.

Email communication and large centralized databases with confidential data have raised concerns about privacy and the need to safeguard business and personal information. Consequently, new Privacy Acts are now in place in Canada and the United States.

Well publicized business frauds have increased the scrutiny of businesses and how well they are managed. This has resulted in new legislation such as the Sarbanes Oxley Act in the United States. While most people associate the Sarbanes Oxley Act solely with email retention and document storage, SOX’s real focus is on the management of internal financial controls. That requires detailing the accuracy and scope of accounting procedures and certifying that the controls are helping to prevent fraud, theft and inadequate disclosure.

In addition to legislative changes for better corporate governance, payment associations in Canada and the United States have been pushing the use of check imaging technology to reduce the time it takes for checks to clear and limit the opportunity to cash fraudulent checks. The Check Clearing for the 21st Century Act (Check 21) went into effect in the United States on October, 28, 2004. In Canada, implementation of the check imaging initiative, formally referred to as “Truncation and Electronic Check Presentment” is targeted to begin in early 2008.

This shift to image based processing of checks in both countries is supposed to not only improve efficiency, but also allow financial institutions to introduce new services that provide faster and more convenient access to check images for customers than the common practice of enclosing cancelled checks with customer statements.

Ironically banks are re-introducing “new” EFT based services to their business customers to encourage them to send electronic payment files and not bother with the new check imaging solutions. If you find yourself in this situation read on.

EFT Processing is for any SAGE ACCPAC ERP customer who wants to streamline the payment process in their business and tighten control over bank transfers by sending electronic files to their bank instead of mailing and receiving paper-based checks. You can pay a group of suppliers easily and cost effectively in Canadian or U.S. Dollars. You save the time and cost associated with creating, distributing and reconciling paper checks and your cash flow becomes more predictable.

EFT Processing for AP Payments transfers ACCPAC AP Payments to the electronic funds transfer functionality of your banking software. Remittance advices can be emailed using standard ACCPAC functionality. Because EFT Processing is written in the ACCPAC SDK (Software Development Kit) it holds all Vendor banking details. It is also possible to support more than one file format for the same bank

The use of EFT Processing can result in several benefits to your business: reduced Bank transaction fees, elimination of redundant data entry and errors caused by manual entries, increased efficiency by processing payments electronically and avoiding the use of expensive check stationary.

Your customers will appreciate receiving their money on time, every time without waiting in a bank line to cash a check. Because a deposit can be made directly to their accounts, the payment is safer and more private than a check.

So if you are looking for a “new” EFT solution for ACCPAC, consider EFT Processing for AP Payments.

Posted in Newsletter, September 2006 | Tagged , , , , , , , , , , , , | Leave a comment

Can Your Company Benefit from an HR Strategic Partner?

Job Duties of traditional HR managers and personnel have included writing job descriptions, recruiting, new employee orientation and management of personnel files, among others. Today’s HR managers are being asked to become strategic partners in their organizations by justifying their department’s worth and value. As these roles continue to evolve, HR job duties and functions are also changing.

HR managers are being tasked with reducing the HR costs of an organization. They have to statistically show improvement in such metrics as improved timelines, reduction of absences and tardiness, successful defense against unemployment claims, improved workplace safety, and other key performance indicators that demonstrate value to their organizations. Like any other department, HR managers are now being forced to align HR goals with the company’s strategic goals.

With this increase in responsibility and measurement requirements, HR managers need to focus on results and providing them to management in a timely an almost instantaneous fashion. As a result, many companies are implementing HR software solutions that automate many of the functions being currently maintained manually and in spreadsheets. HR systems are “more” costly than the old manual cards and the “free” excel spreadsheets but the strategic HR manager will justify the investment and the return on investment (ROI) of an integrated HR system. Some of these benefits include, reduction of personnel, improving the management of benefits, gained efficiencies, and the avoidance of costly mistakes (such as missed insurance enrollments), and overpaid leave to name a few.

Switching from the traditional role to becoming at strategic partner of an organization as an HR manager won’t happen overnight. It can be accomplished by improving internal systems and keeping a “Can Do” attitude. As a trusted advisor for your business, Axis Integrated Solutions can provide guidance on becoming a strategic HR manager, provide advice on integrated system selection, and provide turn-key integrated HR systems. If you are a HR manager and are looking to become and integral strategic partner to your corporation, please contact us at your earliest convenience to discuss how we can assist you and your organization.

Posted in Newsletter, September 2006 | Tagged , , , , , , , , , | Leave a comment

Frequently Asked Questions

Sage
Accpac ERP

Q – Can I search for Optional Field values when using
the finders within any of the modules?

A – Yes. In Sage Accpac ERP version 5.4 you can now add the Optional
field values so they will be displayed in the finders.

In order to add the Optional Fields to the finders you will use the same
method you use adding any field to a finder. Click Settings in the Finder
and then click Columns to open the Columns selection box (shown below).
You would then “Include” your defined optional fields in the
Selected list.

The following displays two optional fields (Cash Flow Type and Account
Class) in the Finder after the Columns selection box is closed:

Values assigned to these optional fields are also displayed.

Q – Is it possible to enter a customer refund within the Accounts
Receivable module?

A – Yes. In Sage Accpac ERP version 5.4 the new Customer Refunds form
lets you refund customers for unapplied transactions such as credit notes,
prepayments, unapplied cash, and receipts.

In the example below a refund is entered for a credit note in the new
Refund Entry screen.

The Refund Batch List is very similar to the Account Payable Payment
Batch List. Once the Batch Listing Report is reviewed and you are ready
to print the check, you click the Print/Post button and the Print Check
screen is brought up and you are ready to print the refund check.

Sage Accpac
CRM

Q – Can I have more than one dashboard?

A – Yes. You can change around the content of your existing dashboard
at any time, or you can create new dashboards. For example, you could
have one suited to the type of information you want to see on a day-to-day
basis, and another one which shows you information you like to view on
a weekly basis.

  1. Select My CRM | Dashboard | New Dashboard, and create a new Dashboard,
    for example, Weekly Overview. Select the content and save. The new dashboard
    is displayed on the Dashboard page.
  2. Use the drop-down at the top of the page to switch between different
    dashboards.
  3. Use the Modify Dashboard button to change the content of an existing
    dashboard.

Note: You can also customize the content of existing standard dashboards,
set up by your System Administrator. If the dashboard you are editing
is a standard dashboard, which you have modified, a Reset Standard Dashboard
button is displayed on the Edit Dashboard Details page. Selecting this
button restores the content of the standard dashboard.

Changes made to Standard Dashboards do not affect the standard dashboards
of other users. When you modify a standard dashboard, you are effectively
making your own personal version of the standard dashboard.

Q – How do I create a New Report Category?

A – There are a number of standard report categories in SageCRM, for
example, Sales, Marketing, and Customer Care. A user in CRM v5.8, who
has rights to create new reports (a System Administrator or Info Manager),
can create new report categories.

  1. Select the Reports menu button. The page of existing report categories
    is displayed.
  2. Click on the New Report Category action button. The New Report Category
    page is displayed. Type in a name and description, and select the Save
    button.
  3. The new report category is displayed.

Q – How do I set up a Custom Dashboard?

A – To create your own Dashboard with all the content you need for your
day-to-day work:

  1. Select My CRM | Dashboard. Type in a Name for the Dashboard, for
    example, Daily Overview, and click on the Continue button.
  2. Select the content you want displayed on the dashboard by clicking
    on the Add buttons next to the items you want.
  3. You can use the Filter By drop-down at the top of the screen to drill
    down on content areas.
  4. Click on the Save button to save the dashboard. You are returned
    to the Dashboard tab, where your custom dashboard is displayed.

 

Sage Pro
ERP

Q – How can I edit Unposted Batches in General Ledger?

A – When trying to edit unposted batches in General Ledger (GL) it may
appear that the detail line items cannot be edited and only the header
section of the batch is editable.

  1. To edit unposted batches in GL follow these steps:
  2. Select Transactions from the menu bar and then Edit Unposted Batches.
  3. Select the Batch Number that needs to be edited.
  4. Go to the Line Item Detail tab.
  5. Choose the Select Line button on the left side of the screen and select
    the line item that needs to be edited. Click Enter on the keyboard.
  6. If only the header section of the batch needs to be edited, select
    the Batch Number and choose the Edit Batch button at the top of the
    Edit Unposted batches screen. Select Save from the top right corner
    of the screen.

Q – HOW TO: Print Bins on a Work Order Traveler?

A – Bins must be assigned to Bill of Material (BOM) component items for
them to print on the Work Order Traveler. The following steps demonstrate
the process to assign Bins to component items.
These steps may vary depending on the work flow used in a particular business
environment.

  1. For Bins to be enabled in Accpac Pro Series 7.3, the option must
    be selected in the Inventory Control (IC) module. In IC, go to the File
    menu and choose Change Setup Information. In the IC System Setup screen
    select the Proceed button and save the next screen (Default GL Accounts).
    In the Multi Location tab, select Use ‘Bins’ and save the changes.

    Note: The company must be setup as a multi-location company (in IC Setup),
    for stores and bins to be available.

  2. In Production Entry (PE), select the Maintain menu and choose Bill
    of Materials.
  3. Select the BOM and component to Edit. Enter the default Bin location,
    to be used for that component, in the Store/Bin field. Repeat this process
    for all appropriate components and subassemblies.
  4. Save the changes.
  5. Note: Bins may also be assigned or edited during WO creation.
  6. In the WO module under the Transaction menu, select Change Work Orders.
    Select the pick list button and when prompted to List work orders in
    what order? Select WO. Choose the work order to be edited.
  7. In the Change Work Orders screen, select the Lines button. In the
    Change Component Details
  8. for Work Orders screen, select the Edit button and highlight the
    component that will have a
  9. Bin location added.
  10. Enter the Bin into the Bin field. Repeat steps 5 and 6 for any additional
    components.
  11. Save the work order.
  12. The Work Order Traveler will now print the Bin for the component,
    as part of the description.

 

Back to Top^
Posted in Newsletter, September 2006 | Tagged , , , , , , , , , , , , , , | Leave a comment

Tool of the Month

Sage
Accpac ERP Data Integrity

Data can be damaged for a number of reasons. You can physically damage
your hard disk when moving your computer. Power fluctuations or interference
from an electric source (for example, a thunderstorm) can cause the computer
to write data inaccurately. Files can also be deleted accidentally.

In order to detect data integrity issues early and to minimize their
impact we recommend that you run data integrity at least weekly. For large
or more critical databases you may wish to increase the frequency. There
are also various 3rd Party utilities available that allow you to schedule
running data integrity to run unattended or to run their own integrity
checker; please contact your consultant for more information on these
products.

We recommend that you run the integrity check once without the “Fix
Minor Errors” option. If errors are reported, back up the data before
running the integrity check again to fix the errors. If the errors cannot
be fixed, then you must restore the data from backup. Creating a backup
is discussed later in this article.

When running Data Integrity you can choose which applications to check,
the order in which to check the applications, and whether or not to fix
minor errors. Since there are dependencies in the data from one application
to another, unless you have a valid reason, you should leave the Order
that the applications are checked in the default order.

To begin the integrity check, choose the Check button. When the check
is completed, choose the OK button to acknowledge the results message.
The results message will either confirm the applications checked pass
the integrity check or identify the numbers of errors found. If errors
are found, print and review the list of errors.

Some of the errors that might be reported can be fixed by modifying the
indicated records in the database, other errors can be fixed by running
data integrity with the Fix Minor Errors option selected, and other errors
may indicate a corrupted database. Please contact your consultant to assist
you with interpreting any errors reported.

Prior
to running Data Integrity with the Fix Minor Errors option selected you
need to make sure that you have a current backup of your site, company,
and user data. Your company, site, and user data is typically found in
the corresponding folders located on your server in the \Program Files\ACCPAC
folder. Depending on your database, your Company data and System data
will be located in the \Program Files\ACCPAC\Data\companydatabaseID and
\Program Files\ACCPAC\Data\systemdatabaseID folders or in the default
location of your particular database software (i.e. MS-SQL, Oracle, or
DB2). If you have any questions regarding backing up your Accpac data
and shared data folders, please contact your consultant to assist you.

After your data has been properly backed up run data integrity with the
Fix Minor Errors option selected, and re-examine the results of the error
log.

Posted in Newsletter, September 2006 | Tagged , , , , , | Leave a comment

Do You Need a Document Management Solution?

Five Worthwhile (and sometimes painful) Questions:

Every business has a document management challenge and every business has developed, over time, ways to cope with that challenge. Whether your current document management solution looks as complex as rooms in multiple locations around the country filled with filing cabinets, and a veritable army of clerks to maintain them; or as simple as stacks of cardboard boxes piled around the perimeter of the office you’ re sitting in right now; there are affordable, realistic, and functional solutions available to help.

To help you decide if your company has outgrown your current methods of dealing with that document management challenge, There are five simple questions to determine your need for a more robust document management solution.

Does filing, retrieving and storing paper documents consume human and monetary resources that could be better used elsewhere?

If you currently have staff members that are dealing with paper filing and duplication tasks that are not a part of their core job function, or whose time could be put to better use, then you are missing a major opportunity. It’ s not uncommon to be able to shift 2/3 of the resources dedicated to paper handling to other tasks after implementing a document management system. A recent Price-Waterhouse study concluded a lifetime cost per page at $.25. These costs are completely eliminated by going to a digital solution. Of course in addition to the costs are the various forms of labor associated with the retrieval of these documents.

Whether it is the ability to scale your business without additional hires or the option to reassign resources to more valuable tasks a document management solution should be in your plans.

Does your company have compliance standards or regulatory oversight that must be complied with?

If you’ re a public company, Sarbanes-Oxley makes the answer an automatic yes, but even small and medium sized privately owned businesses face OSHA, taxation, employment, and other federal guidelines for document storage and security. Depending on your particular specialization your business probably also faces requirements associated with HIPAA, ISO, FDICIA, the USA PATRIOT Act, or a host of other rules and standards. When faced with the fact that 2-4% of all documents are misfiled and 7.5% are completely lost, the possibility of non-compliance is high.

Document management systems do away with the risk of misfiling or losing documents, meaning you can always produce the document that your auditors are requesting.

Is there gap between your paper information and your enterprise data?

Even after implementing CRM, Accounting and ERP systems a huge portion of your corporate knowledge still exists in paper form. Vendor invoices, bills, Purchase Orders’ s, quotes, fax orders, and packing slips (to mention a few) are still filed, duplicated, passed around, and inevitably lost. Many businesses also have repositories of technical information or historical reports that are only available as paper at a single geographic location, not to mention, the documents stored on desktop hard drives and personal filing cabinets.

A document management system that is integrated with your enterprise software allows you to access your entire business knowledge storehouse from your desktop with security settings, back-ups and disaster recovery safeguards.

Do you have paper-intensive processes that create delays or lack oversight?

Another study estimated that 90% of all paper documents passed around an organization on a daily basis are merely shuffled and that no significant information is added or decisions made – sound familiar? It is also said that corporate professionals spend 40-60% of their time processing paper. By ensuring that early steps in a process are completed correctly before passing them along, processing time can easily be cut by as much as 50%. Add the efficiencies of completing these approvals online and you can gain significant throughput improvements and a competitive advantage.

A document management solution with a workflow process lets you recreate cumbersome paper processes online allowing you to speed approvals, and giving you the oversight you need to determine where these processes are breaking down, stalling, or working smoothly.

Do you have multiple departments, sites, or remote employees that need access to the same content?

If you have multiple sites or remote sales representatives, a document management solution can almost certainly increase collaboration and speed document processing. In some cases the cost of physically sending packages between sites may pay for a significant portion of the system!

Whether it is allowing sales people to remotely submit expense reports and project quotes, or the power to reorganize your Accounts Payable processes to allow for central processing; the ability to share knowledge, route information, and silo responsibilities across multiple sites will save your business money and promote efficiency.

If you have answered yes to even one of these questions then implementing a document management strategy for your business can streamline operations, encourage cooperation, and enforce security and compliance – giving your company a competitive advantage.  For more information or if you would like to schedule a demo, please contact us at info@axisglobalpartners.com.  To view this web-based document management and workflow solution please visit www.docAssist.com and take the Tour.  Sample a FREE 30 day Trial Demo.

Posted in August 2006, Newsletter | Tagged , , , , , , , , , , , , , , , , | Leave a comment

The Dollars and Sense of Online Backup

Businesses today face unrelenting data growth. IT staffs are struggling to ensure data availability under tight fiscal constraints. The unreliability and intensive management of tape-based backup has forced administrators to create manual, error-prone processes in order to protect their data.

Online backup answers these challenges by leveraging existing servers and networks to securely and efficiently protect servers, desktops, and even laptops against data loss. The key is to immediately move data backups securely off-site away from any potential site disaster. Greater security and reliability, and easier administration, make online backup the right choice for small and mid-sized businesses (SMBs) that are serious about protecting their business-critical data.

Heightened awareness around business continuity and regulatory compliance has caused businesses to increase spending on their data protection activities. Over 75% of companies are looking to change their backup approach.  What’ s behind the growing trend to online services?

IT Challenges: It’ s ugly out there

In order to understand the cost advantages of online backup, it is important to recognize the challenges that SMBs face in protecting their business-critical data.

Today’ s Data Protection Challenges

Problem Cause
Shrinking backup windows Proliferation of data-intensive, high-availability applications such as Web-based services (email, order processing) and other applications now require around-the-clock availability.
Explosive data growth It is reality, not a trend. The culprits include personal systems, data-intensive applications (e-business, CRM, personalization), new data sources (email, graphics, photo, video), retention/retrieval requirements, and business growth, all adding cost, complexity and risk.
Lack of central control over distributed systems IT staff managing off-site backups frequently must trust untrained co-workers to conduct backup activities such as swapping out and replacing tape media. Managing redundant hardware and software components in multiple offices also adds to the complexity.
External forces Regulatory, litigation, and reporting demands are forcing companies to produce more data and retain it longer.  In fact, companies spent an estimated $5.5 billion to comply with Sarbanes-Oxley alone in 2004.
Increasing rate of recovery failure Business continuity is jeopardized by viruses, accidental data deletion, and data corruption. As systems grow more complex, the inability to adequately recover an organization’ s business-critical data increases.
Human error Accidentally deleting an email or crashing a server from overfilling a disk drive is among the human errors that represent some 32 percent of application downtime and data loss.
Greater awareness of disaster risk Acts of domestic terrorism, high profile thefts, and 2005′ s most destructive hurricane season on record have made the risk of data loss / downtime more vivid than ever before.

Now is the time for online backup Technology should enable business not constrain it.

Market conditions and technology maturation have contributed to the traction online backup and recovery has made over the past few years.

Automation provides an added security layer – Using industry-standard encryption algorithms has made data transport over private or public networks a more secure way to transport backups than manually managing tapes. Having backups centralized in a secure facility further improves the security, reliability, and availability of data for retrieval or recovery.

Increased reliability drives better processes, lowers cost – Efficient processes make online backup a more reliable choice than tape. Scanning and storing only block level changes, for example, minimizes the volume and exposure of data traveling across the network. In addition, the data blocks are compressed, encrypted and then copied to remote disk drives. Companies can keep data longer, spend less time on backup management, and reduce costs for storage, backup management, media, and data retrieval.

Online backups facilitate business continuity – If an employee accidentally deletes a file or folder, the data can be retrieved online quickly and simply – around the clock.  If a company is required to produce a string of emails pertaining to a lawsuit and has an online backup, it can avoid contempt of court charges.  Imagine the cost and productivity savings.

What to look for —

  1. Automated and unattended backups with the ability to backup open files and open databases
  2. Ability to centrally manage the backup and restore process from one or more locations
  3. Control of files and directories to be backed up, with file-filtering capabilities
  4. Secure, Tier-1 facility
  5. Spontaneous file restores 24x7x365 via end user or central administrator control
  6. No special hardware requirements or changes to your network
  7. Ability to restore data either over the network or via a dedicated storage device
  8. Customizable data retention schedules
  9. Data encryption while data is stored on the storage array and during transmission over private or public networks

Changed data is compressed & encrypted

Automatic restart and resume capabilities for handling a variety of network conditions

  1. Automatic notification of exceptions and problems encountered
  2. Detailed usage reporting capabilities

Conclusion

IT staffs face more challenges than ever before to keep costs in check as they service employees and customers who are increasingly dependent on data access and intolerant of downtime. Even the U.S. Department of Homeland Security is urging businesses to protect themselves with a Disaster Backup/Recovery plan.  A convergence of regulatory and economic drivers, as well as technical innovations has led thousands of SMBs to implement online backup.

CoreVault online backup provides SMBs with the solution that best fits their needs. By controlling the growth of data being backed up, CoreVault customers quickly realize significant cost savings. They are also better able to support the backup and restores of remote offices and meet applicable regulatory, legal, and audit requirements.

The IT functions in your business are complicated enough. For small and mid-sized businesses, adding data protection expertise as a core competency simply does not make fiscal sense. Turning that function over to the leader  in online backup and recovery—CoreVault—will save you time, money and aggravation. CoreVault has the right online backup solution for companies like yours that are serious about protecting their business-critical data. For more information on CoreVault solutions, visit us at AXIS or call Manny Buigas at 305-418-9440.

Posted in August 2006, Newsletter | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

Tracking Time and Expenses For “Remote” Employees

The Internet has made it possible for Employees to ” telecommute” to their offices by accessing systems and information in the office from their homes. This is one way technology has created more flexibility for workers that don’t always need to be in the office or to help them stay on top of their assignments if they can’t make it to the office due to circumstances such as inclement weather or family emergencies.

For workers in service businesses such as engineering, consulting or temporary placement agencies, their ” office” is usually a client’s location. They may seldom, if ever, show up at their Employer’s office for work. Because these ” remote” Employees bill most of their time and travel expenses to customers they need to complete timesheets and expense reports to document how much time they worked and on which projects, what expenses they incurred and what time and expenses are billable to the client and which expenses are reimburseable to the Employee.

It can be difficult for Employees to submit their time and expenses on a timely basis if they hardly ever get to their Employers’ offices. More importantly, Managers need to know the status of projects or jobs to see if they are within budget and which Employees will be free to work on other jobs.

Keeping track of multiple Employees working on multiple projects for multiple customers can become an administrative nightmare. Fortunately, the Internet has also made it possible for ” remote” Employees to submit timesheets and expense reports on a timely basis, daily if necessary, and for Managers to be able to track and approve time and expenses ” online” with a new solution from Norming Software called eTimesheet.

Norming eTimesheet automatically consolidates employee timesheets by job and client. You can organize clients, projects, leave and Employees in a central database and report work and costs in many different ways.

Unlike traditional PC applications or client-server applications, Norming eTimesheet uses your Internet browser to run the application. The only software that is required on the client PC is a standard Windows IE browser. The application is installed and runs on your web server.

eTimesheet is a web based, stand alone solution that consists of 4 key modules: 1) Timesheets; 2) Expenses; 3) Leave and 4) Billing. All of these modules can be integrated to several SAGE ACCPAC ERP modules including General Ledger, Accounts Receivable, Accounts Payable, Project and Job Cost, Payroll and Bank Services. It can also be integrated to Payroll service providers and other back office systems if necessary.

The Timesheet module allows Employees to enter time in whole or fractional amounts against specific Tasks on a Job based on their Role on that Job. Since each Role is defined with both a billing and cost rate, the time entry becomes the basis for generating invoices to the customer as well as timecard entries for payroll or project and job costing.

There is a great deal of flexibility with Job set up. How you set up your Job directly affects what Employees will see on their timesheets and expense reports. A task may allow both billable and non-billable work, or an Employee may have multiple roles and rates. If a task allows both billable and non-billable work, the user will be required to select the appropriate billing option when entering timesheets for Employees.

Reports are helpful for determining how time is utilized throughout your organization and for reviewing job costs and client billing. You can generate reports to review detailed or summarized data.

The Expense module can track individual expenses by dollar amount or by quantity (ie mileage allowance based on the number of miles driven).

Each expense can have a different approver. The Leave module tracks vacation and sick leave for Employees either based on the number of days taken or the number of days remaining.

The Billing module generates time and expense billings to customers either in detail or summary. Detail invoices are based on AR Items in ACCPAC.

eTimesheet supports multi-level workflows for online submission, acceptance and approval of timesheets and expense reports by Job Managers, Supervisors, Line Managers and even Clients. Depending on the selected approval process, Job Managers, Department Heads, Clients, and Supervisors can approve, reject and/or comment on timesheets and expense sheets.

Norming eTimesheet sends e-mail notifications (if enabled) to inform approvers when an employee submits timesheets, expense reports or leave requests. Users can view their timesheet/expense/leave history at any time. The timesheet/expense/leave history is a record of old timesheets/ expenses/leave including comments and approval details.

eTimesheet’s audit trail keeps a record of every timesheet, expense report and leave request submitted, who submitted it and when it was submitted. It also tracks each time the timesheet, expense report or leave request is approved or rejected, and which approver performed the edit/approval/rejection.

A user can authorize another user to manage his/her tasks by assigning a substitute user. Each user can have multiple substitutes with different permissions. Each substitute user’s permissions are determined by the user who sets up the substitute. For example, if John Smith assigns Martha Brown as his substitute and gives Martha the right to enter his timesheets, Martha will be allowed to log in to the system as John and enter the timesheet on behalf of John.

eTimesheet makes tracking, billing and reporting of time, expenses and leave requests more efficient and cost effective for organizations of any size. If you are a service based business that works on projects or jobs for your clients or a company with employees who travel to conduct their work, eTimesheet may be the right solution for you.

Posted in August 2006, Newsletter | Tagged , , , , , , , , , | Leave a comment

Human Resources: All Your Players are Free Agents!

As the baseball season draws to a close, many managers are either making decisions to try to keep key players or wondering if they will walk as free agents to go other teams.  This happens from little league baseball all the way up to major leagues.  The same story holds true for companies and is one that employers and employees face every day.  It does not matter if you have a small business or are a Fortune 500 company, it is imperative that companies keep their key players.

One of the key factors to understanding of how to keep key players is to understand why they actually leave.   Leigh Branham, CEO of Keeping the People, has conducted over 19,700 post exit surveys and has provided employers some vision into why employees leave.  When questioning most Managers, almost 9 out of 10 said that the employee left for ” more pay” .

Much to the surprise of most business owners and managers, actually only about 1 out of 10 employees say that they left for ” more pay”.  In Ms. Branham’ s post survey 88% of employees left for reasons other than money.  These reasons are not obvious to most corporate leaders so she has written a book called ” The Seven Hidden Reasons Employees Leave” .  In this book she outlines and enlightens corporate leaders why employees actively disengage and become “free agents” in the employer pool.

The seven hidden reasons employees leave are:

  1. The job or work place is not as expected.
  2. Job doesn’ t fit their talents or interests.
  3. Little or no feedback and coaching.
  4. Feel no hope for career growth.
  5. Feel devalued and unrecognized.
  6. Feel overworked and stressed out.
  7. No trust or confidence in leaders.

Employers need to motivate employees.  Motivated employees are a company’ s best performers.  Only 25% of most corporate workers are actively engaged in the jobs that they perform.

Communication and engagement is the key to keeping valued employees.  When hiring employees is imperative to properly communicate job duties, corporate expectations as well as have an understanding of what the employee expects in return.  As a corporate leader, you should no longer be spending your ” sleepless” nights wondering if your key players are going to leave or stay, but instead focus on what have I done or what should I do to improve communications and engage and motivate my employees to want to be a part of ” our” successful business.  Refocusing your goals as a corporate leader will keep your key players close and minimize those who are looking to become ” free agents” and try out another team.

Posted in August 2006, Newsletter | Tagged , , , , | Leave a comment