Archive for ERP Tools
Sage MAS 90/200 Quick Tip from Zip: Restrict Date fields
If you’ve ever wanted to restrict any Date fields in Sage MAS 90/200 (e.g., Invoice Date) so that only certain dates were allowed, there’s an easy solution. (For example, if users are occasionally making keying errors.) Assuming you have the Custom Office module, and depending what version of MAS 90/200 you’re running, you can go [...]
Sage MAS 90/200 Quick Tip from Zip: Searching Item Extended Descriptions
In previous versions of Sage MAS 90/200, you couldn’t simply search Item Extended Descriptions (1 option was to create a User-Defined field to additionally hold this data for being able to search via an Item lookup). Well now it’s a snap. At your Item lookup, click the Custom button to personalize your lookup. In the Available [...]
Sage Support Phone Number List – June 2011 (North America)
Looking for a phone number to call Sage for technical support on one of their products? I’ve just stumbled across a great list of every product offered by Sage(well technically not every since Sage’s flagship ERP X3 is not on their) along with the phone number, direct link to the knowledgebase and a link to [...]
How Do I Add the User ID To My Custom Report in MAS 90? How Do I Show The Name Of The Persion Who Printed This Custom Report in Sage MAS 90 / 200 4.40?
Photo via psanford How can I add the user who printed a report to a custom report I added to the menu in Sage MAS 90 / 200? In order to print the User ID on any Crystal Report being run from the MAS 90 menu, you have to create a new formula in the [...]
Sage MAS 90/200 Product Update 5 for 4.40 (detailed overview)
Courtesy of Jeff Schwenk of Bottomline Software, here is a nice detailed overview document (with screen-shots, graphics, etc.) that explains what’s included in the latest Product Update 5 (PU5) for Sage MAS 90/200. Enjoy! What’s New in PU 4.40.0.5? – Posted by Brett A. Zimmerman - www.brettzimmerman.com – Twitter: MAS90_Zip
Sage MAS 90/200 Quick Tip from Zip: Compacted Date Table
Did you know that there’s a logical explanation behind all the funky characters that appear in the various Sage MAS 90/200 date fields (when viewing the data via Data File Display & Maintenace for example)? These are called Compacted Dates – where the 2-character values represent 4-digit years ( e.g., 2011 = ?; ). Compacted [...]
Download the latest FRX for MAS 90 MAS 200 Service Pack 11
Looking for the latest service pack for FRX? If you’ve tried searching the Sage site you probably noticed that the releases have all been pulled. The removal of FRX service packs is because Microsoft have eliminated the FRX product as of January 31, 2011. There can be no more sales of FRX licenses after this [...]
Sage ERP MAS 90 and 200 Tax Tables Updated For 2011 – Available Now
Sage have just updated their latest tax tables for Sage ERP MAS 90 and 200. This updated, dated 1/11/11, adds the states of Missouri and the unincorporated territory of the United States – Puerto Rico. In addition, if you have not downloaded the latest IRS Tax Guide for 2011 – you should also visit the [...]
Sage MAS 90/200 Quick Tip from Zip: Excel Data(base) Query
Did you know that you can pull your Sage MAS 90/200 data right into Excel?! This essentially enables you to create a dynamic Excel file that can be refreshed with the most up-to-date data. Open a blank Excel document. On the Data menu, select “Import External Data”, then “New Database Query”. (The Excel Data Query function doesn’t always [...]
Sage MAS 90/200 Quick Tip from Zip: Force Standard Cost in P/O Entry
If your MAS 90/200 Inventory Masterfile contains lots of items not set with Standard Valuation (e.g., FIFO, LIFO, etc.) but you’d like Standard Cost to default during P/O Entry, a common practice is to enable Vendor-specific Pricing Schedules to force it: A/P > Vendor Maintenance > Items > Pricing > tab, tab (dsct %, 0), [...]
