Archive for Uncategorized
Product Update 4 for Sage ERP MAS90 and 200 – Here’s What’s New
Sage have just released their Product Update 4 for Sage ERP MAS 90 and MAS 200. You can download your own copy (we recommend checking with your Sage Business Partner first since you may need to update any enhancements or third party programs) from this link. Below is a complete list of the fixes added [...]
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), [...]
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 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 [...]
Sage MAS 90/200 FYI from Zip: v4.40 Product Update 2 (PU2)
Product Update 2 (PU2) for Sage MAS 90/200 v4.40 is expected mid-July or shortly thereafter. http://www.s-consult.com/2010/06/24/whats-new-in-mas-90-4-4-product-update-2/ Posted by Brett Zimmerman.
Using MAS90 and MAS200 Customizer Scripting to show a document related to an inventory item
This came from a stream in our discussion group. It allows you to associate a PDF (usually a drawing) with items and have the ability to click a button to automatically bring it up (and email it if necessary). It is designed to properly error trap if the document can’t be found. Thanks to all [...]
90Minds member, Clients First holds Spring MAS90/200 User Group-Video Here
Thanks to all those who attended our Sage MAS 90 and MAS 200 user group on May 20th, 2010 at our Clients First Business Solutions Holmdel New Jersey offices. We had attendees from all over come see what’s new with MAS 90 and MAS200. Breakfast and lunch was served while attendees learned about the following [...]
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.
