Archive for ERP
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 MAS 90/200 Quick Tip from Zip: 4.40 Upgrade – Open PO Report reconciliation
If you’ve upgraded to Sage MAS 90/200 4.40 and are having trouble reconciling the Open PO Report, be sure to take ”Completed” Orders into consideration. It appears this report in 4.30 (and likely prior versions) displays actual $$ for Completed Orders, whereas 4.40 shows $0. – Posted by Brett A. Zimmerman - www.brettzimmerman.com – Twitter: MAS90_Zip
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: What’s New in Sage MAS 90/200?
Are you considering upgrading your Sage MAS 90/200 system? Well here’s a great resource which details the major functionality and enhancements incorporated in the software since v3.50. http://services.sagesoftware.com/mas/whatsnew/default.asp – Posted by Brett A. Zimmerman - www.brettzimmerman.com – Twitter: MAS90_Zip
Sage MAS 90/200 Quick Tip from Zip: Edit Item Standard Cost in 4.40
Have you noticed in Sage MAS 90/200 4.40 that you are likely unable to edit the Standard Cost field in Item Maintenance? It’s grayed out. That’s because there’s now a new Standard Cost Adjustment Utility. http://infosource.sagesoftwareonline.com/infasp/kdb.asp?isresolutionconceptid=523315 Posted by Brett A. Zimmerman - www.brettzimmerman.com – Twitter: MAS90_Zip
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), [...]
MAS200 SQL 4.5 Users: Say Hello To Sage Common Payroll
Sage was dodgy when we grilled them questioned them last year at the annual Sage Insights 2010 reseller conference about the plans for payroll in the upcoming Sage MAS 200 SQL 4.5 re-write. The concerns then (and now) are that non-framework modules (namely Payroll, Job Cost, Work Order, and MRP) will NOT integrate to the [...]
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 [...]
