Search

   

Subscribe

   

Sage 200 Suite

Microsoft SQL Server for the backend database. What this should mean is a dramatic increase in data integrity, speed and a more scalable system. In addition the whole system will employ Microsoft's powerful .NET framework, allowing future exploitation of web services. Reporting and analysis will also see significant improvements, culminating in a completely new module: Business Intelligence. The most significant change to MMS Financials will be support for open period accounting.

Sage 200 - New Features Overview

Architecture & Platform

  • Adoption of Microsoft SQL Server Database Technology

  • Financials re-written using Microsoft .NET Framework

  • Switch Company Feature

  • Sage Line 50 data compatibility

  • Updated Desktop & User Interface

Business Intelligence Module

  • NEW Business Intelligence Module allowing multi-dimensional data analysis

Financials

  • Open Period Accounting

  • Improved Currency Handling

  • Revaluation Log

  • Nominal Coding Structure

  • Transactional Analysis

  • Improved Analysis Codes

Commercials

  • Sales Order Documentation Improvements - more information available

  • Purchase Order Direct Delivery

  • Elective Back-to-Back Ordering

  • Simple Stock History Report - as in Sage Line 100

  • Stock Profit Reports - summarised or by stock item/customer

  • Stock Valuation Report

  • Further Excel Integration - more information available

Details of New Features

Architecture & Platform
DescriptionExplanation
Adoption of Microsoft SQL ServerThe use of Microsoft's SQL Server 2000's industry standard relational database technology will deliver many benefits; better data integrity, more concurrent users, faster data access & less data redundancy.
Financials re-written using Microsoft  .NETMMS Commercials has already uses this technology. The use of Microsoft .NET technology throughout MMS means greater consistency between MMS Financials and MMS Commercials. Adoption of .NET technology will also future-proof Sage MMS and facilitate future exploitation of web services.
Change Company FeatureYou will no longer have to exit MMS to switch companies.
Line 50 data compatibility When upgrading from Sage Line 50 to MMS data will no longer be truncated. All data will be retained.
Desktop & User InterfaceThe desktop & interface has been re-engineered to provide a more flexible, intuitive user experience.
Business Intelligence
DescriptionExplanation
New Business Intelligence (BI) ModuleThis new module will allow you to analyze vast amounts of data held in accounts and other business management systems. BI reports are far quicker to produce than conventional reports and can offer in-depth multi-dimensional analysis. This powerful analysis will allow you to quickly assess the efficiency of operations, identify weak areas and potential opportunities for future growth.
Financial Modules
DescriptionExplanation
Open Period AccountingThe ability to have more than one financial period open at a time. Periods can be configured to be closed, fully open or anywhere in between.
  • Each user can be granted or denied the ability to open/close accounting periods for each ledger
  • All accounting periods and ledgers can be viewed in one place and are supported by an audit detailing who has made changes to accounting periods and when
  • Sales & Purchase Ledgers can have an unlimited number of trading periods. Sales/Purchase figures can be analyzed daily, weekly, monthly, quarterly, etc.
  • Closed periods can be re-opened if corrections are required
  • This years and next years accounting periods to be setup  in advance
Improved Currency Handling
  • Exchange rates can be set for a period, spot rates or a combination of the two. This can be set system-wide or against each customer/supplier
  • Sales/purchase ledger - The original base value and exchange rates are stored against each transaction. This allows a full comparison between the original and current value of a foreign currency transaction
  • Nominal ledger - The currency value and currency type are stored against each transaction, allowing reports to be generated in their original currency
Revaluation LogA full history of all revaluations is available allowing accurate loss/gain calculations and full reconciliation via the revaluation/allocation drill-down
Nominal Coding StructureUsers will have the option to create nominal posting codes on-the-fly. When a nominal account is created users will be able to associate departments and cost centres with the account. The system will then create the necessary posting accounts for the combination of cost centres/departments.
Transactional AnalysisUsers can create a list of transactional analysis codes which can be selected at transaction entry, e.g. Job code. Reporting can be carried out against these codes or the existing nominal structure.
Improved Analysis CodesSales & purchase ledgers now support unlimited analysis codes. Analysis codes can be configured to use a drop-down box of possible values and applied to either of the ledgers.
Commercial Modules
DescriptionExplanation
Sales Order Documentation ImprovementsAdditional information can be printed on sales orders, e.g. comments.
Purchase Order Direct DeliverySage MMS will now support direct delivery of stock items to customers. An inward/outward stock movement is automatically created when the goods are received.
Elective Back-to-Back OrderingUsers can decide whether or not to partially fulfil a sales order with current stock and raise a purchase order for the remainder.
Simple Stock History ReportA simple stock history report, similar to the one found in Line 100, will be available. The option to view in/out stock movements will also be available.
Stock Profit ReportsSummary reports can be produced or detailed reports by stock item or customer.
Stock Valuation ReportNegative stock balances can be treated as zero value or as a negative value.
Further Excel IntegrationMore information is now available through Excel.

Client  System Requirements

Operating Systems

Supported Platforms
  • Windows XP Professional (Service Pack 2)
  • Windows 2000 (Service Pack 4)
Unsupported Platforms
  • Windows XP Home Edition
  • Windows 98 / 98 SE
  • Windows 95

Hardware Requirements

Minimum
Processor 1 GHz +
Memory256 MB RAM
Hard disk250 MB
Display800 x 600 SVGA
Recommended
Processor 2 GHz +
Memory512 MB RAM
Hard disk250 MB
Display1024 x 768 SVGA

Server System Requirements

The recommendations below are based around running SQL server and Sage 200; the specification should therefore be increased if the server is running other software. Large datasets or a high volume of transactions will also require an increased specification.

 

Operating Systems

Supported Platforms
  • Windows 2000 (Service Pack 4)
  • Windows 2000 Small Business Server (Service Pack 1)
  • Windows Server 2003 (Service Pack 1)
Unsupported Platforms
  • Windows NT4
  • Novell Netware

Hardware Requirements

Up to 10 Users
Processor 2.8 GHz
Memory2 GB RAM
Hard disk80 GB
11 to 20 Users
Processor 2 .8 GHz Xeon
Memory4 GB RAM
Hard disk80 GB - RAID-5
21 to 50 Users
Processor Twin 3.2 GHz Xeon
Memory8 GB RAM
Hard disk4 to 5 hard disk platter utilising RAID 10

Please contact us to discuss your software requirements:

BHP IT Events

View all upcoming BHP IT events.

 

Documents and Articles

Download BHP IT documents and articles.


Sage Dealer Sheffield, Sage200 Sheffield, Sage Developer Sheffield, Sage 2007 Sheffield, Sage West Yorkshire, Sage south Yorkshire,
Sage Support Sheffield, Sage Training Sheffield, Sage Manufacturing Sheffield, Sage CRM Sheffield