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.
New Realease Sage 200 2009 |
This release includes a number of exciting new features: Introducing Sage Payment Solutions- provides secure online payment handling facilities, allowing the user to record credit card payments against transactions. Improving Project Accounting including: - multi- currency expenses, new WTE reports, one sided adjustments to projects and posting negative timesheets. Improved Integration between Sage 200 and Sage 200 CRM. Information Management- making information within the Suite more available to users in their day to day roles. Introduction of personalized Workspaces for Sage 200 users and a Workspace Designer, allowing you to customize users work screens or amend the ten standard 'out of the box' workspaces included as part of the Sage 200 2009 launch. |
Sage 200 V5.10 Business Intelligence (BI) |
This is a new feature to Sage 200 V5.10. Sage 200 BI is designed to provide powerful analysis and reporting which will transform data into meaningful intelligence. Benefits - It can be used and understood by al users- you don’t need any technical knowledge or pre-requisites to use the tool
- Familiar user interface and process maps that Sage 200 customers are familiar with
- It is a superior alternative to complex spreadsheet reporting. Reports are easy to create and automatically refreshed when the data is updated.
- With predefined reports it allows customers to analyse and understand other Sage 200 information, e.g: Profit and Loss report, overdue settlements, and average sales month-on-month
The Software gives our customers with more sophisticated needs full flexibility to create reports that can be configured and designed for their own specific requirements. They can slice and dice data, drill up, down, across and back to underlying transactions, as required. The flexible layout options allow users to produce formal reports. The layout of the forms and reports works in the same way as Microsoft Excel. Customers can also build professional dashboard reports with multiple linked queries and charts. For more information see the Sage 200 BI Brochure. |
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 Financials 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 | | Description | Explanation | | Adoption of Microsoft SQL Server | The 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 .NET | MMS 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 Feature | You 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 Interface | The desktop & interface has been re-engineered to provide a more flexible, intuitive user experience. |
| Business Intelligence | | Description | Explanation | | New Business Intelligence (BI) Module | This 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 | | Description | Explanation | | Open Period Accounting | The 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 Log | A full history of all revaluations is available allowing accurate loss/gain calculations and full reconciliation via the revaluation/allocation drill-down | | Nominal Coding Structure | Users 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 Analysis | Users 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 Codes | Sales & 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 | | Description | Explanation | | Sales Order Documentation Improvements | Additional information can be printed on sales orders, e.g. comments. | | Purchase Order Direct Delivery | Sage 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 Ordering | Users 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 Report | A 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 Reports | Summary reports can be produced or detailed reports by stock item or customer. | | Stock Valuation Report | Negative stock balances can be treated as zero value or as a negative value. | | Further Excel Integration | More 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 + | | Memory | 256 MB RAM | | Hard disk | 250 MB | | Display | 800 x 600 SVGA |
| | Recommended | | Processor | 2 GHz + | | Memory | 512 MB RAM | | Hard disk | 250 MB | | Display | 1024 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 | | Memory | 2 GB RAM | | Hard disk | 80 GB |
| | 11 to 20 Users | | Processor | 2 .8 GHz Xeon | | Memory | 4 GB RAM | | Hard disk | 80 GB - RAID-5 |
| | 21 to 50 Users | | Processor | Twin 3.2 GHz Xeon | | Memory | 8 GB RAM | | Hard disk | 4 to 5 hard disk platter utilising RAID 10 |
|
|