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.
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
- Related Videos
- Related Articles
- Ask / Related Q&A
Embarcados Para Linux
Por: luis bilar | 09/01/2009 | Tec. de InformaçãoSistemas embacados para plataformas linux, demostra as necessidades que serão avaliadas para criação de embarcados para linux,tais como, dispositivos eletronicos , engenharia mecanica e engenharia eletro/eletronica.
Hospedagem Php. Curiosidades E Dicas De Hospedagem
Por: Luiz Henrique | 13/11/2009 | HospedagemA Hospedagem de Sites é um serviço que possibilita as empresas e pessoas físicas com sistemas online armazenar informações, vídeos, imagens, ou quaisquer conteúdos acessíveis por Web. Saiba mais como funciona esse serviço, e um comparativo entre hospedaegm no Brasil e fora do país.
Gerenciamento De Recursos Tecnológicos Em Software Livre
Por: Roberto Mizuuti | 25/05/2009 | Tec. de InformaçãoEste artigo busca esclarecer, mesmo que brevemente, a importância do gerenciamento dos recursos tecnológicos disponíveis a uma determinada entidade, focalizando a utilização de software livres e de código-fonte aberto (SL/CA), de forma a fornecer sistemas de monitoramento e gerenciamento de utilização de tais recursos de maneira centralizada e com TCOs (Total Cost of Ownership – Custo Total de Propriedade) menores que os encontrados com a utilização de softwares proprietários.
Hackers Vilões Ou Anjos
Por: Gracivaldo | 19/06/2009 | InformáticaNeste artigo apresentamos qual a visão sobre hackers obtida pelos gerentes de TI dentro das Universidades e Faculdades de Feira de Santana,assim como veremos uma breve introdução sobre o que são hackers e seus sub tipos para melhor compreensão do assunto.
Software Livre_Passado, Presente Futuro
Por: Alexandre Silveira | 18/04/2008 | InformáticaEste artigo conta um pouco da história do software livre, resumindo desde sua criação até as suas expectativas para o futuro.
Um Pouco De Siw
Por: Ruben Zevallos Jr. | 08/03/2008 | ProgramaçãoMuitas pessoas já me perguntaram o que é SIW. SIW é a sigla de Sistemas com Interface Web. O SIW é o desenvolvimento de Sistemas normais utilizando a Interface Web, que tem diversas vantagens perante a interface gráfica normal
Gestão De Conteúdo De Websites
Por: Sandra Regina da Luz Inácio | 15/08/2008 | Web DesignO potencial dos websites de hoje está diretamente relacionado ao conteúdo dos mesmos. Com o dinamismo cada vez maior dos mercados, produtos e serviços passa a ser fundamental aos sites estarem em sintonia com estas mudanças.
Agit Informática Patrocina Seminário De C & C++ Para Sistemas Embarcados
Por: Basilio Miranda | 09/11/2009 | ProgramaçãoConvidamos e contamos com a presença de todos vocês neste Seminário que é de suma importância para área de TI. Iremos abordar temas e trocar conhecimentos sobre o desenvolvimento de firmware e software para sistemas embarcados.
Advantage of Using Spa and Salon Management Software for Your Biz
By: William Hauselberg | 09/12/2009If you are having trouble tracking appointments, feel like you are losing money in billing, or just in general think that you do not have a good grasp on the day to day operations of your business than perhaps you need to get help. While some spa managers may turn to an assistant for help, there is a cheaper and better way to get organized.
How to download Esnips music
By: Cathy1314 | 09/12/2009This tip will help you download Esnips music. With our recommend Esnips music downloader and get start to download music from Esnips now.
How to Fix Corrupt Registry Files
By: Jason Webber | 09/12/2009Corrupt registry files are the main cause of problems plaguing Windows computers. It's essential to know how to fix them in order to have a smooth user experience when using the computer.
How to Fix Registry Errors Safely and Easily
By: Jason Webber | 09/12/2009In the past, the only way to fix registry errors for most users is to format the entire computer and reinstall Windows. Unless you're a technical guru who can navigate his way through the potentially huge registry, for most of us, that was the only way. But not anymore.
How to Fix Computer Freezes Easily
By: Jason Webber | 09/12/2009Compared to the cost of all the data loss caused each year by computer freezes, you may be surprised how easy it is and how little it costs to fix computer freezes. It's something that anyone can do.
How to Fix the Iexplore Application Error
By: Jason Webber | 09/12/2009The iexplorer application error seemingly appears at random, and has caused much annoyances, especially when one has many tabs open and haven't finished reading everything yet. You can fix this error easily even if you are not a technical person.
How to Fix a Fatal Exception Error
By: Jason Webber | 09/12/2009A Fatal Exception Error is one of the most commonly seen errors in Windows. Once you've seen one on your computer, there is a high chance that it will appear again, because it indicates that something is wrong on your system and unless you fix it, the problem will just keep appearing again and again.
How to Transfer/convert JVC Camcorder TOD Files to DVD
By: nancy111 | 09/12/2009Complete guide for how to transfer and convert JVC camcorder videos to DVD and play them on your DVD player with this step-by-step guide.
SAP Business One 8.8 for Multinational Company: Russia, Brazil, China Notes
By: Andrew Karasev | 06/12/2009 | SoftwareWith anticipated release of SAP B1 version 8.8 traditional separation into A and B lines will be merged. As you may know, that such languages and localizations as Russian, English, German for SB1 2007 and 2005 were in A and other languages, for example Brazilian Portuguese, Chinese were in B (SB1 2007B or SB1 2005B).
Microsoft Dynamics GP Development: Dexterity, eConnect, Extender
By: Andrew Karasev | 04/12/2009 | SoftwareIf you have Microsoft Dynamics GP (earlier versions known as Great Plains Dynamics, eEnterprise, Great Plains Accounting for DOS, Windows and Mac) as your Corporate ERP, and you plan to undertake customization project, please read this small publication to get information session on Dynamics GP modification tools.
Microsoft Dynamics GP ECommerce Partner in Chicago
By: Andrew Karasev | 03/12/2009 | Softwaree-Commerce web site integration is real challenge, especially when your Corporate ERP is Microsoft Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select, Great Plains Accounting for DOS, Windows and Macintosh), and your ecommerce web application is PHP/MySQL/Linux or Unix/Oracle based.
Microsoft Dynamics GP Invoice Emailing Add-On Notes
By: Andrew Karasev | 02/12/2009 | SoftwareIf you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics or eEnterprise, implemented in your organization as Corporate ERP, we would like to offer you this small publication, where we are describing our small add-on, allowing you to email Sales Order Processing invoices to your customers via SQL Mail (SQL 2005 or 2000) or MS SQL Server 2008 Database Mail.
Microsoft Dynamics GP Support: What is Possible and What is not possible in Remote Support
By: Andrew Karasev | 30/11/2009 | SoftwareFormerly Microsoft Dynamics GP was known as Great Plains Dynamics. If you are looking for second opinion in Microsoft Dynamics GP support for your organization, please consider remote support as possible option, especially in country side, where walk in local service might be limited.
eCommerce Shopping Cart Integration to Dynamics GP Sales Order Processing Transaction
By: Andrew Karasev | 29/11/2009 | SoftwareMicrosoft Dynamics GP, formerly also known as Great Plains Dynamics, eEnterprise, is flexible and powerful platform for eCommerce B2B and B2C Shopping Cart integration. If you are ecommerce programmer, please read this introduction level publication on integrating ecommerce shopping cart into SOP Invoice or Sales Order in Dynamics GP.
Microsoft Dynamics GP Ecommerce Custom Solutions and Coding
By: Andrew Karasev | 28/11/2009 | SoftwareIf your organization has functioning ecommerce website with shopping cart, price list and credit card processing and your Corporate ERP application is Microsoft Dynamics GP - you are probably favoring the idea of ecommerce integration on the level of connectors and custom scripts, versus implementing ecommerce website from scratch on new ecommerce off-the-shelf product.
Microsoft Dynamics GP Version Update Notes
By: Andrew Karasev | 26/11/2009 | Information TechnologyBeing on the current version of your Corporate ERP application is probably not mandatory, rather good recommendation and advice. However if you are on really outdated or antiquity accounting application version, upgrade is recommended and definitely wise step to do, and there are several factors to consider, please see them below in paragraphs.