Technology


Sage released a new roadmap for Sage 100 ERP (formerly Sage ERP MAS 90, MAS 200, MAS 200 SQL) as of April 2012.  This roadmap provides general information on new features as well as overall product direction for the Sage 100 line.

Below is  a general timeline for product updates and release dates:

Two changes of note are the addition of Sage 100 ERP Shipping by SmartLinc.  SmartLinc is a replacement for the prior Starship solution (Starship is sill supported by V-Technologies, independently) and is available in two versions

  • Process Shipper – on-premises, browser-based
  • Ship One –  cloud-based

SmartLinc includes complete carrier & shipping support for the US and Canada, as well as rate shopping, email notifications, and Bill of Lading support.

Another announcement is the Sage ERP Payroll module for SQL.  This will be a standalone payroll module and will integrate only to Sage 100 Premium (SQL).  This payroll module is based on the former Sage Accpac Payroll.

Another note of interest is that Sage Payments will play an even larger role in the Sage 100 ERP credit card transaction processing.  Payment data is not stored in the software itself but instead is stored in the Sage vault for tighter security and compliance.

Access the full roadmap here.

The fifth Sage MAS 90 and MAS 200 4.4 Product Update — 4.40.0.5 — is now available.  The update contains several core features and functionality enhancements in Accounts Payable, Inventory Management and Library Master.  The 2011 941 Form Update is also included in Product Update 5.

Additions include:

  • Multiple Company Aged Invoice Report:  Print your A/P Aged Invoice Report in a multi-company format and combine vendor information.  You’ll get a complete picture of your vendors across all MAS companies, helping you identify opportunities for improving the bottom line, negotiating better volume discounts or consolidating orders to save on shipping.
  • Accounts Payable Check Sorting Options.  Print checks alphabetically by vendor name, not just by vendor number.
  • Expense Distribution Tables.  Streamline the entry of invoices in A/P when you need to regularly allocate across multiple departments.
  • Security in Item Inquiry.  Four new permission settings are available to further restrict users.  These permissions apply to Item Inquiry and are Allow Access to All Item Inquiry Tabs Including Main and Quantity, Allow Access to Costing, Receipts and Vendor Information, Display Standard Cost Information and Display Vendor Information.
  • Inactive Items.  An inventory item can be designated as ‘inactive’ in Inventory Management so it can no longer be purchased or sold.  If an item is marked inactive, you can process returns using RMA or a Sales Order Credit Memo, or maintain history for warranty purposes.
  • Company-Specific Background Colors.  Assign an easily identifiable background color for each company in MAS.  This helps ensure entries are made into the correct company.
  • 2011 941 Form Update.

Contact Aries Technology Group at (865) 291-0005 x721 for further information about this Product Update or to arrange a time to install the update.  Thank you!

Sage has released the 2011 941 Form Update for MAS 90 and MAS 200.  The form update is compatible with versions 4.20, 4.30 (SP 17 – 21) and 4.40.  Changes to the form include:

  1. The year has been updated to 2011 on the entire form.
  2. A new entry field was added for Tax Due on Unreported Tips.
  3. There are no changes to the Schedule B for 2011.

Please contact Aries at (865) 291-0005 x721 if you have any questions.

Have you ever wondered where you can go to get answers to your Enterprise Resource Planning (ERP), Customer Relationship Management (CRM) or Human Resource Management Systems (HRMS) software questions?

The folks at 90Minds (of which we are proud members) teamed together to create Ask90Minds.  A free resource for questions regarding:

  • Epicor90-minds-200
  • Sage Abra HRMS
  • Sage Accpac
  • Sage MAS 90
  • Sage MAS 200
  • Sage MAS 500
  • SageCRM
  • SAP Business One
  • Microsoft Dynamics GP
  • Microsoft Dynamics NAV
  • Open Systems
  • Traverse

Why would you use Ask90Minds instead of the software publishers’ knowledgebases?  Because you want the real answers from real technology consultants who have years of in the field experience with companies just like yours.

90Minds is a network of 27 independent technology consultants who work everyday with a variety of business management software applications.  These consultants provide assistance with advanced technical questions.

In addition to technical support questions, you will find a rich and constantly expanding library of how-to articles, common mistakes and issues encountered with new software versions.

All of these articles are written in clear, easy to understand language that is unbiased by software publishers.

Give it a try and let us know what you think.

Sage ERP MAS 90 and MAS 200 Versions 4.0, 4.05 and 4.10 will be retired as of September 30, 2011.  After September 30, product updates — including year end — and telephone support will no longer be provided by Sage.  Customers who are on a current annual maintenance plan with Sage will, however, continue to have access to the knowledgebase which contains articles about the retired versions.

MAS 2o0 SQL Version 3.74 will be supported at least until MAS 200 SQL Version 4.5 is released (scheduled for late 2011).  Sage has not determined an exact retirement date for 3.74 but they may as the release date for version 4.5 gets closer.  My opinion is that Sage will support 3.74 for a “reasonable” amount of time to give 3.74 users enough time to move to 4.5.

For more information, see the Supported Versions document published by Sage as well as the Sage ERP MAS 90 and 200 Roadmap – July 2010.  Please contact us to assist with your MAS upgrade.  Helpful documents to review before upgrading are the MAS 90 Supported Platform Matrix and the MAS 200 Supported Platform Matrix.  These guides will assist in preparing your hardware and network for an upgrade.

Sage has released Product Updates 3 and 4 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 main enhancements in these two updates are to the Bank Reconciliation module.  Below are highlights of these new features:

  • Adjustments, such as bank fees and interest earned, can be entered directly into the Check, Deposit and Adjustment Entry screen and posted to General Ledger.
  • Easily select Bank Reconciliation transactions to flow to General Ledger from the Check, Deposit and Adjustment Entry Screen using a column titled ‘Select for General Ledger Posting.’
  • Information added to the Comment Field in Bank Reconciliation will also flow through to General Ledger when transactions are posted.
  • A new task added to the Bank Reconciliation Main menu — Transaction Register — provides the ability to post selected transactions from Bank Reconciliation to General Ledger.
  • New security has been added to the Role Maintenance in Library Master to provide more detailed security for users in the Bank Reconciliation module.
  • New Paperless Office features have been added to Bank Reconciliation, such as the ability to email and fax registers.

In addition, Sage MAS 90 and 200 4.4 is now compatible with Microsoft Office 2010.

For a complete list of enhancements in Sage MAS 90 and 200 Product Updates 3 and 4, please see What’s New in Sage ERP MAS 90 and 200 4.4 Product Updates 3 and 4.   Please feel free to give us a call if you have any questions!


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!

Did you know that you can issue a refund to an existing MAS Accounts Receivable customer through the Accounts Payable module?  Thank you to our good friend and colleague Robert Wood at DDF Consulting Group for sharing this helpful tip.

If your customer has a credit balance and you want to write that customer a refund check, you can do this by following a few simple steps in the Accounts Payable module.  Review Robert’s article for the steps.

Vendor Customer Link Maintenance

Next Page »

Follow

Get every new post delivered to your Inbox.