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.
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 MAS 90 and Sage MAS 200 – Keyboard and Navigation Shortcuts
Select the Help menu at top of the MAS 90 screen, then Help Topics. Click on the Contents tab, then click Navigating Through the Software. Then on the right, click Keyboard and Button Navigation. Posted by Brett A. Zimmerman - www.brettzimmerman.com – Twitter: MAS90_Zip
Sage MAS 90 and Sage MAS 200 – “Shutdown All” feature
Be aware of a possible issue with the “Shutdown All” feature in Sage MAS 90/200. When it is used it may actually stay set in the SY_System file, so when a user tries to get back in, they can’t: They’ll enter their login info, the Business Desktop/Launcher will appear briefly, and then immediately will shut down. Resolution: From [...]
MAS 90 and MAS 200 – Edit existing Label settings in Crystal Reports 10
Do you need to edit the settings of an existing Crystal Reports Label in Crystal v10? It can be done, just not the same way as with Crystal v8.5. First you can access the File menu > Page Setup to adjust the margins. Then to edit the Label Size, Gap Between Labels, and Printing Direction, access the [...]
MAS 90 and MAS 200 – Onesy, Twosy Report selection criteria
When running a standard MAS 90 report and you need the ability to easily pick and choose a non-range of values (e.g., 10 specific Customers across your entire Customer Masterfile), simply use “Equal to” and separate the values by comma’s (e.g., 0032987, 0076352, 0919283, 0000111). Posted by Brett Zimmerman.
MAS 90 and MAS 200 – Launch a website from a Custom Office button
Ever have the need to add a button to a MAS 90/200 screen for launching a particular website? For example, maybe you want quick and easy access to current Exchange Rates (e.g., xe.com). Via Custom Office: External Link button > Type = Program; Module = External Program > click Edit Script button > type web address (e.g., [...]
