|
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...
|
|
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 ...
|
|
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 ...
|
|
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...
|
|
|
|
| uCertify MCSE (70-270) practice test |
 Pass MCSE exam 70-270 in first attempt. 455 questions with detailed explanation and 138 study notes. 70-270 - Windows XP Professional study notes, articles and mock test. 99% pass rate, 100% money back guarantee. Based on latest Microsoft certificat |
|
| QIOS Pelican |
 Use QIOS Pelican to send personalized, bulk or mass e-mail to contacts in data sources, such as Microsoft SQL Server, Exchange, Access, Outlook, Excel, Oracle or MySQL. Define fields in your message and apply the datasource to create the e-mail. |
|
| LinkStash |
 LinkStash is an searchable bookmarks/favorites manager for IE, FireFox & Opera which includes fully automated password management. 5 minutes with LinkStash and we are betting you will never want to use standard favorites or bookmarks again! |
|
| 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. |
|
| PPC Accelerator |
 Unique PPC Management Software Tool. Source, Edit, Format and Manage your Keyword Lists in One Place Fast And Easy. Saving time which can be utilized to build more targeted keyword lists for more campaigns. Also includes quick Adwords formatting. |
|
| egrID3 COM Add-In for Microsoft Excel |
 egrID3 COM Add-In for Microsoft Excel adds functionality to fast mp3 ID3 v1.x, v2.3, v2.4 tag reading and altering, playlists generation, FreeDB querying, file names handling and full Unicode support on all operations. Handle compressed v2.x frames. |
|
| Space Hound 4 |
 Sniff out wasted space with The Best Duplicate File Finder available. Space Hound 4 eliminates duplicate and unused files that are cluttering up your hard drive and causing problems. Uncludes File & Directory Management, Zip & Unzip, file Viewers. |
|
|
Latest press releases
