Sage began shipping the brand new MAS 200 SQL version 4.45 this past month.  By combining the flexibility and powerful customization capabilities of the MAS 200 Business Framework with Microsoft SQL Server 2008 R2, Sage makes it even easier for a small- to medium-sized business to operate more effectively and efficiently.

Version 4.45 is optimized for SQL Server to offer scalability, easy integration with other applications and enhanced reporting services.  It takes advantage of SQL Server capabilities such as job scheduling, database maintenance plans and faster searches.  Integrations with other applications take place at the application level using Business Objects to ensure successful upgrades to new versions.

The Business Framework provides the ability, using standard scripting, to automatically change the available choices that are presented in MAS 200 or to automatically enter data.  For example, a script could automatically change the expiration date of a sales quote depending on the type of quote that is chosen for a particular customer.

For additional details, please click here for Sage’s Pre-Release Announcement for version 4.45.

The procedures for processing your first MAS 90 or MAS 200 payroll in 2011 have changed due to the social security tax rate decrease that goes into effect on January 1, 2011.

The social security tax rate is being reduced from 6.2% to 4.2% for employees (the employer portion is still 6.2%) for 2011.  The social security tax wage base limit also remains unchanged at $106,800.  Both the employee and employer Medicare tax rates remain unchanged at 1.45%.  For more details, click here.  According to the IRS, employers technically have until January 31, 2011 to implement the new rate.  However, I doubt many employees will want to wait that long.  By using the procedures detailed below, you can start using the new tax tables on your first 2011 payroll.

In the past, MAS payroll users have simply copied their live payroll company to a backup company and closed the year in the live company to start processing payroll for the new year.  The new tax tables were not installed until after the W-2′s were printed.  The reason behind not installing the new tables until after W-2 printing is that MAS 90 and MAS 200 use global tax tables.  In other words, all companies within MAS share the same tax tables.  Installing the new tax tables before printing W-2′s would change the social security tax wage base limit for employees who exceeded the limit resulting in incorrect Social Security wages on the W-2′s.

Since the social security tax rate has changed, you can no longer wait to install the new tax tables.  Regina Gutcher, a Sage Customer Support Specialist, has outlined the steps for running a 2011 payroll before printing the 2010 W-2′s:

  1. Backup all payroll data.
  2. Create a new company code in Company Maintenance.
  3. In the new company, copy the Payroll, Common Information, General Ledger and Job Cost (if integrated) from your live company.
  4. Process payroll year-end for the live company.
  5. Install the 2011 tax tables.
  6. Process payroll for the live company for 2011.
  7. Before printing W-2′s, install the 2010 tax tables.
  8. Print the W-2′s from the new company created in step 3.
  9. Reinstall the 2011 tax tables.

If you need assistance with these steps, please contact either Amy (ashaver@ariestech.com) or John (jshaver@ariestech.com).

It’s almost that time of year again!  The Sage MAS 90 and 200 Quarter 1 2011 Tax Table Update (TTU) and Interim Release Download (IRD) are expected to be released after December 17, 2010.  In addition, Sage will update the TTU as necessary through January 2011 with IRS-mandated changes, if any.  All of the program changes in the IRD will also be included in the Version 4.4 Product Update 4 and the Version 4.3 Service Update 21.  These two updates are expected to be available the week of December 27, 2010.  Please note, if you install Product Update 4 or Service Update 21 instead of the IRD you will also need to install the Quarter 1 2011 Tax Table Update before processing your first payroll for 2011.

Below are some tips to Frequently Asked Questions:

  1. Do I need to download the 2010 Interim Release Download (IRD):  The IRD is required for if you process 1099′s and use the 1099-INT or 1099-DIV form.  There are no changes to the Form 1099-MISC.   The IRD is required for Payroll customers running Versions 3.73, 3.74, 4.0, 4.05, 4.1, 4.2, 4.3 and 4.4.  The IRD is required for customers who are using Electronic Reporting for 1099 or W-2 filings.
  2. Do I need to download the 2010 IRD if I’m using the Federal and State eFilingand Reporting feature:  You will still need to apply the IRD if you choose to use Sage ERP MAS 90 and 200Federal and State eFiling and Reporting.
  3. I used the Magnetic Media module in previous years.  Are there any changes?:  Yes.  The Social Security Administration (SSA) will not accept W-2 information from employers on any type of magnetic media. Instead, they require electronic filing of W-2 information.  Sage MAS 90 or 200 versions 4.0, 4.05, and 4.10, and Sage MAS 200 for SQL versions 3.73 and 3.74 Magnetic Media module and SageERP MAS 90 and 200 versions 4.2, 4.3 and 4.4 Electronic Reporting module will allow you to create a MMREF-1 (EFW2) format file for uploading to the SSA’swebsite (www.ssa.gov/employer).  The MMREF-1 file is formatted to the SSA’s Electronic Filing and Magnetic Media Reporting specifications provided the applicable IRD has been downloaded and properly installed on your system.  Some states may still accept magnetic media filings; please check the informationyour state has provided to you for their policies.  If your state accepts magnetic media filings and uses the Federal MMREF-1 format, you can use the Electronic Reporting module to create the media for your state filing.
  4. I’m supposed to electronically file my W-2s in the EFW2 format, so why does Sage ERP MAS 90 and 200 show a MMREF-1 format?  The Social Security Administration has replaced all references to MMREF-1with a new acronym “EFW2″.  There is no need for concern, because even though your Sage ERP MAS 90 and 200 software will still reflect the historical MMREF-1 acronym, the file format is the same as EFW2 and will be accepted by the Social Security Administration.
  5. For companies who must print 1099 forms, what are the changes this year?  There are no new changes to 1099-MISC Form reporting in 2010.  Form1099 –DIV has form alignment changes for versions 4.20, 4.30, 4.40 and 4.45. With Form 1099-INT, a new box, Box 10, has been added to the forms and will be available in Vendor Maintenance in the grid to enter the CUSIP number.
  6. I have an Extended Solutions enhancement. Will I need to update it after installing the 2010 IRD?  If you own a Sage ERP MAS 90 or 200 Extended Solutions title you may need to update it because of 2010 year-end changes.   Please contact Aries to review which Extended Solutions titles may need to be updated after installing the IRD.
  7. Does the IRD contain changes to Payroll to support the Qualified Employee reporting as allowed by the HIRE Act?  Yes.  Customers running one of the supported versions of Payroll must have previously installed the Q2 2010 Payroll Update before installing the 2010 Year End IRD.  The Year End IRD includes additional changes to report Code CC in Box 12.  A 2010 W-2 HIRE Act Instruction Document will be displayed at the end of the installation of the IRD.

Please feel free to contact us with any questions!

On July 21, Sage issued an updated roadmap describing added features and details about upcoming versions.  These roadmaps are published and updated on a regular basis to provide a guide for upcoming versions of Sage MAS 90/200.

The next release for Sage MAS 90/200 will be Sage MAS Intelligence at the end of August.  Sage MAS Intelligence (SMI) is a financial reporting replacement for FRx (which is being discontinued by Microsoft as of December 31, 2010).  SMI is an Excel-based tool that provides pre-defined financial reports, access to all MAS modules (not just GL), user-level security and consolidation of multiple companies.

In addition, the new roadmap outlines the proposed Product Updates for MAS 90/200.  Product Update 2 was released on July 14.  Future product updates are slated for September 2010, December 2010 and March 2011.  In addition, Version 4.45 is scheduled for release in October 2010.  Version 4.45 will provide Microsoft SQL Server 2008 support (new license customers only) and enhancements will be made to the payroll, sales order, purchase order and accounts receivable modules.

Sage ERP MAS 90 and 200 Roadmap – July 2010

How can your small- to mid-sized business drastically reduce Information Technology (IT) costs and minimize the stresses of dealing with IT?  The answer is in the clouds.

Almost a year ago we completely eliminated our Exchange and Sharepoint servers.  Those two applications managed our e-mails and documents.

What replaced them?  Google Apps.  We quickly and easily moved all of our e-mail, documents, spreadsheets, images and presentations up to Google’s servers in the cloud.

My favorite part of Google Apps is a component called Google Sites.  Google Sites gives us the ability to setup a site for every project and share that site with our customers and business partners.  Sites make collaborating with the project team more effective by providing a real-time project management tool.

Let’s say that your design team and distribution center is in the Unites States and your manufacturing plant is in Mexico.  A Site could be created each time your company creates a new design.  Everyone on your project team would have the appropriate access to project scope documents, design images and the issues list.  Since these documents are maintained in real-time on the Site, management would have constant access regarding whether or not the project is staying on track.

So, how exactly does Google Apps reduce costs and stress?

Using Google Apps eliminates license fees for software such as Exchange and Sharepoint and it eliminates the need to pay IT costs to support and upgrade these applications.

There are two versions of Google Apps:  Standard and Premier.  The Standard version is free.  We elected to go with the Premier version at $50/user/year.  The Premier version provides us with additional storage space (25GB as opposed to 7.4GB) and includes spam filtering and virus scanning.

Because you are able to leverage Google’s virtual servers, you no longer have to worry about technical issues with servers at your site.  We were able to get rid of all but one server (and our goal is to get rid of it as well).  Not having to deal with servers was a huge reduction in stress for our company.

Are there downsides?  Of course.  We have experienced occasional periods of sluggish performance.  And without internet access it is a little tough to connect to the cloud.

If you are a real Excel power-user you may be disappointed in the functionality of the Google Apps spreadsheet.

However, here is the beauty of these types of Apps:  they are constantly being upgraded (sometimes daily).  The upgrades happen without any effort on your part and they are included in the annual price.

Will they eventually catch up to the functionality level of Microsoft Office?  Yes they will.  And I think they will surpass that functionality in the not too distant future.

Is your company using Google Apps?  If so, what has been your experience?

If not, why not?

By mid-July, Sage will make Product Update 2 available for version 4.4 of Sage MAS 90 and 200.  Any customers who are on a current plan with their Sage maintenance agreement are eligible to receive the update.

In an effort to provide additional features and benefits on a more timely basis than the traditional once-a-year upgrade, Sage is releasing Product Updates on a quarterly schedule.  Each of these Product Updates will include both customer-requested features and select additions from the Extended Solutions catalog.

The modules that are enhanced in this Product Update are Accounts Payable, Bank Reconciliation and Paperless Office.  In addition a new utility is being added that will assist with identifying any data issues prior to the installation of the Product Update.

Accounts Payable:

  • ACH Electronic Payments.  Reduce operating costs and lessen the risk of lost or stolen checks by paying your vendors electronically.

Bank Reconciliation:

  • Automatically reconcile checks.  Use an electronic file downloaded from your financial institution to automatically mark checks as cleared.
  • Positive Pay export.  As a way to combat check fraud, many financial institutions are now requiring and/or offering lower bank charges for customers who implement a Positive Pay system.  The Positive Pay Wizard generates an electronic file containing key information about your checks.  That file is transmitted to the bank for use in comparing with the physical checks that are presented for payment against your account.
  • In check, deposit and adjustment entry, the comment field has been expanded to 2,048 characters.
  • Tighter controls over Bank Reconciliation adjusting entries.  You can specify which users are allowed to access and make adjust balance entries.
  • Enter checks, deposits and adjustments on-the-fly without leaving the Reconcile Bank screen.
  • Utility to recalculate the totals of all outstanding check, deposit and adjustment entries that have not been marked as cleared.

Paperless Office:

  • If you pay your vendors using the new ACH Electronic Payments for Accounts Payable, the Paperless Office module will create, electronically send and retain PDF copies of checks, extended stubs and remittance advices to your vendors.

Please feel free to contact us with any questions.

The HIRE Act (Hiring Incentives to Restore Employment), enacted March 18, 2010, is a plan to create jobs by providing a temporary tax break to companies that hire workers who were previously unemployed or worked part time.  Two new tax benefits are available to employers:

  1. The payroll tax exemption.  The first benefit provides employers with an exemption from the employer’s 6.2 percent share of social security tax on wages paid to qualifying employees.  This benefit would be effective for wages paid from March 19, 2010 through December 31, 2010.
  2. The new hire retention credit.   Businesses will also be eligible for a general business tax credit of 6.2 percent of wages paid to the qualified employee (employee must be retained for at least a year), up to a maximum credit of $1,000.

Visit the IRS website for more detailed information and check with your tax adviser on whether the new HIRE act applies to your company.

Section 9006 of the 2010 Patient Protection and Affordable Care Act (aka ObamaCare) mandates that after December 31, 2011 all companies will have to issue 1099 tax forms not just to contract workers but to any individual or corporation from which they buy more than $600 in goods or services in a tax year.  Chris Edwards of The Cato Institute published an insightful article entitled Costly IRS Mandate Slipped Into Health Bill about the new regulations.

The bottom line could be that this change may radically alter the nature of 1099 filing and require businesses to issue millions of 1099 documents each year.  The two key changes are:

  • 1099′s would be used to track payments not only for services but also for tangible goods.
  • Businesses would be required to issue 1099′s not only to individuals and partnerships but also to corporations.  This list could include items such as a new computer purchase from Apple, airline tickets for next year’s conference, monthly office rent and phone bills.  Almost every vendor for every business would become a 1099 vendor.

The full impact of this new regulation won’t be known until the IRS issues its regulations.  That will probably happen sometime next year.  We will continue to update this blog as more details are made public.

The Cato Institute was founded in 1977 by Edward H. Crane, and is a highly-respected non-profit public policy research foundation headquartered in Washington, D.C.  For more information, visit www.cato.org.

This past Thursday,  Sage unveiled their brand new corporate blog.   The folks at Sage chose me to become one of a select few guest writers for the blog.

My first post entitled “Why Does Work Suck?” explores an idea that has become a fundamental part of our business and personal philosophy.  That idea is a Results-Only Work Environment (ROWE).  The basic concept is for businesses to eliminate fixed work schedules, required meetings and rigid vacation/sick/personal policies and to focus on achieving results.

I expect to be a regular contributor to the Sage blog with as many as one post per month aimed at educating  some two million global Sage customers and prospects about a host of business and technology topics.  Some of my upcoming topics include:

  • How to reduce IT costs and stresses
  • How to initiate a project within your company
  • What is project management and why is it important?
  • Pricing strategies
  • How to choose a web designer

If there are any topics you are interested in learning more about, please feel free to make suggestions via a comment.  The topics can be specifically related to Sage and Sage products (such as MAS 90 or MAS 500) or anything related to business and technology.

The Sage blog is part of Sage’s overall social media strategy.  You can follow them on the Sage fan page on Facebook and on SageERP for Twitter.

And if you have not already checked them out, here are links to our blog feed, Facebook fan page and my Twitter page:

On February 18 I published an article (February 18 article) about Sage’s roadmap for upcoming versions and product updates in MAS 90/200.  By accessing the link below you’ll find a new roadmap published by Sage in March.  The new roadmap contains updated information specifically pertaining to the Extended Solutions that are expected to be incorporated into upcoming versions of MAS 90/200.

Extended Solutions are customizations for the MAS modules.  Previously, Sage announced they were getting out of the Extended Solutions business and would turn over support and future enhancement of the bulk of the solutions to authorized developers.  However, they are retaining 56 of what are considered the ‘most used’ solutions.  These 56 solutions will be gradually incorporated into future MAS 90/200 product updates over the next several years.

The new roadmap provides a timeline for incorporation of the Extended Solutions into the core product.  Click the link below to view the updated roadmap.

Sage MAS 90 and 200 Roadmap – March 2010

Sage MAS 90/MAS 200 Roadmap - Updated March 2010

« Previous PageNext Page »

Follow

Get every new post delivered to your Inbox.