Clients First USA
Clients First knows their software, but they are also astute business people, and they really understand manufacturing and distribution in particular.
Jimmy Witcher, COO, Merrick
Read More
About UsService OfferingsProduct OfferingsIndustries ServedDownloadsBlogTestimonials
 

Subscribe to our mailing list

* indicates required
    Interested in    
Hot Topics
 

Posts Tagged ‘Sage MAS 200’

Technology Can’t Solve all Business Problems

Friday, June 21st, 2013

By Mark Chinsky

It is a common problem that seems to course through every consulting business. A consultant works on the client’s problem but implementing a new technology solution, only to discover that technology was only part of the original problem, and that it is personnel issues that are really at fault. When we rely too much on technology, it opens the doors for a whole slew of problems. Here is a closer look at some of the problems surrounding technology.

  1. It can’t make employees more efficient. Yes, the right technology can help make the work easier, but if an employee is truly falling behind or is just inefficient, all the technology in the world will not remedy the situation. The truth is that such employees are often inefficient due to either inexperience or laziness. The unwillingness to use new technology only heightens an already present problem. Adding new, faster technology will not fix the problem.
  2. It can’t improve communication. In some work places, there may be departments that do not communicate well with other departments. Using technology to find new ways to force these departments to communicate may fix the problem for a short period of time, but it is merely a bandage. While a new piece of technology may make it easier for these departments to communicate when it is necessary, it does not address the underlying problem. A better solution is sitting the departments down together and talking about the problem so that there can be a real solution.
  3. It won’t make up for a shortage of resources. Technology can make your workers more efficient, by supplying the necessary means to work better. However, if cannot make up for a limited number of staff. While the right technology can make the job of your current employees easier, if there simply aren’t enough people to handle the work load, technology won’t be able to fix everything.
  4. It can’t force employees to change. Technology is good for helping with change, not forcing it. Many business owners think that implementing new technology will result in big and better things. The truth is that if the wheels aren’t already in motion for a change, technology isn’t going to make change happen.

Technology is a good tool for improving businesses; however, there is only so much it can do. The success of using technology is to understand that it isn’t the whole solution. Rather, it is a merely part of a whole. The business and its employees must also be willing to work with that technology to achieve the desired goal.

Sage MAS 90, MAS 200, MAS 500 Supported Versions List

Wednesday, March 18th, 2009

Thanks to Wayne Shulz at 90minds.com for this posting of which versions of the Sage MAS90, MAS200 and MAS500 products are currently supported by Sage.

Below is a form showing version 3.71 and higher (including the almost forgotten MAS200 SQL Version) and what levels or versions are still supported.  Note that Sage can discontinue support for any of these versions within 12 months notice.  To be sure, check with us before assuming this list is perfect although we try and keep it current.
Supported Versions Policy MAS90 MAS200 MAS500

Copying Sage MAS90 & MAS200 master company data

Saturday, March 7th, 2009

Copy Masterfiles From Another Company (SVTRNA)

The Copy Masterfiles From Another Company program (SVTRNA) lets you quickly and easily copy Accounts Payable, Accounts Receivable, or Inventory Management masterfile information from one company to another. If you are creating a new company or division that is closely related to an existing company or division, copying masterfile information eliminates the repetitious and time consuming task of entering individual data records.

SVTRNA will not overwrite the key of an existing record; it will append data to the end of the file. For example, if your source company contains vendor #1 and vendor #2, but your destination company only contains vendor #2, the SVTRNA program will only copy the basic information for vendor #1. It will not overwrite the existing record for vendor #2.

If records are copied from the existing company or division that do not apply to the new company or division, you must delete the unwanted records individually. This can be done through the applicable file maintenance screens, such as Vendor Maintenance, Item Maintenance, and so on. These screens can also be used to correct any minor discrepancies that may exist between the records of the two companies or divisions.

SVTRNA can be used to copy information from the following applications.

Accounts Payable

Accounts Receivable

Inventory Management

AP1 – Vendor Masterfile

AR1 – Customer Masterfile

IM1 – Inventory Masterfile

APC – Division Masterfile

ARB – Division Masterfile

IM2 – Warehouse Detail File

APE – Terms Code Masterfile

ARC – Sales Tax Code Masterfile

IM4 – Alternate Item File

APP – Vendor Memo Maintenance File

ARD – Salesperson Masterfile

IMA – Product Line File

AR_17 – Vendor Contact File

ARF – Terms Code Masterfile

IMB – Price Code File

ARG – Sales Code Masterfile

IMC – Warehouse Code File

ARP – Customer Memo File

IMJ – Unit of Measure Conversion File

AR_12 – Customer Contact File

IMP – Item Memo File

AR_13 – Payment Type Code File

IM_03 – Extended Description File

AR_15 – Customer Tax Exempt File

IM_04 – Alias Item Number File

IM_12 – Item Vendor File

NOTE:

SVTRNA automatically eliminates all numeric data, such as period-to-date and year-to-date totals, invoice numbers and amounts, check numbers and amounts, etc. However, any numeric information that is part of the constant data for an item, customer, or vendor will be maintained.

To Run SVTRNA

1 Select Run from the File menu on the MAS 90 Launcher.

2 Type SVTRNA in the Program Name field and click OK.

3 Enter the company code for the source company. The data from your source company will be copied to the company displayed in the Copy to Company field.

clip_image002

NOTE:

You must currently be logged on to the company code you wish to use as your destination company. If you are not in the desired destination company, click Cancel on the Copy Master Files from Another Company screen, then click the Change Companies button on the Launcher to log into the desired destination company.

clip_image003

For this example, we have created a company called Sample Destination Company and have logged into the SDC company code. We will copy the Accounts Payable information from the ABC Distribution and Services Company, company code ABC. Once you have entered the correct information, click Proceed.

1 The next screen will vary depending on which modules you selected to copy. Select or clear as many files as necessary to fit your needs. To copy the entire module, all files must be selected. When all your selections are correct, click Copy to begin the copying process.

2 Once the copying process has finished, you will have the option of printing a recap report showing which files were copied and the number of records copied within each file. Click Preview to display the report on your screen. Click Print to send the report to the printer displayed in the lower left corner of the window.

clip_image004

If there were any records in the source company that already existed in the destination company, the report will list the duplicated records along with a description of “DUPLICATE KEY – ALREADY EXISTS IN FILE”.

The figure below shows an example of how the report would look if it were printed to your screen by clicking Preview. If you would still like to print the report from the Preview window, click the Printer icon at the bottom right corner of the window.

clip_image006

To Copy Masterfile Information for a Division

SVTRNA can also be used to copy masterfile information from one division or department to another within the same company for General Ledger, Accounts Payable, and Accounts Receivable.

1 Select Run from the File menu located on the MAS 90 Launcher.

2 Type SVTRNA in the Program Name field and click OK.

3 Enter the company code for the company you have chosen as your source company. The data from your source company will be copied to the company displayed in the Copy to Company field.

NOTE:

You must currently be logged on to the company code you wish to use as your destination company. If you are not in the desired destination company, click Cancel on the Copy Master Files from Another Company screen, then click the Change Companies button on the Launcher to log into the desired destination company.

1 Enter or select the module for which records will be copied. For this example, we have logged on to the SDC company code and will copy the division/department information for General Ledger. Once you have entered the correct information, click Proceed.

2 The next screen will vary depending on which module you selected to copy. If you are copying A/P or A/R, the Options area lets you specify the source division and the destination division. If copying G/L, select the account segment (2=department, 3=location) followed by the source and destination department or location.

clip_image007

For this example, we will copy all account numbers based on department, then copy from Department 10 to Department 20. Once you have made your selections, click Copy.

clip_image008

6. When the copying process has finished, you will have the option of printing a recap report showing the total number of records that were copied. Click Preview to display the report on your screen. Click Print to send the report to the printer displayed in the lower left corner of the window.

clip_image009

If there were any records in the source division or department that already existed in the destination division or department, the report will list the duplicated records along with a description of “DUPLICATE KEY – ALREADY EXISTS IN FILE”.

clip_image011

via Clients First

Converting an old Sage FAS 50 or 100 installation to MAS 90 or MAS200 FAS

Thursday, March 5th, 2009

Listed below are the step for converting from FAS 50 to MAS FAS.  To go from FAS 100 to MAS FAS, the steps are the same; you will just back up on FAS 100 and run the restore in MAS FAS and restore to a database you create with that program. It works the same, you just have to Launch MAS FAS from within MAS (like usual) and follow the commands from there.

Subject: How to Migrate – Single User to Single User

In FAS Asset Accounting:

  1. In the original FAS Asset Accounting program, backup the database (Do this once for each database).
    1. Go to: File | Company Utilities | Backup Company.
    2. Choose a database from the pull down menu.
    3. Choose Select All.
    4. Select location to save the backup file.
    5. Specify a name for the backup file in the file name field (Suggest to use the name of the database).
    6. Click Backup.  Copy the backup file(s) to the new machine.
  2. Install the FAS Asset Accounting program on the new computer.
  3. Create a new database (Do this once for each backup file). In FAS Asset Accounting:
    1. Go to: File | Database List Manager.
    2. Select New Database.
    3. Choose location where keep the databases (This location must be on a local hard drive.
    4. Enter the Physical Database Name (Suggest to use the same name as the original database).
    5. Enter a Logical Database Name (when this field is selected, the physical database name is automatically copied into this field.)
    6. Select OK.
  4. Restore the backup(s). (Do this once for each backup file):
    1. Go to: File | Company Utilities | Restore Company.
    2. Choose a backup file (*.BBK file) to restore | Press Next.
    3. Select one of the newly created databases to restore the company or companies into | Click Next.
    4. Select desired purge option.
      NOTE: Purging the history has the advantage of speeding up data access performance.  While this is the suggested method, be aware that purging the history will remove depreciation event entries under the History tab of assets.
    5. Press Restore.

Jobops for Sage MAS 90 and 200 version 4.3

Wednesday, February 18th, 2009

via Wayne Shulz

The latest version of the popular job management software package Job Ops has just been released in version 4.3 format. This new update is compatible with the latest Sage MAS 90 and 200 accounting software which was released in June 2008.

Sage MAS 90 and MAS 200 contains a Job Costing module which is adequate for many small job tracking situations. However if your company wants to get more in depth with job tracking, then you should consider JobOps.

One of the key features which has proven atrractive is JobOps ability to begin the job process with a quote. Starting in Sales Order, work tickets are fashioned from their original quote status. This is a step that standard Sage MAS 90 and 200 doesn’t provide and one of the key reasons that over 600 Sage MAS 90 and 200 users have turned to Job Ops for increased Job Management flexibility.

job ops estimatingWe also have clients that migrate to JobOps due to the configurator module which enables the creation of a product from a much more complex matrix of possible options and materials.  Once this product has been created, it can be fully integrated into the job management function of the software.

Some of the key features of JobOps for Sage MAS 90 and MAS 200:

Estimating
  • Re-use past quotes to create new ones
  • Combine bills of material, routings, labor and services to create a detailed cost roll-up
  • Automatic update of material costs
  • Product configurator assists with selecting options and calculating final price
Sales Orders & Work Ticketsjob ops work tickets and sales orders
  • Fast conversion from quote to sales order
  • Generate work tickets automatically
  • Check availability of material prior to release
  • Product documentation and procedures can be attached to job ticket
  • Automatically create item price via product configurator
Job Planningjob ops job planning
  • Verification of quote accuracy and pricing
  • Material availability
  • Purchasing shortages
  • Production scheduling
  • Track estimates (current versus revised)
Field Service & Dispatch
  • Service ticket creation
  • Scheduling dispatch board
  • Customer contracts, equipment history, warranty tracking
  • Preventive maintenance orders
  • Integration to Microsoft Outlook
  • Dashboard
Product Configurator
  • Quickly configure custom product estimates
  • Generate a bill of materials and routing
    job ops product configurator
  • Graphical rules based wizard eases data entry
  • Update pricing automatically based upon configuration
  • Smart part numbers to uniquely identify a newly configured part
  • Web enabled for remote configuration entry

For more information on Job Ops for Sage MAS 90 and MAS 200 please download this full color PDF brochure that contains additional details. We will happily provide you with the names of consultants we know in your area who can assist with implementing Job Ops for Sage MAS 90 and 200.