Archive for ERP Tools
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 Zimmerman of The Fitzgerald Group.
Sage support for FRX continues through December 2012
According to a recent email alert from Sage the planned final day of FRX support is December 31, 2012.
FRX is a financial statement report writer included with all new purchases of Sage MAS 90 and 200.
Typical uses of FRX include consolidating multiple companies as well as creating a greater variety of financial statements that those [...]
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 issues [...]
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 [...]
How to select and choose an ERP or Accounting system and a solution provider.
39 Useful Tips
The first step to implementing a new accounting system is evaluating your company’s readiness for change. Before you begin looking at new features and setting fasttrack timelines, take time to set realistic goals and build momentum. Preproduction planning is the key to success.
Additionally, people who buy accounting software usually spend most of their time evaluating features. The fact [...]
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, chr(10) & [...]
Beth Bowers – MAS 90 Consulting and Subcontracting to Resellers
About Me
Beth is a Sage MAS 90 and 200 Authorized Consultant, Certified Trainer and Certified Support Specialist who specializes in subcontracting services to other MAS 90 consultants. She has been working with Sage MAS 90 and 200 since 1989 and currently works with resellers from coast to coast. As a Certified Consultant, Beth does not resell any Sage products.
Services [...]