Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions
Great Plains Dynamics GP has long history of custom programming, business logic adaptation, integrating scenarios, EDI, reporting. When you are implementing ERP for mid-size modern business, you often mean to cross the borders of pure accounting system and integrate it with MRP, warehouse management, order tracking (UPS, FedEx), barcode, POS and retail, shipping and receiving, supply chain management, etc. You can expect existing add-ons or satellite modules on the GP modifications market, developed and supported by GP ISV partners – and first option is to evaluate these existing extensions. The second option and especially if your modification seems to be simple enough, you can develop it just for your own business. Let’s review the second option, when you do your in-house customization:
1. SQL stored procedures. This is when you review GP table structure and transaction workflow and have your SQL programmers to create stored procedures to feed external data into GP tables. We recommend you to review GP Integration Management module, prior to deciding on SQL scripting, as IM validates GP business logic and you can not violate data integrity if integrating via Integration Manager. If you do not own IM module and would like to try simple integration through SQL scripts or insert statements, make test company, insert data there and try to run check links to see if your data import is accurate
2. Dex. Great Plains Dexterity tool modifies GP user interface, plus it can add custom tables to your companies and Dynamics databases. We would say, that Dexterity is preferred tool, however it is not very easy to get Dexterity developer in staff and Dex is not rapid application development tool. Dex is a way to go if you know or can find Dexterity programming partner or consultant to do the modification design and coding job
3. eConnect. This is very popular SDK, especially for eCommerce programmers and developers, as it allows them to include GP objects and transaction creation scripts and call these logics from their eCommerce applications
4. Posting GP batches from e-commerce application, or extending eConnect logic. eConnect out of the box doesn’t do batch posting job and so you can not post batches automatically as web order is placed and paid. You will need batch posting tools, we recommend you Alba Spectrum Posting Server or Autopost
- Related Articles
- Related Q&A
- Microsoft Dynamics Gp Implementation Faq
- Workflow in Microsoft Dynamics Gp 10.0
- Microsoft Dynamics Gp 10.0 – Improved and Enhanced
- Improve Cash Management Capabilities With Microsoft Dynamics Gp 10.0
- Microsoft Dynamics Gp – Typical Customizations
- Great Plains Integration Tools: Microsoft Dynamics Gp Integration Manager
- Microsoft Dynamics Gp 10.0 Customization Scenarios
- Microsoft Dynamics Gp 10.0 Technical Notes or Under the Hood
Main Approaches of PowerPoint to Video Solution
By: Adward | 04/01/2010Main approaches of PowerPoint to video solution: use PowerPoint to video conversion software or use screen capture tool. Enjoy the benefits of PowerPoint to video solution
How to convert youtube video to MP4 for iPod
By: Jessy Brown | 04/01/2010Is it possible to get YouTube videos on iPod? Well, it seems interesting, if the two are kind of connection, yet YouTube videos are all Flash videos played by a Flash Player, and iPod supports the videos in MP4!
Remember Isaac Newton, watch FLV videos on your iPod/iTouch
By: alex nikle | 04/01/2010Today is Isaac Newton's 367th birthday. Let's watch videos of Isaac Newton's legendary life on iPod/iTouch easy and fast.
Examsoon Cisco 640-802 certification
By: aminalee | 04/01/2010Examsoon known to be the best for providing the exam questions for the Cisco 640-802 certification and training . Our 640-802 expert’s team has designed and prepared the training kit for Cisco 640-802 certification.
Dell Support Creating Landmark In customer Satisfaction
By: Jas Devid | 04/01/2010Dell is a customer centric organization, offering quality services for the diverse segment of users. In order to keep its customer satisfaction graph on the peek, Dell has collaborated with reputed outsourcing organizations. These support firms are working on 24/7 basis to meet the expectation of the users.
How to watch DVD movies and videos on PS3?
By: Herb368 | 04/01/2010With a larger 250GB of hard disk drive storage for more games, movies, music, videos and photos, Sony’s new PlayStation 3 is an ideal solution for ditital entertainment. This article will share you an easy to play DVD movies and videos on PS3.
How do Labels organize you with countless things?
By: Janett Parker | 04/01/2010Labels are those tags that contain the name or any specific information on the object. They are the stickers either used for identification purpose or for promotional reason. Proper use of labels enables you to organize yourself at home, school, college or office. A person can design stickers attractively for identification purposes.
Advantages of Using a Sales Dashboard For Analysis of Retail Business
By: Sudhi Ranjan Das | 04/01/2010This year holiday season revealed how insufficient use of technology can lead to a sales and production cost mismatch. So it is very important to determine sales figures and volumes to calculate production, marketing and all kinds of overhead in comparison to sales & revenue.
Exporting Data from Dynamics GP Notes for Consultant
By: Andrew Karasev | 03/01/2010 | Information TechnologyThere might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. In this small publication we will describe you two scenarios. First, when you need one tame data export for following data conversion into future Corporate ERP accounting system (when you are walking away from Dynamics GP to something like SAP Business One, Oracle eBusiness Suite, etc.), and second - when you need ongoing data export
SAP Business One Full Service in Chicago and Atlanta Consulting Notes
By: Andrew Karasev | 02/01/2010 | SoftwareThis small and mid-size business Corporate ERP and MRP application is relatively new on US accounting software market, however it is so flexible and robust (plus it has SAP brand, which is important in the sense of reliability and future commitment), that it provides tough competition to such traditional lower mid-market Corporate ERP applications as Microsoft Dynamics GP (formerly known as Great Plains Dynamics), Microsoft Small Business Financials (this small business corporate ERP...
Great Plains US Payroll Tax Update Service Notes
By: Andrew Karasev | 31/12/2009 | SoftwareFor customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Payroll tables. We traditionally offer this service at the end of the calendar year, or in January at your convenience.
Microsoft Dynamics GP Applying Service Packs Technology
By: Andrew Karasev | 30/12/2009 | SoftwareIf your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.
Migration to SAP Business One from Great Plains Accounting Notes
By: Andrew Karasev | 30/12/2009 | SoftwareThere are still customers, who are on Great Plains Accounting for DOS, Windows or Macintosh, typically versions 9.5, 9.2, and earlier. When Great Plains Software encouraged its GPA customers to convert to Great Plains Dynamics at the end of 20th Century (as there was a concern of GPA not being year 2000 compliant, plus support for GP Accounting was about to expire those old good days), large number of GPA customers followed the advise and migrated.
Microsoft Dynamics GP 7.5, 9.0 version update notes
By: Andrew Karasev | 27/12/2009 | SoftwareAs recession seems to be over, now it is time to take care about your Corporate ERP application, and if it is Microsoft Dynamics GP (also known as Microsoft Great Plains and Great Plains Dynamics), this small publication might be helpful on introduction level
Ecommerce to Dynamics GP Real Time Integration: Order Connector
By: Andrew Karasev | 25/12/2009 | SoftwareIf your back office Corporate ERP application is Microsoft Dynamics GP, former versions were also known as Microsoft Great Plains and Great Plains Dynamics, and you have in-house developed ecommerce web application with items catalogs with advanced price lists (especially in B2B ecommerce scenarios), shopping cart, credit card processing, we would like to present you this small publication in the form of FAQ and orientation session.
Microsoft Dynamics GP Deployment and User Training Notes
By: Andrew Karasev | 24/12/2009 | SoftwareIf your organization plans to deploy Microsoft Dynamics GP, formerly also known as Great Plains Dynamics, eEnterprise and its predecessor Great Plains Accounting for DOS, Windows and Mac, we would like to offer you this small introduction level publication.