Sage MAS 90 and 200 ERP Product Update 4 (4.40.0.04)

Now available is Product Update (PU) 4 for Sage ERP MAS 90 and 200 released from sage on December 27th 2010. This is the fourth Sage ERP MAS 90 and 200 4.4 Product Update and is available for download from Sage Online. This update focuses on year-end changes and program fixes. New features and functionality are added in Product Update 5 that is scheduled for next year.

Sage ERP MAS 200 SQL v4.45 video - Part 2

Sage ERP MAS 200 SQL v4.45 has been released for New customers. This new version of MAS 200 for SQL looks very promising. Sage University released an overview video of this version of MAS 200 on SQL. Here is the second part of a video that Sage released. To see the first video, click here.

In this video, Sage will show what the product looks like and how you can get the information that you need to run your business. It will show how to use Microsoft SQL to make Views that can speed up reporting or make it easier to create reports.

Sage ERP MAS 200 v4.45 Video - Part 1

Sage ERP MAS 200 SQL v4.45 has been released for New customers. This new version of MAS 200 for SQL looks very promising. Sage University released an overview video of this version of MAS 200 on SQL. Here is part 1 - An Overview video that will shows what makes this version of MAS 200 powerful. This will answer questions about how it is installed, what are the benefits and other features available.

Next week we will go over part 2 that Sage has about the new SQL version.

Sage ERP MAS 200 SQL 4.45 is Released

Sage has released the first version, for the second time, of Sage ERP MAS 200 SQL. Version 4.45 is now available for newcustomers. This is not an upgrade from the 3.x version of SQL and is not considered to be the same product. This is a re-release of SQL as a new MAS 200 product. This version of MAS 200 uses the new Business Framework architecture. It has improved MAS 200 by using Microsoft SQL as the Database so that it will  provide stability and scalability. More can be seen about this release by going to http://www.SageMAS.com/MAS200SQL.

Some of the reasons you might want to go to this version of MAS 200 would be:

Year End Updates Scheduled to be released

It is coming close to the end of the year which means the Year End Updates are going to be released soon. Sage plans to have the Sage ERP MAS 90 and 200 Q1 2011 Tax Table Update (TTU) and Interim Release Download (IRD) available after December 17th, 2010. The downloads will be available from the Sage Online Support section.

Remember: If you are a Preferred Software Support account with MBA you can have us download and install these updates for you as part of your support.

As it is necessary Sage will update the TTU each week with late-breaking changes. The IRD changes will be included in the Product Update (PU) 4.40.0.4 or Service Update (SU) 4.30.0.21 when it is released. The SU and PU is expected to be released the week of December 27th, 2010. The TTU will need to be updated before processing your first payroll for 2011.

Sage MAS 90 and 200 ERP Product Update 3 (4.40.0.03)

Now available is Product Update (PU) 3 for Sage ERP MAS 90 and 200 released from sage on September 27th 2010. New customer-requested features streamline workflows and solve Bank Reconciliation pain points. One of the main reasons for most users to update to this PU is to have Sage ERP MAS 90 and 200 4.4 compatible with Microsoft Office 2010. The remaining enhancements are to Bank Reconciliation.

This PU has had a few issues with the release. There have been a few bugs reported with this release and MBA recomend waiting until the next PU release, unless the need for Microsoft Office 2010 compatibility is requried. Sage has already released fixes for most of the issues that were found after the PU 3 release.

Sage MAS Intelligence

Sage MAS Intelligence (SMI) is the replacement for FRx for Sage Software. Microsoft has given FRx an end of life date (end of 2012) and it is approaching. Sage is not going to wait around until the product is no longer supported. They have already found a replacement product and SMI is that product.

Sage ERP MAS Intelligence empowers you to quickly and easily gain control and obtain the information you need for operations and strategic planning. Using the familiar look of Microsoft Excel®, analyze Sage ERP MAS 90, 200, or 500 ERP data. Effortlessly create real-time, automated, and preformatted reports with up-to-date, accurate, and meaningful information. Sage ERP MAS Intelligence allows you to spend more time focusing on analysis and interpretation and less time pulling the data together.

ACH Electronic Payment

A new feature that was added with product update 4.40.0.2 is ACH Electronic Payment. ACH Electronic Payment update now provides you with the ability to pay your vendors electronically. This topic provides information and requirements for generating an ACH file that contains payment information for vendors that is submitted to your financial institution.

In this video from Sage University we can see how to use the new feature.

Enhanced Customer PO Number Validation

A new feature that was added with product update 4.40.0.1 is Enhanced Customer PO Number Validation. In Sales Order Options, you can now optionally choose to check for duplicate customer PO numbers in Sales Order Entry, Sales Order Invoice Data Entry, Sales Order History, Accounts Receivable Invoice Data Entry, and Accounts Receivable Invoice History.

In this video from Sage University we can see how to use the new feature.

Allowed Job Statuses in Data Entry Tasks

A new feature that was added with product update 4.40.0.1 is to have Allowed Job Statuses in Data Entry Tasks. You can now control the selection of jobs in data entry tasks based on the job status. For example, you can define settings that only allow users to enter a billing for jobs that have a job status of Complete.

In this video from Sage University we can see how to use the new feature.

Multiple Automatic Earnings for Payroll

A new feature that was added with product update 4.40.0.1 is multiple automatic earnings for payroll. You can now set up automatic earnings codes for employees to help with the data entry process in Payroll. Once defined, they can be used to automatically create Payroll Date Entry line entries using Auto Pay. This is beneficial for employees whose hours are routinely distributed to multiple earnings codes.

In this video from Sage University we can see how to use the new feature.

Sage MAS 90 and 200 ERP Product Update 2 (4.40.0.02)

After four months, Sage released the second product update to Sage MAS 90 and 200 ERP version 4.40 (4.40.0.2) on 7/16/10. The second Product Update is available via a compact download from Sage Online. Delivering additional features and functionality and product enhancements as an additional on-plan customer benefit, Product Update 2 delivers value across the system and in a range of modules including Bank Reconciliation, Accounts Payable, and Paperless Office. The Pre-release notification went into detail about new features that this release will include. Many of these enhancements are the result of incorporating the main features and functionality of select Extended Solutions into the core product, and others are totally new customer-requested features that solve pain points.

Also included in Product Update 2 is a new Pre-Installation Data Scan utility that will help identify data issues prior to installation.

If Master Developer or Extended Solutions customizations have been made to your Sage MAS 90 or 200 software, contact your Sage Software business partner or Master Developer before installing any Service Pack or Product Update.

Before installing product update, please note the following:

  • We highly recommend that you back up your system before installing any updates or version upgrades. Otherwise, data may be lost if the update fails.
  • Product Update 2 (4.40.0.02) includes a Pre-Installation Data Scan utility that helps identify potential data issues prior to installation.
  • Install this Product Update from the same computer that was used to install Sage ERP MAS 90 or 200.
  • After installing the product update, run WksUpdate.exe from the server's ..\Mas90\Wksetup folder at each workstation on which you would like to update the local help files.

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.40 in this Product Update. Product Updates are cumulative, containing all program corrections found in prior updates.

Pre-Installation Product Update Scan Functionality

The purpose of the scan functionality, introduced in the latest product and service updates (version 4.4.0.2) is to quickly identify data files that will not successfully convert in the update. The scan reads the primary key of each .M4T table for the selected company(s) (excluding reporting tables, but including Sage MAS_System tables) and identifies those data files that will not complete a physical update. At the completion of the scan, a log is displayed listing company data files scanned and data files that must be corrected prior to continuing the update installation. If data file discrepancies are identified in the log the update installation should be canceled and the discrepancies addressed prior to completing the update installation. The scan is not all encompassing, there are data file issues that that will not be identified by this first version of the utility and the scan is not a replacement for routine data maintenance. Please see below for exceptions to the current utility.

Service Update 4.30.0.19 Release

Sage released a new service update #19 for version 4.30 on 07/16/10. The service update can be downloaded from Sage's website under support. Follow the links for Service Packs / Program Fixes and choose the 4.30 Service Updates.

Sage Customers on Maintenance can download Service Update now!

When installing Service Packs:

  • Install service update from the same compouter that was used to install Sage MAS 90 or 200.
  • Be sure to apply this service update before data converstion.

For those customers that are on Preferred Support with MBA Business Software, remember that you get these updates installed for FREE! Call our office to schedule your appointment now to get this service update installed for you. If you are not on Preferred Support with MBA Business Software, why not call us to see what you can be getting for FREE as part of our Preferred Support.

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.30 in this Service Update. Service Updates are cumulative, containing all program corrections found in prior updates.

Product update 4.40.0.2 coming soon

Sage released a notice today to business partners that the new product update will be coming soon. This will be the second release to the 4.4 version of Sage MAS 90 and 200. The first pre-release notification for 4.40.0.1 noted new features such as Record Wire Transfers in Account Payable and Search by Lot or Serial Number in Inventory. In this pre-release notification for 4.4.0.2 Sage noted new features like a Recalculate Outstanding Entries Totals Utility for Bank Reconciliation and Positive Pay Export Wizard. New features that Sage has added to the product along with existing Extended Solutions that have been encorparated into the product continue to make Sage MAS 90 and MAS 200 a very strong product that continues to grow. We can all help Sage in their process of making Sage MAS 90 and MAS 200 a strong product by suggesting product enhancements. Here is what was in the announcement from Sage:

Service Update 18 reposted

Sage announced on Tuesday that Service Update 18 has been reposted on the website. The following is Sage's announcement:

Sage MAS 90 and 200 Service Update 18 (SU18) reposted

As of today, Tuesday, May 4th, the Sage MAS 90 and 200 Service Update 18 (SU18) is reposted on Sage Software Online.The revised SU18 installation files contain the following additions to address existing company data file corruption causing the update to abort:

  • The user is prompted to confirm they have a backup prior to applying the update.
  • Data dictionaries are copied to the Uninstall Information directory in the event the update fails.
  • An error message alerting the user that the upgrade aborted and identification of the file names that the conversion process has detected will cause issues unless repaired. However, this may not be a comprehensive list of corrupted files.

Troubleshooting PHP ODBC Connections to MAS 90

We are seeing more customers wanting to connect to their MAS 90 data and in doing so they are creating .net application or PHP applications that read ODBC. We already addressed how to do this in a previous articlewith .net. This article will assist in a few common issues when trying to connect PHP to MAS 90. We will not cover the PHP code to create the DSN or connect to ODBC. Instead we will address an issue when you try to connect that says "Table is not accessible, SQL state S0000 in SQLExecDirect".

When an error shows "Table is not accessible" the first thing that should come to mind is path and permissions. Here are the things you should first look at to see if your connection to MAS 90 should work. This is for version 4.x or greater.

Windows 7 Support for Sage MAS 90 and 200

Sage Software is now supporting Windows 7, Windows 7 - 64 bit, and Windows 2008 Server 64-bit Terminal Server as workstations for Sage MAS 90 and 200 version 4.3 and 4.4. This was implemented with the following program fixes:

Note: After installing the program fix, run Workstation Setup at the server and at all workstations, including workstations with operating systems other than 64-bit. For detailed instructions, please review the program fix documentation.

Sage MAS 90 and MAS 200 ERP Product Update 1 (4.40.0.01)

Sage released the first product update for Sage MAS 90 and Sage MAS 200 ERP software version 4.4 on 3/29/10. This will make the current product version to-date to be 4.40.0.01 and it brings two new functions to the software application. Typically Sage would not release new features with updates but as part of their new plan with updates, a select number of extended solutions will be rolled into the product.

For those customers that are on Preferred Support with MBA Business Software, remember that you get these updates installed for FREE! Call our office to schedule your appointment now to get this service update installed for you. If you are not on Preferred Support with MBA Business Software, why not call us to see what you can be getting for FREE as part of our Preferred Support.

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.40 in this Product Update. Product Updates are cumulative, containing all program corrections found in prior updates. This product update includes two new features and one extended solution that was announced in our previous post.

Give a piece of your mind to Sage

Sage software is listening but is anyone talking? Over the years people have suggested things to Sage via emails, webinars, and in person at events. But there has never been a place to go and see what people have suggested nor vote on what you think is important to have in the software. Now there is such a place http://www.sagemas.com/MAS_90_200_feedback.

SageIdeas

 

Sage MAS 90 and 200 Manufacturing Customers using version 4.4

There is an issue effecting Sage MAS 90 and 200 Manufacturing Customers on version 4.4 using Bill of Materials and Work Order with Bill of Materials.

The issue is related to the quantity per bill on component items on a Bill of Material rounding to whole integers for non-integer Unit of Measure items. Customers experiencing this issue should contact Sage Customer Support.

Possible Symptoms:

The following symptoms may occur:

Bill of Materials – Print Picking Sheets rounds the quantity per bill for non-integer Unit of Measure items to the next whole integer causing additional raw materials to be issued against the bill.

Work Order – Work Orders created using a Bill of Materials rounds the quantity per bill on non-integer Unit of Measure component items to the next whole integer:

  • Potentially causing additional raw materials to be issued against the work order
  • Will ultimately result in overstated costs on produced items

Product update 4.40.0.1 comming soon

NEW! Sage MAS 90 and 200 Product Updates Delivers Added Value!

You will soon be able to download the first new Product Update for 4.4 — 4.40.0.1.

Conveniently available via a compact download from Sage Online, the first Sage MAS 90 and 200 4.4 Product Update delivers new functionality and product enhancements as an additional on-plan customer benefit. Product Update 1 delivers value across the system and in a range of modules from Accounts Receivable and Sales Order, to Payroll and Job Cost.

New features available to you and 4.4 customers are:

  • Accounts Receivable (similar to AR-1027) - Locate an Invoice using Customer Information
  • Accounts Receivable (similar to AR-1200) - Cash Receipts Entry
  • Account Receivable (similar to AR-1027) - Search for Invoices by Lot or Serial Number
  • Accounts Payable (NEW!) - Record Wire Transfers
  • Payroll (similar to PR-1018) - Set Up Automatic Earnings Codes for Each Employee
  • Sales Order (similar to SO-1096) - Enhanced Duplicate Purchase Order Visibility and Safeguards
  • Sales Order (similar to SO-1271) - Additional Purchase Controls
  • Sales Order (similar to SO-1035) - Expanded Options for Quick Print
  • Sales Order (NEW!) - Print Back Ordered Information on Picking Sheets
  • Sales Order (NEW!) - Avoid Duplicate Picking Sheet Printing
  • Job Cost (similar to JC-1046) - Define Allowed Job Statuses in Data Entry Tasks
  • Inventory Management (NEW!) - Search by Lot or Serial Number
  • NEW! Enhanced Credit Card Security
  • NEW! Enhanced Searching Ability in Data File Display and Maintenance

Subscribe to Newsletter

Subscribe here for MBA Business Software's newsletter and product information to stay informed about the products and services offered by MBA.

90 Minds
90 Minds Consulting Group is an 
association of proactive consulting professionals who combine technology skills while still operating their own independent companies.

MBA Business Software
Headquarters
6100 Lake Forrest Drive, 
Suite 520
Sandy Springs, Georgia 30328
(P) 678-495-5700 
(F) 770-399-5772

Remote Office
Chicago, Illinois

twitterfacebookyoutubefeedlinkedin