Beth Bowers has posted a great set of tips for MAS 90 and MAS 200.l  I've reviewed this and can say they are some of the most popular questions we get. Topics included but are not limited to:  printing daily transaction register updates if you didn't say 'yes' when asked the first time Dealing with fractional units of measure and the use of EACH Managing access rights of employees within date ranges Attaching any type of document via memos.  This includes attachments to forms such as an invoice or purchase order How to save personalized report settings Dealing with the infamous problem in AR where invoices appear to already be paid in full when they aren't Dealing with "Check Printing is already in progress" messages Copying masterfile information from one company to another Dealing with "Error 65" And more.  See the full post here ...read more

Thanks to Wayne Schulz If your company started using Sage MAS 90 or MAS 200 prior to October 1, 2003 then read on - because there’s a promotion from Sage that you should take advantage of. Sage is presently offering a bundle of software that they’ve termed the Sage Extended Enterprise Suite for MAS 90 and MAS 200. This bundle is comprised of Sage MAS 90 or 200, SageCRM and SageFAS. Each of the products launches from a common menu and integrates with MAS. Sage Extended Enterprise Promotion for Grandfathered Users The following promotion is good ONLY for users of Sage MAS 90 or 200 who bought prior to October 1, 2003 and who are current on maintenance. It does NOT apply to any other users. Here’s the offer: Through the end of Q3 (June 30th, 2009), you can migrate existing MAS 90 or 200 “Grandfathered” customers to Sage MAS 90 or 200 Extended Enterprise Suite, and offera flat, per-user annual EES maintenance fee of only $150 per existing user!In most cases, we have been finding that customers can migrate to EES and enjoy lower annual maintenance than they are currently paying! During tough economic times, this may be critical to customers who are struggling! Please make sure to highlight the following benefits when speaking with your clients: 1. Reduce your current annual maintenance and enjoy additional modules and features! 2. Manage your business more effectively with a complete 360 degree view of your business! 3. Streamline costs and enhance customer relationships with full CRM functionality! This promotion wouldapply to Sage MAS 90 and 200 customers who purchased their system prior to October 1, 2003, and are currently on a “Grandfathered” status.Please note: the $150 per user fee applies to existing users only. Standard EES maintenance rates will apply to new add-on users. The promotion does not include maintenance on modules and extended solutions outside the EES product suite. There is also a $500 per user license upgrade fee that is charged for anyone upgrading. If you’re company qualifies, please talk to your Sage Business Partner and see whether it would be beneficial to upgrade your software to the new Extended Enterprise Suite. Depending upon what version of MAS 90 or MAS 200 your using there may not even be any data conversion required. Update byMark Chinsky ...read more

ByMark Chinsky• February 11th, 2009FromClients First Business Solutionsand90minds Use this query to show you a list of open balances by customer group. If you would like to see open balances by vendor, then change theWhereclause tocs.cardtype = ‘S’. /* Shows the open balances by Customer Group */SELECT gp.GroupCode, gp.GroupName, Sum(cs.Balance) ‘Open Balance’ FROM OCRD csINNER JOIN OCRG gp ON gp.GroupCode = cs.GroupCode WHERE cs.CardType = ‘C’ GROUP BY gp.GroupCode, gp.GroupNameORDER BY GroupNameFOR BROWSE Thanks to Ed Monk ofSBONotes.com ...read more