DSD Business Systems DSD Business Systems News 
Product News, Tech Tips and the Inside Scoop 
July 2003 l www.dsdinc.com l 619-683-9900

Index   MAS 90 / MAS 200 l MAS 500 l Enhancements l CRM l Database Management

MAS 90/ MAS 200

Managing Growth

Join us for this free seminar and learn to manage growth by enhancing your MAS 90 or MAS 200 system or by plotting an upgrade path to MAS 500.

May 13th from 9-11am

Marriott Hotel & Marina, 333 West Harbor Drive, San Diego, CA

Register Now at: http://www.bestsoftware.com/seminars 

 

Best Revenues Rise

Sage Software reported an eight percent increase in revenue with a 30 percent increase in operating earnings for the first half ended March 31st. Revenue increased to about 216 million dollars with operating income at over 48 million dollars. Best reports that Act and SalesLogix revenue grew by 21 percent compared to the previous year. Results for other product lines were not reported.

Best's parent company, Sage Group, had revenue of $448 million for the half, up four percent from a year ago, while its operating income rose thirteen percent, to over $122 million.

 

MAS 200 and MAS 90 Promotions

Existing Customers

Receive up to 15% Discount on Add-on Modules for MAS 90, MAS 200 or MAS 200 for SQL* – Receive a 10% discount with the purchase of any two MAS 90 or MAS 200 add-on modules. Or receive a 15% discount with the purchase of any three MAS 90 or MAS 200 add-on modules.

$150 Rebate on ACT! – 5-Users*

Receive a $150 Rebate on a 5-user or more version of ACT!. Discount is based on SLP.

Receive 20% Off Any FRx Add-On Component*

Gold Plan members get a 15% Discount on Add-on Modules and Additional Users for MAS 90 or MAS 200*

Discounts on Gold and Silver Plan Upgrades *

10% Discount on Silver plans when a customer upgrades from Basic Plan to Silver Plan. 20% Discount on Gold Plan when a customer upgrades from a Basic Plan to a Gold Plan.

$1000 Silver Support Plan Tailored for Smaller Maintenance Needs* – For customers who are currently not on a Sage Software Phone Support Plan, and pay less than $1000 for their annual maintenance plan, Sage Software is offering Silver Phone Support for only $1000, a $500 savings off the regular price.

For more information, contact Stephanie Smith at 619-683-9900 or StephanieS@dsdinc.com

* Some restrictions may apply, please contact Stephanie Smith for promotion details and expiration dates.

 

Upcoming MAS 90 and MAS 200 Classes

Class

Class Dates

Cost per Person
Library Master and Security June 9, July 14 $425
General Ledger June 10, July 15 $425
Accounts Payable June 11, July 16 $425
Accounts Receivable June 12, July 17 $425
Inventory Management June 17, July 22 $425
Sales Order Processing May 21, June 18, July 23 $425
Purchase Order Processing May 22, June 19, July 24 $425
Crystal Reports June 5,6 and July 28-29 $800

You must sign-up at least two weeks before the class to reserve your spot!

All classes are held from 9am - 5pm, and cost $425 per person unless stated otherwise. Lunch is provided. They are held at the DSD Building in beautiful Mission Valley in San Diego.

To register by fax, download and print: http://www.dsdinc.com/forms/registration.pdf 

To register, call Sandy McCauley at 619-683-9900 or e-mail SandyM@dsdinc.com 

 

Closing Periods
Closing is Important!

by Ken Phillips

Period-end and Year-end processing is an important step in keeping your accounting data up to date and accurate. Most of the MAS 90 subsidiary ledgers maintain Period-to-Date, Year-to-Date and Prior-Year data in “bucket” data fields. The buckets are maintained at Period-end processing, or cleared and reset at Year-end processing. Additional housekeeping chores are also performed at Period-end and Year-end processing, such as removing completed Purchase Orders, and old invoice transaction history (based on flags set in the subsidiary ledger’s Setup Options).

  • MAS 90 General Ledger recognizes only two fiscal years as being “open” at a time, the current fiscal year and next fiscal year. MAS 90 allows you to post to any future fiscal year, but you will only be able to print financial statements for the current and next fiscal years. For example, if your current fiscal year is 2001, you can print 2002 financials, but you cannot print 2003 financials until you close fiscal year 2001.
  • MAS 90 subsidiary ledgers (like A/P and A/R) recognize only two periods as being open – Current Period and Next Period. For example, if the current period is February, you can post March transactions, but February must be close prior to posting April dated transactions.

No matter when the end of a company’s fiscal year is, all companies must properly perform the period-end and year-end procedures.

Closing Order

The order in which MAS 90 modules are closed is important.

  1. Bill of Materials
  2. Work Order
  3. Bar Code
  4. Purchase Order
  5. Sales Order
  6. Inventory
  7. TimeCard
  8. Magnetic Media
  9. Payroll
  10. Accounts Receivable
  11. Account Payable
  12. Job Cost
  13. General Ledger

If your company uses modules that do not appear on the above list, call DSD Support for help with your specific situation.

 

DSD Recommended Backup Strategy
How to Sleep at Night

by Ken Phillips and Andrew Ault

Tape backups of a company’s application data are critical in case of a massive system failure, or in case individual files need to be restored.

An adequate backup system must include the following elements:

  • Enough tapes for complete backups to occur on a predefined rotation
  • Regular testing of the system and media to ensure that restoration is possible
  • A person that is responsible to execute the backup plan on an on-going basis
  • The backup usually needs to occur when processing is not taking place (off hours)
  • A logical tape rotation schedule must be established and followed
  • Tapes need to be rotated to a secure location off site in case of disaster or theft
  • A calendar/log must be maintained to schedule tapes and record results

Information Specific to a MAS 90 or MAS 200 Backup

The following is necessary or helpful when backing up a MAS 90 or MAS 200 system:  

  • All MAS 90 data files should be backed up at the same time. DSD does not recommend incremental backups because if a massive computer failure were to occur, multiple incremental backup tapes would probably need to be restored and it would be logistically difficult to ensure that all data files were restored from the relevant series of backup media.
  • For ease, DSD recommends the entire "\Mas90" folder be backed up. If this is not possible, then at a minimum you need to backup your MAS 90 company data files, the "\SOA" folder (system files) and "\Home" folder (more system files). All folders below "\SOA" and "\HOME" needed to be backed-up as well.
  • MAS 90 uses a consistent folder naming convention enabling you to identify program and data folders.
  • Program folders always use the two-character application code. For example, the "\GL" folder contains the General Ledger program files. Program folders tend to be 5MB or less.
  • The company data folder format is five characters long including the two-character application code, and three-character company code. For example \SOABC is the ABC Demo Data Sales Order data files.
  • If the "\Mas90" folder is too large, check to see if you have multiple test company or demo company data files which could be deleted. If you no longer need the test company or demo company, you can delete them in Library Master/Utilities/Company Maintenance. When you delete a company the program will list the existing applications, and allow you to select which application files to delete. This can recover a lot disk space. Additionally, the MAS 90 program folders don’t always need to be backed up, since they can be reinstalled from the MAS 90 installation CD. (Don't forget any program patches or enhancements would then also need to be reinstalled).
  • Another technique for reducing the number of MAS 90 files is to periodically delete all the "*.OLD" files. When the MAS 90 rebuild utilities are run, you can save the original file. The original file is saved with the ".OLD" extension (from the standard ".SOA" file extension). MAS 90 does not provide a tool to purge these "*.OLD" files automatically, so deleting files will need to be done manually through Windows Explorer, or Find Files.

Example Ten Tape Backup Plan

A ten backup tape rotation is very common. The following backup plan is presented to give you a recommended schedule and method for daily backups, which will minimize potential data loss and re-entry time.

This backup scheme requires ten separate sets of backup media. A "set" of backup media means the number of tapes (or other media like disks) needed for a complete backup. This may be one tape (for other media) or more than one tape. Each set of backup diskettes or tapes should be labeled as follows:

  • Day 1
  • Day 2
  • Day 3
  • Day 4
  • Week 1
  • Week 2
  • Week 3
  • Month 1
  • Month 2
  • Month 3

When creating the calendar for a given time period, such as the next six months or year of tape rotation, use a standard calendar (whether paper or electronic) and enter the schedule in advance with the planned tape for each day. Then, each day, enter the results of the most recent backup, including:

  • Who performed the backup
  • When the backup was performed
  • Comments about the backup set

The backup schedule provides a daily backup for Monday through Thursday, followed by a weekly backup on Friday. The daily media is then recycled again until the next Friday, when the media for Week 2 is used. The cycle continues until all of the weekly media have been used. The next monthly media set is used in place of the weekly set, and the cycle repeats.

  • Day1, Day 2, Day 3 and Day 4 tapes correspond to Monday through Thursday and are used every week.
  • Week 1, Week 2 and Week 3 are used the first three Fridays in a month cycle.
  • Month 1, Month 2 and Month 3 are used instead of a "Week X" tape on the fourth Friday of a month cycle.

Off-Site Copy

It is essential to keep an off-site copy in case of disaster or theft. In this example, the off-site copy could be the Monthly or Weekly media (tapes made on Fridays). Additional backups performed at year-end and before period-end processing may also be very helpful in the event that any unforeseen processing problems occur which may affect your data.

Tape Rotation Over the First Four Weeks

Each tape made on a Friday under this plan should be rotated off site when it is done recording. As a practical matter this means that on Monday the backup person should take Friday's backup to the off-site storage location and bring back the previous off-site tape (from the previous Friday).

Week One 

Day: Monday Tuesday Wednesday Thursday Friday
Tape: Day 1 Day 2 Day 3 Day 4 *Week 1

Week Two 

Day: Monday Tuesday Wednesday Thursday Friday
Tape: Day 1 Day 2 Day 3 Day 4 *Week 2

Week Three 

Day: Monday Tuesday Wednesday Thursday Friday
Tape: Day 1 Day 2 Day 3 Day 4 *Week 3

Week Four 

Day: Monday Tuesday Wednesday Thursday Friday
Tape: Day 1 Day 2 Day 3 Day 4 *Month 1

*Note that what differs from week to week is the tape selected for Friday.

Make Sure that the System is Working

Ensure backups are periodically tested to ensure the backup program and hardware is working properly. DSD has found several instances where the backups appeared to be occurring, but when they were needed, the backups had not occurred or completed properly! Also, someone in your organization should know how to backup and restore your own data, or individual files in case of an emergency.

The type of media (usually a tape type) you select for your backups should take into consideration how long it takes to back up your data and your selected frequency of backups.

Call David Yaeger at 619-683-9900 (DavidY@dsdinc.com) in our DSD IT Department for help implementing your backup system, or to determine the best backup medium for you!


MAS 500

MAS 500 Promotions

Family Upgrade Program

Receive 20% Off SLP or 0% Financing on MAS 500 Migrations*

Customers using a variety of Best Software products can upgrade to MAS 500. Receive a 20% discount off the MAS 500 list price, or receive 0% financing on product purchases through the American Express Business Finance Program.

Existing Customers

Save up to 15% on SLP with Purchase of MAS 500 Add-on Modules*

Receive a 10% discount with the purchase of any two MAS 500 add-on modules. Or receive a 15% discount with the purchase of any three MAS 500 add-on modules.

Receive 20% Off Any FRx Add-On Component*

*Some restrictions may apply, please contact your account manager for promotion details and expiration dates.

For more information, contact April Holman at 619-683-9900 or AprilH@dsdinc.com.  

 

MAS 500 Web Events

All you need is an Internet connection and a telephone to learn about the latest solutions, technologies and services available from Best. Simply select the event you want to attend and register. Feel free to call us here with any questions or for more detailed information.

For more information, contact April Holman at 619-683-9900 or AprilH@dsdinc.com

MAS 500 Overview

5/29/2003 8:30 AM PST

MAS 500 is a highly reliable, robust and integrated series of applications covering all areas of enterprise e-business, including accounting, budgeting, distribution, human resources, payroll, enterprise reporting and electronic commerce. Natively created on Microsoft compatible tools, technology and architecture, MAS 500 is flexible, scalable and full-featured to deliver a total e-business management solution.

MAS 500 Distribution

5/22/2003 8:30 AM PST 
6/19/2003 8:30 AM PST

In today’s distribution environment, many factors can jeopardize your profitability. Learn how to maximize your inventory performance by stocking the right quantities of the rights items, at the right time, and at the right price. See why a distribution industry expert calls the MAS 500 distribution solution “the most powerful set of software tools available for helping a distributor maximize both productivity and profitability.” 

MAS 500 Manufacturing

5/22/2003 10:00 AM PST

This presentation provides an overview of MAS 500’s advanced manufacturing system. The presentation will cover system-wide features such as user interface, navigation, and system help as well as basic and advanced manufacturing features. This presentation is highly recommended for prospective customers, newly certified manufacturing software resellers, consultants, and others who want a general understanding of the manufacturing system.

MAS 500 Project Accounting

5/29/2003 10:00 AM PST 

MAS 500 Project Accounting, Sage Software's integrated PSA solution, enable managers to monitor costs, track employee time and expenses, analyze and forecast project data and import projects from Microsoft Project.

MAS 500 e-Business

5/15/2003 10:00 AM PST 

Leverage the Internet to reduce costs, improve customer satisfaction, eliminate barriers to productivity, and allow remote users to access critical business information. Easily integrate your existing e-business web site with our distribution solution, or utilize our out-of-the-box web storefront. The MAS 500 e-Business solution leverages the Internet to reduce costs, improve customer satisfaction, eliminate barriers to productivity, and allow remote users to access critical business information.

MAS 500 Customization

5/15/2003 8:30 AM PST 

The MAS 500 powerful Customizer adds productivity and greater control to your processes through customized information. You don’t need extensive programming knowledge to put MAS 500 Customizer to work for you, by modifying screens, forms and application interfaces to fit your business needs. The powerful Customizer adds productivity and greater control to your processes through customized information.


Enhancements

Product of the Month

Product of the month: Multi-Company Enhancements APMU and GLMU

15% off of new sales!

APMU has been designed to allow a managing company's Accounts Payable Department to process A/P transactions for an unlimited number of "subsidiary" companies.

http://www.dsdinc.com/enh/pages/apmu.html 

The GLMU enhancement has been designed to allow a managing company to process G/L transactions for an unlimited number of "subsidiary" companies

http://www.dsdinc.com/enh/pages/glmu.html 

For more information, contact Lisa Buchner at 619-683-9900 or LisaB@dsdinc.com

 


CRM

Are you still using TeleMagic?

TeleMagic has always been a great customizable product at an unbeatable price. We still have hundreds of our clients using it, some still using a DOS version from 10 to 15 years ago! But the sun is setting on the TeleMagic product line and you need to consider the long term ramifications of staying on TeleMagic. The product will no longer be supported by it's manufacturer after December 31st, and future versions of Windows may make the product incompatible with the latest Windows software.

ACT and SalesLogix are products that are made by the same company that makes TeleMagic. Both are very user friendly, and have been updated with neat features, like HTML e-mail and integration with Microsoft Outlook. Both can import your TeleMagic data seamlessly. Both have links to the MAS-90 and MAS-200 accounting lines, and both are excellent tools to manage your relationships and gain results. Depending on the level of customization to your TeleMagic software, one of those packages may be a better fit for your current and future needs.

Please contact Mike Mahoney (MikeM@dsdinc.com or 619-683-9900) for an analysis of your current TeleMagic software and in making the best recommendation about which CRM product is right for you.

To find out more general information on ACT or SalesLogix, please contact Stephanie Smith (StephanieS@dsdinc.com or 619-683-9900).

 

ACT 6.03 released!

ACT has release version 6.03 for users of version 6. Besides fixing numerous faults, there is support for Eudora E-mail program, and new features like the the ability to schedule a calendar entry automatically from sending an e-mail.

 

Think Your Company is too Small for SalesLogix? Think Again!

Think that your company is too small for for a CRM package like SalesLogix? Nonsense! SalesLogix includes an entry-level 5 user product that is small on price, but very richly featured. This product includes an amazing Microsoft Outlook integration, one-button export to Excel spreadsheets, mail-merged HTML e-mail, and virtually unlimited room for your company, contact, and sales forecasting records. You can even customize this version to match how you do business.

Now, even the small firms can take advantage of a full-featured CRM application that can grow as they grow. For just under $3000 ( maintenance and support included, tax not included) for your first 5 users, and only $595 for each additional user, you can take advantage of a product that you won't outgrow. It's the same product that big firms with 100's of users use!

Please contact Nicole Stone (NicoleS@dsdinc.com or 619-683-9900) or Stephanie Smith (StephanieS@dsdinc.com or 619-683-9900) for more information or to see SalesLogix in action.

 

Fighting Duplicates in ACT!

by Douglas Wolf

The easiest way to not have duplicate records is to execute a Lookup prior to entering what you think is a new contact. However, in our rush to get moving to the next deal, we usually start a new contact and never really worry about duplicates.

On a single user database, this is not a big deal. When you next lookup the contact, the record counter will read 1 of 2. So, you can see if there is a duplicate and delete on of the records. However, in a shared database, duplicates can be a problem. Even though the person looking up the contact may be wise enough to check the record counter to see if more than one record appears, 1 of 3 for instance, they cannot easily presume that any of the records are in fact unnecessary duplicates. So, you can enable ACT! to check for duplicate records as they are being entered. The key decision to be made is what fields do you want ACT! to check. The default setting is for ACT! to check 3 fields: Company, Contact and Phone Number including the extension. To see the settings and to make adjustments, follow these steps:

1. Open the Edit menu and select Define Fields.

2. Click the Advanced tab at the top of the dialog box.

At the right, ACT! lists the fields is checks for duplicates (up to 3) and then there is a checkbox to turn off or on duplicate checking.

 

TeleMagic Windows Tip
Error 39 Numeric Overflow (Data was Lost)

by Mike Mahoney

If you have ever received this error, the first thing to do is not panic! The error sounds worse that it really is.

The error occurs frequently while importing records into TeleMagic. It usually means that you number field is too small to hold the value that is being imported to it. For instance, the dollar amount being imported is $10,000 but you numeric field is only 4 digits wide, meaning you could only store an amount up to $9999. Increasing the size of the numeric field usually does the trick. Be sure to run a rebuild after changing the size of any field.

This error can also occur as you are editing and saving records. In that case, it is usually a calculated field that again is too small to hold the calculated value. Increase the size of your numeric field, run a rebuild, and it should fix the problem. Another instance where this problem occurs is when you have a calculated date field. If you subtract a large number of days from a date field, there is a potential for this error to occur. In those cases, it's better to not do subtraction on dates. (Addition works great.)

 

SalesLogix Tip

by Mike Mahoney

You can drag and drop an e-mail you have received from Outlook into the Notes / History tab. SalesLogix will then add a history record for that e-mail. It's a neat feature, and the staff here at DSD Business Systems uses it all the time.

If you have an attachment included in the e-mail, a prompt will come up asking you if you would like to store the e-mail attachment in the attachment tab in SalesLogix. This is also a nifty feature, because sometime you do want to preserve it, and sometime you may not want to.

Once the e-mail is in the history tab in SalesLogix, you can safely delete the e-mail from Outlook. You'll have the reference to it where it really belongs - in your CRM system's History section!

 

Database Management

Access Program Rescue

Do you have an Access program that needs work?

DSD regularly creates and repairs Microsoft Access programs/databases. We have extensive experience in the design/creation/implementation of Access systems as well as the maintenance/repair/modification of existing systems.

We have a lot of success in combining Access with SQL back ends as well as using the native Access database engine.

For more information, contact Andrew Ault at 619-683-9900 or AndyA@dsdinc.com

 


This monthly newsletter is sent to DSD Business Systems customers and partners. If you do not wish to receive this publication, please reply with the Subject "Remove" and we'll exclude you from receiving it.

 


All prices and offers are subject to change without notice. Copyright 2004 , DSD Business Systems, San Diego, CA. All rights reserved.