On the server, where you have your Great Plains files structure - DYNAMICS is the root, in SYSTEM folder delete ACTIVITY. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. You have a lot or ReportWriter Modified Great Plains Reports. Then Great Plains will prompt the user to recover posting batch.
General tip - Great Plains recommends to logoff and then login back with the same user id.
Great Plains Standard is available on MSDE (MS SQL 2005 Express) or MS SQL Server. If you need Service Advantage Suite, Customer/Vendor Consolidation, Lockbox Processing and other modules, targeted for midsize and corporate clientele - you should purchase Great Plains Professional. Current Microsoft Business Solutions Great Plains has more that 10 years of history. Then, migration tool is $2k and your MBS VAR can migrate you to Great Plains Professional or Great Plains Standard. We strongly recommend you to migrate to Great Plains Standard.
Old-days Great Plains Dynamics on Ctree or Pervasive SQL/Btrieve was excellent and inexpensive solution. Now - you have sudden hurricane - over Florida - somebody who is in charge in Microsoft - but really without clear understanding on what is in stake - this person needs to retune the cheap Great Plains version. Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, and Miami and having locations in multiple states and internationally (www. Of course the need to finish the contract with Pervasive software was a good idea - but cutting your small loyal customers - we actually doubt this.
Here we need to give you highlights on Great Plains Dynamics initial design. Due to the MBS strategy - Great Plains Dynamics was pulled from other markets, such as continental Europe (Germany, France, Russia) - where Navision and Axapta are the promoted and recommended solutions. Later on eConnect was extended on the majority of Great Plains modules, including distributions. MS SQL Server, Ctree and Btrieve (later on Pervasive SQL 2000), in 1998 Great Plains Software made it available for MS SQL server only. In our small article we'll consider Microsoft Business Solutions Great Plains Sales Order Processing module as eCommerce backend.
Former product name was Great Plains Dynamics / eEnterprise. These are modified via Great Plains Reporting tool. Users has nothing to do with MS SQL Logins, however if you are on SQL version - users are translated to SQL as logins and given access to all Great Plains related database. Setup->System->Security select user id, company, product (Great Plains), type as Modified Reports, series Sales and you will see SOP Invoice Long form available in the list, mark it and you will have it available for this user. DIC dictionary (original Great Plains) into custom dictionary, created by Dexterity developer.
If we look back to 1990th - we'll see that GPS had Multilanguage support and Great Plains Dynamics / Dynamics C/S+ was localized and translated into multiple languages, including Spanish. Andrew is a Great Plains specialist in Alba Spectrum Technologies ( http. The other way is to have server in Mexico and have relatively inexpensive Microsoft Great Plains data be consolidated with Oracle, SAP, PeopleSoft based system in the USA. Great Plains has pretty comprehensive VAT support. Microsoft Business Solutions Great Plains was purchased from Great Plains Software and Great Plains Software itself had strong international marketing plans and campaigns.
Workstation side - workstation is written in Great Plains Dexterity and has Dynamics. If you have Great Plains Dynamics/eEnterprise (version 6. You have a lot or ReportWriter Modified Great Plains Reports. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data.
Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application - Great Plains Dynamics/Dynamics C/S+/eEnterprise. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. And this is where Great Plains structure seems to be not transparent. If you are trying to relay on eConnect exclusively and not researching Great Plains Architecture - you will need additions to eConnect from third party vendor, such as Alba Spectrum Technologies, which has the whole set of SOP populating stored procedures. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger.
If you are on Great Plains Standard version. Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool. The result of such a shrewd future-looking architecture - Great Plains ReportWriter has multiple restrictions and drawbacks. Custom reports could be used to export data from Great Plains in text (and then Excel format. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http.
So as you see - logic is present and structured, but it is not friendly to the developer, who never seen and worked with Great Plains Dynamics. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure. But these legacy Great Plains Dexterity names do not help eCommerce developer - only probably as the reference on which table works with specific screen. Great plains was designed to first serve mid-size businesses and then with the availability of third party modules - the intention was to compete on corporate ERP market with Oracle, PeopleSoft, SAP and others big players. This tool covers a lot of Great Plains objects creation and retrieving functionality, however it does have restrictions, because it was not intended as replacement to Great Plains Dexterity shell.
Small Business Manager has similar to Great Plains structure and similar System DYNAMICS database and the company. Microsoft Business Solutions Small Business Manager is scaled down Great Plains Dexterity based version of Microsoft Great Plains or former Great Plains Dynamics/eEnterprise. Andrew is Great Plains specialist in Alba Spectrum Technologies (http. As you could see tables structure in Resource description in Great Plains - so you do in SBM. Again - being scaled down version of Microsoft Great Plains - Small Business Manager has a legacy of relatively complex tables structure.
It was total success for GPS, we guess, but for Great Plains Dynamics / eEnterprise / Dynamics C/S+ clients it was the time of change. Pervasive SQL 2000 and Ctree (we are not talking here about Great Plains Accounting - this ERP was phased out in 2001. But it is seen now - not in 1990th
These two above principles resulted in creation of Great Plains Software development environment and language - Great Plains Dexterity. Andrew is a Great Plains specialist in Alba Spectrum Technologies ( http. All of us know that Microsoft bought former Great Plains Software and formed Microsoft (Great Plains) Business Solutions in the earlier 21st century.
Workstation side - workstation is written in Great Plains Dexterity and has Dynamics. You just need to know that your third-party is ready for the new Great Plains version - if not - you just wait and stay on the old version. You have a lot or ReportWriter Modified Great Plains Reports. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data.
Workstation side - workstation is written in Great Plains Dexterity and has Dynamics. You just need to know that your third-party is ready for the new Great Plains version - if not - you just wait and stay on the old version. You have a lot or ReportWriter Modified Great Plains Reports. Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data.
This should be realized as Great Plains Dexterity custom window, with two scrolling windows on it, where you should list SOP Invoices and POP Shipments with Invoices. In this small article we'll give you highlight on how Great Plains could serve specific vertical demands of transportation and freight forwarding industry
Industry requirements. Microsoft Business Solutions Great Plains version 8. Microsoft Great Plains sits on MS SQL Server platform and typical technologies are. Use the same Great Plains Dexterity custom window technology.
|