Misplaced Pages

Revision as of 20:57, 26 January 2007

Microsoft Dynamics GP is a mid-market business accounting software package that runs on top of a SQL database server. It is a part of the Microsoft Dynamics family.

The product was originally made by Great Plains Software, an independent company located in Fargo, North Dakota that produced this software in the 1990s. In late 2000, Microsoft announced the purchase of Great Plains Software. This acquisition was completed in April 2001.

Macros

Great Plains was one of the first accounting packages with capability to record and play back macros. Macros are saved in .MAC files in the Dexterity programming language. It is possible to export data from Excel or Access to Great Plains modules by programming a Visual Basic macro to create a MAC file using data from the spreadsheet or database. The MAC file would contain commands to enter specific data into Great Plains; for each set of data, a new MAC file would need to be created.

Modules

Microsoft® Dynamics GP (formerly Great Plains) functionality and is based on a number of modules or "series". The Series windows are the stock modules that come embedded in the Dynamics GP software. Modules are usually the third party windows that are available for Great Plains such as Field Service, Extender, VB Modifier, etc. Many users within the Microsoft® Dynamics GP community refer to third party windows as modules, and the embedded windows are referred to as series. However, there is very little difference between the two. The advantage of using these modules is that they interact with each other to provide more efficient data entry for users, and allow for fewer data entry errors. With the integration of the modules and series, users are also able to switch back and forth quickly between module windows, streamlining the business processes performed by Microsoft® Dynamics GP, and provide accurate and detailed reporting.

Analytics

(Crystal Reports® XI) is a widely used tool in building and designing reports with Microsoft Dynamics GP®. Microsoft® Enterprise Reporting: a system for automating data collection (from multiple sources) and reporting processes to control consolidations, budgeting and financial analysis.

Microsoft® Forecaster: extracts real-time data from General Ledger to create and manage accurate budgets and plans which can be shared across the management team via a Web-based interface. Easy to learn: has the look and feel of a spreadsheet.

Microsoft® FRx Professional: applies a “building block” approach (row formats, column layouts and trees) to create with ease financial and management reports for instant use and rapid distribution. Reports can be based on any periods from the General Ledger and for unlimited budgets. Reports can be output to paper, drill-down viewer, e-mail, Excel, pdf or XML. Easy to create customized reports with appropriate access privileges.

Microsoft® SQL Server Reporting Services: offers eight sample reports for Sales, Purchasing and Manufacturing analyzes which can be customized. Data can be manipulated and presented in Web-based charts and graphs for sharing across the organization or with designated suppliers or contractors. An integrated architecture supports a range of common data sources.

SmartList Builder: easy to use, yet powerful query tool to output data (no matter where records reside) based on virtually any specified criteria into a user-friendly format for screen view, for print or for saving in Excel or Word (auto-formatted). Combine and link data from up to 32 separate tables, including third-party dictionaries. Many common data-analysis functions are available in pre-configured SmartList objects that can be downloaded from Microsoft.

Customization tools

Customization: comprehensive customization tools to enable .NET developers to create real-time, transactional connections between Microsoft Dynamics GP and other applications and expand potential for new features and functionality.

Integration: integrate and incorporate data with a high degree of safety, flexibility and speed from any source, even those not based on Microsoft platforms. Uses industry-standard technologies, such as Microsoft BizTalk® Server, Component Object Model (COM), the Microsoft .NET Framework, Microsoft Message Queuing (MSMQ), Web services and XML.

Supply chain management

Advanced Distribution: the essential tool to streamline your distribution cycle, gain rapid access to accurate information (view inventory levels for specific items at a glance and get a snap-shot view of the supply chain cycle via Distribution SmartLists), reduce input errors and automate information-sharing through a configurable workflow, allowing you to define up to 6 stages in the order-to-invoice cycle.

Advanced Picking: offers the capability to issue consolidated (bulk) picking lists across numerous orders for common items; it can meet multi-site needs and adapts to your warehouse layout by tailoring picking routines. This module requires Advanced Distribution to run.

Available to Promise: maintain up-to-date information concerning stock availability, current and future, so that accurate commitments are made to customers.

Demand Planner: combines planning and forecasting functionality with an intuitive, easy-to-learn user interface to anticipate future demand and gain deep, multi-dimensional visibility into customer buying patterns. Excel Collaboration Plug-in allows for forecast information to be shared and for synchronization of demand management across organization.

Inventory Management: provides access to detailed inventory information from a central location, has easy to use stock analysis tools and flexible reporting capabilities, improves picking efficiency with multi-bin tracking and enables the creation of personalized pricing schemes to meet customer demands. Blends well with other GP modules, such as Sales Order Processing, Invoicing and General Ledger to streamline inventory and sales processes.

Order Management (for Business Portal): around-the-clock, security-enhanced access via an out-of-the-box, business-to-business portal which allows salespeople and customers to view, place and edit orders online, saving time and increasing accuracy of orders.

Purchase Order Processing: enter purchase transactions earlier in the cycle to better manage costs and improve efficiency. Complete purchasing audit control with comprehensive selection of reports to track and analyze purchase activity (full historical and performance reporting). Option to print or e-mail purchase order documents. Other features include Auto-Receive, Auto-Invoice, VAT tracking, facility to handle price and quantity variances, approvals option, commitment reporting. Integrates smoothly with Payables Management, General Ledger, Sales Order Processing and Inventory.

Requisition Management (for Business Portal): enter and approve requisitions online and automatically transfer orders to new or existing purchase orders in Dynamics GP Purchase Order Processing. Reduces paperwork, repetitive data entry and errors. Approval processes can be fully customized. Channel information to the right people through roles-based access.

Sales Order Processing: manages the whole sales process from A-Z: quote to order to invoice, and with pinpoint accuracy. Enter quotes, orders, back orders, invoices and returns from one central location without data re-entry to increase office productivity. Invoices are auto-generated. Customer Priority Ranking feature to quickly identify top customers, and distinguish prospects from customers. Customizable data entry, sales documents and sales process to accommodate your organization’s unique business needs. Has seamless integration with Inventory, Receivables Management and eCommerce modules.

Foundation

Analysis Cubes: for Microsoft Office Excel is a core component of the GP financial system which leverages the power of SQL Server and helps you define and extract key data and present in an easy to analyze mode to enable accurate, strategic decision-making. Features the Excel Pivot Table Generator to allow you to “slice and dice” information, business portal KPIs and a tool to share and increase transparency of financial information via the Business Portal to improve Sarbanes-Oxley compliance.

Business Portal: A web-based information dissemination system that enables fast and informed decision-making. Access is defined by user roles. Professional users can have full remote access data entry capability. A security-enhanced extranet deployment even provides trusted customers and suppliers with access to selected data with the ability to customize their own pages.

Electronic Document Delivery (for Business Portal): enables scheduled e-mail delivery, according to defined rules, of electronic documents, such as Invoices, Credit Notes, Debit Notes, Finance Charges and Returns in a format of your customer’s choice: XML, HTML, Microsoft Office Excel or PDF. A valuable tool for lowering administration overheads and increasing customer responsiveness.

Key Performance Indicators (for Business Portal): roles-based to define and deliver personalized views of key business information via Web based portal. KPIs include profitability, debt-to-equity, gross margin and many more.

Process Server: integrated with Dynamics™ GP to reduce the burden on client computers by moving heavy background tasks to process servers to eliminate costly slow-downs and delays.

Report Writer: effective tool to build reports from scratch or to use one of the hundreds of templates available in the system and customize for specific individuals or groups or to achieve consistency in presentation across the entire organization. Flexible scheduling options available to publish reports at any time: immediately, on a recurring basis or selectively in a variety of file formats including HTML and PDF. Reports can be shared across the organization by posting them online for viewing via a Web browser with role-based security options.

System Manager: a tool to customize Dynamics GP to set up processes and role-based home pages or dashboards specific to your business and employee needs. Create queries against your data or access more than 100 modifiable SmartList queries and export these with a single click to Excel or Word. Streamline process set-up to provide audit information and maintain user accountability.

Extensible Web Services: uses Microsoft technologies, such as SQL Server, Visual Studio and .Net, as well as industry standards, such as Web Services and XML, to increase real-time data sharing and integrate business processes throughout the organization. The Web Services layer works with the Business Services layer to provide security, policy validations, defaulting, and exception management for consumers of the Web service. These two tiers interact with Business Logic and Persistence layer within eConnect to provide scalable and reliable integration solutions.

Security Management: manages user security quickly and effectively to protect your Dynamics GP system. Different security types can be assigned to fields through Dynamics GP using a single Explorer-style interface and security errors can be identified and fixed quickly using the interactive dialogs to help eliminate the need to change login user and minimize IT administration.

Financial management

Analytical Accounting: enables transactions to be tagged and reported by limitless user-defined dimension codes – financial, date or statistical.

Bank Reconciliation: customizable summary and detailed views of bank account balances and all transactions: cash, check and credit card. Tools available to sort and mark transactions to improve reconciliation capabilities.

Cash Flow Management: calendar-based interface to view and manage cash inflows and outflows to improve day-to-day financial planning. Big picture and full drill-down options available.

Collections Management: customizable interface enabling you to enter and view all your collections in one central point. You can target and follow up on overdue customers with automatic delivery and tracking of collection letters, e-mails, statements and invoices.

eBanking: an essential aid to reduce administration costs and manual input error as well as improve productivity and cash management – all in a security-enhanced environment. Routine accounting tasks are moved online and bank transactions are electronically enabled and reconciled. Transactions are applied to accounts when they occur rather than days or weeks later, such as BACS payments or payment collections via Direct Debits or credit cards. Special feature verifies that sort codes and bank account numbers entered for suppliers and customers make sense.

eExpense Automated Expense Management: enable employees to create and submit expense reports via the Web at any time and from any location; features electronic receipt imaging.

Encumbrance Management: encumbrance accounting module specifically designed for Not for Profit and Public Sector organizations to ensure that actual expenditures and related commitments do not exceed available funds.

Fixed Asset Management: create, define and manage an unlimited number of assets. Features standard fields and up to 15 user-defined fields with graphical user interface. Numerous depreciation methods available to automate depreciation routines. Integration into General Ledger to post depreciation journals and into Payables Management to pull in purchase information to fixed assets. Location IDs to aid inventory management: matching actual with recorded location. Information-sharing enabled with standard and custom reports.

General Ledger: automates key accounting tasks to improve accuracy (includes automatic correction of posting errors) and streamlines your budget planning and financial decision-making with comprehensive reports and easy-to-use enquiry tools (features Excel wizard interface). Features up to 66 alphanumeric character codes, up to 10 segments and user-defined fields with 50 character descriptions.

Grant Management: tracks grants, demonstrates accountability and compliance and also assists with future funding applications. As grant transactions are entered, the Analytical Accounting module will automatically validate them against the budget. Affords real-time views of budget status and of grant transactions and allocations. Particularly useful in the public and Not for Profit domains.

Multi-currency Management: designed for multinational operations to effortlessly manage financial statistics and accounting operations involving multiple currencies and dealing with ever-changing exchange rates.

Payables Management: control expenditure, control payments (check and BACS runs) with flexible selection criteria and track supplier documents and information. Features include unlimited addresses/contacts per supplier, discounts, min/max payments, holds, returns, debit/credit notes, auto-allocation, performance and history reports.

Receivables Management: tracks customer-related documents and information, controls cash, generates simple invoices as well as creates, prints and e-mails statements. Produces sophisticated debtor related reports at any point in time and performance reports including turnover, gross profit and payment days. Other features are flexible credit limits, unlimited address/contacts per customer, min/max payments and ability to handle insufficient funds, interest charges, debit/credit notes, returns, write-offs and auto-allocation.

Field service

Field Service Management: nine powerful elements within a single user interface to manage engineer service calls, preventive maintenance, contract administration. Data can be entered remotely. PDA and CRM integration. Web-based tools allow customers to resolve service issues themselves. Applies standard and customized reports.

Human resource management

Human Resources: a module to build comprehensive records of employees to include attendance tracking, run “what if” scenarios with salary adjustment projections, access to numerous standard and customizable templates to streamline the recruitment process, standardize the process for performance reviews, facilitate information-sharing with seamless integration to GP payroll and general ledger applications.

HRM Self Service Suite: personalized, secure portals to review expenses, pay and benefits, personal profiles, attendance records, recruitment, promotion and training opportunities, enter holiday requests as well as share selected data across the organization. Reduces administration costs and eliminates need for paper.

Manufacturing

Job Costing: captures and consolidates in one location all job costings as they occur to give manufacturers a comprehensive view of production profitability.

Materials Requirements Planning (MRP): for greater accuracy and control in matching material flows and production to current projected demand. MRP is a key resource planning instrument to help reduce stock outages, drive down inventory costs and streamline the production process. Views can be in time format and with full drill-downs to source any MRP quantity.

Manufacturing Bill of Materials: ensure materials are where they should be, when they are needed. Gain tighter control of costs, locations and routings of materials, components and assemblies to maximize production efficiency and lower inventory costs. Features intuitive, graphical “tree views” of Bill of Materials for entry and inquiry.

Engineering Change Movement: provides the means to collect, organize, validate and authorize process and component changes before they are released to the shop floor to ensure that they are strategically sound before they become orders.

Manufacturing Order Processing: tracks detailed production costs; manages work orders, routings, material requirements planning (MRP), work center definitions, work in progress (WIP), outsourced operations and production costings. Facility to “mass change” the status of multiple manufacturing orders at one time.

Quality Assurance: a tool to design and refine processes to test the quality of incoming raw materials to meet your manufacturing process. Flexible reporting to provide suppliers and customers with customized information on quality assurance testing and processes both quickly and accurately.

Sales Forecasting: allows you to create forecasts for a range of items or salespeople and to combine these forecasts into a master forecast. Integrates with Materials Requirements Planning module so that material requirements plans reflect existing sales forecasts and current sales orders. Create statistical forecasting and interactive simulation scenarios with integration into Demand Planner module.

Project accounting

Project Accounting: connects project activities with company financials and timelines so that projects get completed on time and within budget. Tracks unlimited contracts and projects. Has web-based time and expense entry, fixed or variable pricing, comprehensive revenue recognition methods, profitability and WIP reporting, budgets and forecasts, flexible categories.

Project Time & Expense (for Business Portal): facility to capture, review and approve project time and expense data/reports via the Web for prompt, accurate customer invoicing and efficient reimbursement for out-of-pocket employee expenses. Helps reduce paperwork and increases operational efficiency.

Editions

Microsoft Dynamics GP 9.0, the current version, is available in two editions:

• Standard: Up to 10 simultaneous users, and 500 payroll employees for each defined company.
• Professional: Unlimited users, additional user-level security options, consolidation tools, automatic purchase order generation, and more reporting/analysis options. In addition, Professional Edition includes additional manufacturing and field service modules.

Versions

Microsoft Dynamics GP 9.0 was released in November 2005. Prior versions were named Microsoft Great Plains 7.5 and Microsoft Great Plains 8.0. Both were compatible with Microsoft SQL Server.

Microsoft recently announced a change to their licensing of Dynamics GP called Business Ready Licensing (BRL). This new licensing format applied only to new customers and is based on a per-user cost instead of the previous cost per module licensing program. A fixed price offering has also been launched.

Criticism

• Microsoft Dynamics GP does not integrate with Microsoft Active Directory, which precludes single sign-on in deployments where Active Directory could otherwise be used to authenticate Dynamics GP users, and necessitating maintenance of separate user accounts specifically for Dynamics GP.

External links

• Microsoft Dynamics GP Official Website

Notes

2. Melissa Amundson (2006-11-03). "Active Directory". Newsgroup: microsoft.public.greatplains. vlsEblK4FHA.2904@TK2MSFTNGXA01.phx.gbl. Retrieved 2006-12-27. {{cite newsgroup}}: Check date values in: |date= (help)

• Microsoft Dynamics
• Accounting software