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.
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
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 [...]
Sage MAS90/MAS200 – Why won’t my comments print completely?
In Sage MAS90/MAS200 version 4.10 or higher, Sales Orders and Sales Order Invoices have the ability to have unlimited comment text fields. However, the STANDARD form defaults to printing comments PARTIALLY. Create a new form code and you will be able to save the Print Comments FULL option with the form code, and your comments [...]
Crystal Reports Tips and Tricks – Listing Selected Parameters
If you have a prompt in your Crystal Reports (known as a “parameter”) which can have multiple selections, you can list these selections on your Page Header. To list them in a column (remember to mark the field as Can Grow), use a formula such as (sample assumes String type parameters): @ParameterList = join (?Parameter, [...]
MAS90/MAS200 Open Order Report – Printing Only Orders With XXXX Product Line Items
A client wanted to see the open order report only for orders containing items in XXXX product line. However, he wanted to see the ENTIRE order if ANY item was in that product line. You would not know until you had read the entire order whether any items were in the selected product line, so [...]
