Released on: November 13, 2007, 6:38 pm

Press Release Author: Alba Spectrum Group

Industry: Computers

Press Release Summary: 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

Press Release Body: 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.


Web Site: http://www.albaspectrum.com

Contact Details: 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