Posts

Showing posts with the label Plains

Microsoft Great Plains Reporting - Overview for Developer

Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology – Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. There are several reporting tools available and you definitely need to know which one to use for different types of reports. If you are developer who is asked: how do we create report for Microsoft Great Plains – read this and you will have the clues on where to look further. Great Plains Report Writer (ReportWriter) – this is built-in reporting tool. All the original report in Great Plains are written in ReportWriter. ReportWriter itself is Dexterity module. You should use this tool if you would like ...

Microsoft Great Plains Technical Support : Typical Questions and Answers

Technical support offered by MBS depends on the region. For North America (NA), support is available to both partners and customers who availed of the support plan. In Asia Pacific (AP), Europe, Middle East, and Africa (EMEA) though, support is only available to partners. Unfortunately, not every customer in North America can avail of support from their vendor. Some who opted not to renew their annual enhancement plans are orphaned from their vendors and do not receive free upgrades. If they need immediate support, they can contact the MBS Support Team directly but they are charged a higher premium. In this case, it is best to get support from partners such as Alba Spectrum Technologies or the like instead of directly from MBS. Below are some questions and answers that the MBS Support Team (Asia and EMEA) receive: Q1. Will Microsoft Great Plains run on operating systems other than Microsoft Windows? A1. Microsoft Great Plains was first developed to support both Microsoft and Mac operat...

Great Plains - Crystal Reports Design Overview

Microsoft Dynamics GP, or former ERP name is Great Plains Software Dynamics / eEnterprise gives you, programmer or software developer vide spectrum of report design tools : Crystal Reports, Microsoft SQL Server Reporting Services, GP ReportWriter, MS Access, MS Excel to name some of the popular. In this small technical paper we would like to introduce you into Crystal Reports design for Dynamics GP, assuming that you are new to GP and need some starting help. We also assume here, that you are on MS SQL Server Database: GP 10.0, 9.0 and 8.0, if you are on GP 7.5 and earlier: 7.0, 6.0, 5.5, 5.0 or 4.0 where Great Plains was available on Ctree or Pervasive SQL/Btrieve, please review database connection options, described in our earlier articles – you will need to install Ctree/Faircom or Pervasive ODBC drivers. Let’s come back to Crystal for GP on MS SQL Server: 1. Tables specifications. You can install Dynamics GP SDK from CD #2, however for quick and reasonably detail referen...

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house o Data querying. Microsoft Great Plains has decent ReportWriter, which allows users to create and modify existing reports, however the recommended tool, and you will soon understand that if you need really challenging reports (Sales Commissions, Bill of Lading, Sales Order Status with Purchasing info, Regional Sales, etc.) – you need to deploy Crystal Reports or Crystal Enterprise. Crystal Report itself is usually based on the view or stored procedure. So – you should expect to be fa...

Microsoft Dynamics GP: Great Plains Recycling Business Automation

Microsoft Business Solutions Great Plains could be considered as generic ERP platform to be tailored to fit specific industry and market niche. Being mature MRP system and so having a lot of third party modules, Great Plains could fit the unique industry requirements combining these third parties and custom coding. New version: Microsoft Dynamics Great Plains 9.0 will have more options for C#/VB.Net developer, including more exposure to .Net XML web services and Visual Studio. However the GP workstation client code is Microsoft Dexterity written application and we will be focusing on Great Plains Dexterity customization. o Industry Specifics. Recycling containers are rented to customers and based on the balance customers might become vendors – we send customer or vendor invoice and receive or send payments. Clients typically pay for container rent and at the same time – we pay to the client for the recycled materials collected o Service Module. We can use GP Service Ad...