Archive for ERP Tools
Sage MAS 90/200 Quick Tip from Zip: Uppercase Address Utility
It’s not uncommon for your Customer and Vendor data to get somewhat out-of-whack – in that you lose consistency regarding some data being all Uppercase, some all Lowercase, and some Mixed Case. This can be a little frustrating but luckily there’s a nice simple Utility to rectify it: Uppercase Address Utility (SWUPCS). This standard MAS 90/200 Utility allows [...]
Sage MAS 90/200 Quick Tip from Zip: Hosted Solutions – Applianz and ScionASP
Are you interested in a hosted solution for your Sage MAS 90/200 system? Well here are two options you may have come across: Applianz and ScionASP. Below is some information I had compiled a couple years back when I originally looked into Applianz and ScionASP. I have not had the opportunity to be involved with either an [...]
Sage Connecting The Dots! – Online Conference
It looks like Sage was in stealth mode with this online conference held yesterday September 28, 2010. One of our 90 Minds members sat in on the conference and described it as a virtual exhibition hall with various vendors providing demonstrations. Sage’s site describes the conference as: The Connecting the Dots! Sage ERP Online Conference [...]
Sage MAS 90/200 Quick Tip from Zip: Excel Sheets Separator
This is a neat little tool: Excel Sheets Separator - “Are you still bothered by the cumbersome job of splitting multi-worksheet Excel files into single-worksheet ones? You may have created one too many sheets in Excel, and now you want to move the sheets to separate Excel files. Excel Sheets Separator is your right choice in [...]
What will Sage ERP MAS Intelligence include?
(This information was correct as of 7/8/10) Sage’s new Business Intelligence product, MAS Intelligence, will begin shipping to partners later this month (July) and to end users next month. “Shipping” actually consists of a download. The product is made up of several modules, including the Report Manager, Report Designer, Security Manager, Report Viewer, and Connector [...]
Sage MAS 90/200 Quick Tip from Zip: Crystal, blank date
If you ever need the ability to enable criteria on a Crystal Report, for dates that equal ‘blank’, a simple formula like this will do the trick: {date field} = Date (0000, 00, 00) Posted by Brett Zimmerman.
Sage’s MAS 90 & MAS 200 FRX Replacement is From Alchemex: To Be Branded Business Insights Intelligence
Alchemex was kind enough to give us an hour long demonstration of their Business Intelligence product. Sage expects to begin shipping this, rebranded as Business Insights Intelligence (Update: The branding has changed slightly since our demonstration and the product is now being called Sage MAS Insights), by the end of 2010 to all users active [...]
MAS 90 and MAS 200 – Filename extraction in Crystal Reports
In addition to using the “File Path and Name” Special Field in Crystal Reports, have you ever wished you could just show the Filename? You can with this formula: Mid (Filename ,InstrRev (Filename,”\”) + 1 ) http://tinyurl.com/y8u8gtk Posted by Brett A. Zimmerman - www.brettzimmerman.com – Twitter: MAS90_Zip
Sage support for FRX continues through December 2012
According to a recent email alert from Sage the planned final day of FRX support is December 31, 2012. FRX is a financial statement report writer included with all new purchases of Sage MAS 90 and 200. Typical uses of FRX include consolidating multiple companies as well as creating a greater variety of financial statements [...]
Add country names to MAS90 forms
If you’ve ever tried to add the country name to a MAS90 or MAS200 graphical form then you know how frustrating it can be. Early versions of MAS90 (and MAS200 also) required that you attempt to link in the master file containing the country code name (MAS90 and MAS200 data layouts here). One of the [...]
