|
Linux PHP Sales Management System integration with Microsoft Great Plains overview Alba Spectrum
Microsoft Dynamics GP is Microsoft Windows and MS SQL Server application, it is heavily integrated with Microsoft Sharepoint and MS Office stack of products. If your Sales Processing system is based in Linux Redhat and is MySQL & PHP application, then you should know the answers on the connection technology to Microsoft Great Plains. In this small article we assume that you have PHP and MySQL developers in IT staff and all you need to do is to get some help in building the bridge to GP accounting backoffice
1. GP Sales Order Processing Module. If you originate your Sales Orders in PHP frontend, then all you need to do is transfer shipped sales lines to GP SOP invoice, where you will be aging your AR and potentially deploying such modules as Business Portal based Electronic Document Delivery for emailing invoices to your customers
2. GP Purchase Order Processing Module. Here you typically integrate your vendor invoices, assuming that your business rules require vendor to drop-ship items directly to your customers. This scenario is often considered as typical for eCommerce platforms
3. PHP lookup to Great Plains. There are multiple options available, the most reliable and platform independent call could be realized through XML web service. Other way to consider would be HTTP request/response technology, however it is rather legacy or old-fashioned.
4. Integration Tool. With Microsoft Dynamics GP 10.0, you can deploy GP Integration Manager SOP and POP eConnect connector, which should give you reasonable throughput, comparing to traditional IM connectors, where GP workstation was used as OLE server. However you should also consider eConnect direct C# or VB.Net programming to create SOP and POP invoices in real time from your PHP application you should consider the best technological scenario on how to call .Net application with parameters from PHP
5. Emailing scenarios: Great Plains Electronic Document Delivery module is part of GP Business Portal and it does excellent job in scheduling SOP invoices deliveries. However if you plan to purchase and implement GP Business Ready Standard, BP is not available. Here you have to consider Microsoft Dexterity customization, which should allow you to build custom screen where you select invoices for emailing and it should also deploy SMTP client to send out invoices. Invoices should preferably be printed in PDF in custom GP ReportWriter SOP Blank Invoice forms
6. Cross Platform Reporting. MS SQL Server should be considered as the center for reporting, it allows you to create Linked Server connectors. ODBC is way to make a link back to MySQL
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com - help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale.
Company: Alba Spectrum Group
|
| Related press releases |
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Linux PHP Sales Management System integration with Microsoft Great Plains overvi... [2007-11-13 08:06:05]
Microsoft Dynamics GP is Microsoft Windows and MS SQL Server application, it is heavily integrated with Microsoft Sharepoint and MS Office stack of products. If your Sales Processing system is based ...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
eConnect eCommerce Posting Server for Dynamics GP Alba Spectrum [2007-09-22 02:52:59]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce .Net c#, VB or SQL developer, you need to know eConnect Microsoft Dynami...
|
|
Great Plains Dynamics GP: Programming, Integration, Customization Alba Spectru... [2007-12-21 09:47:23]
Microsoft Great Plains ERP is wide spread in USA and Canada, as well as in English speaking countries. As we see XXI century progressing, more technical skills are becoming the norm and so to say req...
|
|
Microsoft Dynamics GP Great Plains and MS CRM tandem as corporate ERP Alba Spe... [2007-09-08 06:16:58]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics ERP products family includes both Great Plains and Microsoft CRM, so it is i...
|
|
Microsoft Great Plains implementation in Chicago area Alba Spectrum increases ... [2007-10-27 06:16:04]
Alba Spectrum Group specializes in Microsoft Dynamics GP sales, programming, implementation, reporting, data conversion, massage and migration. Great Plains fits as corporate ERP for mid-size and lar...
|
|
|
|
| RationalPlan Multi Project |
 RationalPlan Multi Project is a powerful project management software capable of handling multiple interrelated projects and covering project management areas starting with WBS construction, project planning and scheduling to progress tracking etc. |
|
| 123 Flash Chat Software |
 123 Flash Chat Server Software can add a chat room to your website in minutes. It is a live chat solution for networking. It has multiple skins & mutiple chat client, such as iPhone Chat, Avatar Chat, offering seamless integration to your database. |
|
| Screen Paver |
 Screen Paver is an easy to use make-your-own slide show screen saver. The program will display an unlimited number of your own jpeg, png, or bitmap images from local and/or network directories. Plays music too. Great for digital camera users. |
|
| SSH Explorer SSH Client |
 SSH Explorer is a new generation SSH client and terminal emulator with a Windows Explorer-like look and functionality, that makes remote Linux server administration look like much more fun than it actually is. |
|
| WinTools.net Professional |
 A suite of tools for increasing MS Windows operating system performance. WinTools.net Pro contains tools: Clean Uninstaller, Scan Files, Scan Registry, Start Up, Tweak UI, Net Tweaker, The Privacy, File Shredder, Invisible Man. Site: www.wintools.net |
|
| Filedoyen |
 Filedoyen is a single or dual-pane file and archive (zip) manager with integrated text, code and hex editors, file and folder compare and search. By combining these separate tools into one, Filedoyen makes file management both convenient and easy. |
|
| EF System Monitor |
 EF System Monitor is a Windows program that shows you comprehensive information about your local or remote (over TCP/IP) system resources and performances. Multilingual. Shareware |
|
|
Latest press releases
