So, these custom stored procedures are available on the market, but they are not packaged as eConnect and could be purchased on the individual agreement base with Microsoft Great Plains partner. Microsoft Business Solutions Great Plains was designed back in the earlier 1990th as first graphical ERP/accounting system for mid-size businesses. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. Net code behind approach and Great Plains eCommerce should be rewritten. Tool->Resource Desciption->Tables, re-sort by Table Group technical name, then make test transactions in Great Plains (SOP module) and see where records go.
In the case of non-SQL system, such as old Great Plains Dynamics, ACCPAC on Pervasive SQL - IDE interface will involve ADO/ODBC or Microsoft Access programming. ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6. We would like to give you - programmer, software developer, database administrator the primary clues on producing EDI formatted text from Microsoft Great Plains database. Please, note however that Great Plains here is taken as the example, similar approach will work for other SQL based systems. Navision (SQL Database or C/SIDE database), Microsoft RMS, Solomon as well as Oracle and other non-Microsoft products.
All these tasks are performed by Microsoft Great Plains Utilities. You don't have support for your old Great Plains - then you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade. You are doing migration from Great Plains Accounting to Microsoft Great Plains. Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation.
Great Plains Dexterity - this is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Microsoft Great Plains itself has variety of customization and integration tools. Microsoft Business Solutions Small Business Manager is Great Plains Dexterity based application and successor and small business market niche version of Microsoft Great Plains. You can install Dexterity from Great Plains 7. Nowadays, however - and this is a good thing - most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.
In this article we'll talk about Microsoft Great Plains.
Great Plains Dexterity Customizations - Microsoft announced that its products will be moved to. We are talking about customization upgrade for Great Plains Dynamics/eEnterprise 5. However Microsoft did not announce which product (Great Plains, Solomon or Navision) will become the base or will be transformed into each specific suite. However, even now Microsoft Great Plains 8.
In the case of Great Plains or Great Plains Dynamics/eEnterprise - customer can do self-support. As each product has its life time - it is almost over for Great Plains Accounting - Great Plains Software was purchased by Microsoft and incorporated into its business systems subdivision. We (and Microsoft Business Solutions itself) strongly recommend you to migrate from Great Plains Accounting to Microsoft Great Plains standard 8. Great Plains Accounting, accounting package for mid-size and small companies was in its peak of popularity back in earlier 1990th. Great Plains Accounting is btrieve based application and typical installation has GPDATA (with all the database files in) and GPCODE (with executable code - this code is copied over the network and is executed on each workstation.
Beginning Balances - this is recommended approach - you place aside the old accounting application for querying the historical data and enter beginning balances in Great Plains GL, AR, AP, SOP, POP, Payroll.
Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. Net, Crystal Reports and Microsoft CRM SDK developer. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Washington, Minnesota, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www. Invoice form, Crystal Reports, pulling info from multiple databases, including Great Plains database, Great Plains forms modification with Modifier/VBA, Great Plains Dexterity forms and logic customization, integration with CRM, RMS and other business systems, web publishing from Great Plains tables, EDI with your suppliers, SQL Data Transformation packages
Do I need consultant? We strongly recommend you to use consultant in the following cases.
If you remember successful mid-size application - Great Plains Dynamics, pioneered on Mac and Windows graphical platforms in the mid 1990th. You should consider Microsoft Great Plains if you are in. This is now Microsoft Great Plains, Great Plains Standard and Microsoft Small Business Manager (scaled down Great Plains version, using he same technology - Great Plains Dexterity. Net, MS SQL Server, Active Directory, BizTalk (integration with Great Plains), C# and VB. USA, Canada, Latin America, UK, South Africa, Australia - these are markets, where former Great Plains Software had successful penetration.
Great Plains Dynamics was designed for US tax code with US Social security, later on it was adjusted to comply VAT (Value Added Tax) rules to promote it in UK and other countries. Currently MBS officially promotes Navision on the Brazilian market, however localized version of Microsoft Great Plains is available as well. Great Plains Software marketing campaign was getting very strong resistance from local market commitment to Microsiga and other local ERP application. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. Don't worry, MBS does support it in Brazil via local partner.
Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal.
Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics. If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity - you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE. Net, Crystal Reports and Microsoft CRM SDK developer. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history. If your Great Plains is integrated with Unix, Oracle, DB 2, Lotus Domino, Siebel or other third party application - you need to consider synchronous upgrade for integrated applications to avoid retuning integration piece twice. In earlier 1990th - the customization tool was mostly Great Plains Dexterity, later on when Great Plains was successfully moved to MS SQL Server 6. This was probably wise and natural choice in that time (around 1997-2001), but if you consider Microsoft move to. Unfortunately business logic level may deploy third party vendors logic, and these flourishing ISV of late 1990th might be now out of business.
Microsoft Business Solutions Great Plains has several options to enable web ordering. Traditionally Great Plains Dynamics/eEnterprise had eOrder - this is ASP pages based ordering application, enabling you to place or retrieve your Sales Order Processing (SOP) Sales Orders over the web. However you should probably first understand the architecture of Microsoft Great Plains. It would take you a lot of time (if you are new to Great Plains tables structure and never coded in Great Plains Dexterity. Plus eConnect allows you to create and update customer record in Great Plains - this is however relatively simple to imitate in the stored procedure.
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise was introduced in 1993 as first Microsoft Windows and Macintosh based graphical accounting/ERP application for Mid-Size businesses. If you are replacing your legacy system, then you could build eCommerce upon Microsoft Great Plains Inventory Control (IV) and Sales Order Processing modules. Great Plains would be reasonably priced payroll solution if you process payroll inhouse. If you have less then 500 employees - then Great Plains Standard douse excellent job and software price would be around k$10. Use Great Plains Integration Manager or heterogeneous SQL queries.
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized. Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features. Inventory control has addition in the form of Bill of Materials module (we see the whole spectrum of downsizing manufacturing companies, who are switching from full-featured manufacturing to Great Plains Inventory control with Bill of Materials. There is a good chance that you will have to develop custom web-interface to your Great Plains back end. Net, Crystal Reports and Microsoft CRM SDK developer.
Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market.
Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. EXE) and Great Plains Standard on MSDE or MS SQL Server. Net, Crystal Reports and Microsoft CRM SDK developer.
SQL Linked Servers - you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL.
|
|