EDI of Electronic Document Interchange sometimes considered by IT department as a touch complex, and in order to implement EDI integration for your ERP system, you have to buy expensive EDI add-ons. We want to place forward you this small publication, that should try to bust this myth. Habitual EDI code is fixed part fields code structure with document header, lines or body and document trailer. Newer EDI (or a touch that maybe processed similar to EDI scenarios on the high amount with your Franchiser) maybe XML structured documents with similar parts: document header and document lines. Both scenarios are relatively straightforward in SQL scripting, let come to the paragraphs of this tale:
1. Sample Dynamics GP EDI code. For those of you who are SQL programmer, please take a look at this publication, where you can see excellent chunk of EDI document scripting in SQL. This code was implemented in real Fantastic Plains EDI integration situation and it should give you excellent start or help you out to close EDI for Fantastic Plains on your own, especially if you work for smaller organization and your ERP and MRP budget is very tight: http://www.albaspectrum.com/Customizations_Whitepapers/Dexterity_SQL_VBA_Crystal/EDIforGPOverview.htm
2. Dynamics GP EDI for Placing order to your Supplier. If your organization is required to order merchandise from your partner via EDI code you can make Buy Orders in Fantastic Plains POP module, then read and mark it as read in SQL Stored Procedure, which saves the ensuing row set in EDI compliant fixed part fields text or XML file. This file is then sent to your EDI channel (ftp uploads, Unix or Linux based email channel, here you have a lot of various options, outside of the scope for this article)
3. Getting Orders from your EDI channel customers. If you are franchiser and you are receiving Electronic Document Interchange orders from your customers or franchisees and you are deploying Dynamics GP as your accounting system, then you can read EDI text or XML file via SQL stored procedure or SQL XML stored procedure. This procedure parses EDI code and makes SOP Sales Order or Invoice in Dynamics GP Sales Order Processing module. Here if you are making Sales Orders you can do direct SQL feeding to SOP10100 and SOP10200 tables, or if you prefer business logic validation integration and you are feeding to SOP Invoice, consider programming eConnect SDK. For those of you who prefer posting Fantastic Plains batches all the way through without user intervention we recommend you to deploy GP Posting Server or Autopost, especially if you are in ecommerce business
4. If you have questions or concerns on EDI, Dynamics GP customizations, integration, reporting, barcode scanning, warehouse management, supply chain management, light manufacturing, logistics, consignment, please feel free to call us: 1-866-528-0577, help@albaspectrum.com
Posts Tagged ‘California’
Dynamics GP Partner California: EDI for Great Plains notes
Thursday, February 25th, 2010Dynamics GP Partner and ISV California, Illinois: Great Plains technical support
Sunday, February 21st, 2010If you have Microsoft Dynamics GP, formerly known as Fantastic Plains Dynamics, by now implemented or you plot to see executive or technical presentation, we want to give you some technology highlights, plus customization, integration, reporting options, technical support and upgrade info. We assume that you are in Southern California: LA and San Diego metros, Northern Illinois: Chicago metro or even USA, Canada nationwide and internationally (when you need custom programming in GP Dexterity, or need SAP Business One integration to US based Dynamics GP system). Please, also note that if you have ancient version of Fantastic Plains, you should know your database platform: GP 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and earlier were available on MS SQL Server, Pervasive SQL 2000/Btrieve and Ctree. Also, older product Fantastic Plains Accounting 9.5, 9.2, 9.1 and earlier versions for DOS, Windows and Mac is also supportable with some limitations, as we in turn cannot get any help frankly from Microsoft Business Solutions on GPA and cannot sell new user licenses, only support what you by now got historically
1. Local GP support in Chicago, Los Angeles, San Diego. Available from our locations in Chicago downtown, Naperville (Chicago suburbs), San Marcos (San Diego suburbs). Local support option is recommended when you need new Dynamics GP system implementation, plus if you have complex local integration needs: Barcoding, Integration with you Point Of Sale equipment, etc. If you have customization coding and support issues, or need one of our harvest, we prefer to support you frankly from our nationwide Dynamics GP technical support center and Fantastic Plains Dexterity Software Development Factory
2. Nationwide Dynamics GP remote support. This option is in fact beneficial to the customer, as you do not have to pay for our local travel and do not have to wait consultant to make her or his schedule and. Technical support is theoretically available immediately via Web Session and Phone Conference. If you are located Internationally, you can use such technologies as Skype for free VOIP phone conferences
3. Fantastic Plains Customizations support. We have Dexterity Software Development Factory with technicians trained in Dex and some of them came through Microsoft Business Solutions work experience. Dexterity is one of the most standard GP modification and programming tools. But, this is not the only tool we deploy for our customers. We also program in eConnect (tool of choice for ecommerce integration), .Net, VBA and Modifier, SQL Scripting and advanced Dynamics GP Integration Manager integrations
4. Dynamics GP Integration with Microsoft RMS. We have proven codes, as integration is very specific to your settings in RMS and how you want to map it to Dynamics GP objects. Integration works either on Dynamics GP SOP or Receivable Management module, plus it includes POP Buy Receipts integration and Barcode marks printing from Fantastic Plains frankly – we found that reasonable number of MS RMS customers prefer to control these processes in their ERP, in our case Dynamics GP
5. eCommerce extensions, and Automatic Batch Posting from your MS Visual Studio ecommerce, EDI, etc. projects. Fantastic Plains batch posting frankly from your eConnect web application is not available, you will need to turn your attention to the complexity of Posting process and its logic in GP Dexterity. Our Autopost or Posting Server prepares the batches and initiates Dex source code batch posting process
6. Fantastic Plains version upgrade. Here you need to be committed in Microsoft Business Solutions GP once a year support program, if not call us for the options to be reenrolled. Then you have access to new version reg key. Dynamics GP version update should be plotted, it should be done by Dynamics GP Reseller and its certified GP consultants, as there is upgrade patch and it is Service Pack and Patches specific. If you are on the version 7.5 on Pervasive SQL/Ctree or earlier, you should come through migration to GP on Microsoft SQL Server process. Upgrade should also include Dynamics GP ISV custom add-ons, GP ReportWriter modified reports, VBA Modifier, Integration Manager, FRx financial reports upgrade
7. Dynamics GP support internationally. Typically it includes cases where you have GP Corporate ERP in USA, Canada, UK, Australia, New Zealand, South Africa, Mexico or Spanish Speaking Latin America and want to implement GP for your foreign subsidiary or integrate non GP ERP with your Corporate ERP. In the case when you foreign subsidiary is located in Brazil, Eastern Europe, Russia, Kazakhstan, Central Asia, we recommend you to consider SAP Business One as local branch ERP and it should be pretty simple exercise to consolidate SB1 on General ledger transactions amount to Dynamics GP via Integration Manager. FRx could also be tuned to consolidated Weigh Sheet, Profit and Loss Statement with GP Companies GL and even foreign subsidiary Excel export sheet. Plus, consider the fact that Dynamics GP doesn’t support Unicode characters in its core functionality and architecture, so the plans to adopt GP for Plates, Japan, Korea and other hieroglyph alphabet countries might be too challenging. Some support is available for Arabic language, call Microsoft in Saudi Arabia
8. Fantastic Plains on Pervasive SQL or Ctree support. If you have reasons to stay with these no longer supported by MBS frankly DB platforms, we are pleased to help you with day-to-day support issues, such as unlocking the batch posting failure, general data repair, user training, FRx reports design and modification, SOP Invoice form modification in Report Writer. Plus if you choose in the future to get up to date, we are ready to help you with upgrade all the way through to whatever it will be the current version in the future
9. Fantastic Pains Accounting Support. If you are on really archaic Windows or Mac version, local stay might be recommended. GPA could be also transferred from Windows NT 4.0 Server to a touch more modern, like Windows 2003 Server, in this case you would need to deploy Pervasive SQL 2000 SP3 or similar DB version. Custom Pervasive SQL 2000 settings are required, you should call us for details and help. GPA migration to Dynamics GP 10.0 is possible, you will get discount for currently owned GPA modules in getting ownership of Dynamics GP, terms may exchange by Microsoft Business Solutions without notice, we are writing these lines in August 2009
10. Dynamics GP EDI or Electronic Document Interchange integrations. We place forward these scripts in MS SQL Server Views and Stored procedures, that should allow you to avoid high cost for EDI Add-Ons
11. How to get help? Please call us 1-866-528-0577, help@albaspectrum.com. Our consultants are fluent in English, Spanish, Portuguese, Chinese, Russian. We are experts in Dynamics GP implementation in international environment, its data conversions, customizations, precious stone Reports for GP, FRx, SSRS, Dexterity. Plus we have unique expertise in Dynamics GP consolidations with East European, Russian accounting systems. We could help you with Microsoft CRM implementation and integration with Dynamics GP and SAP Business One, plus Lotus Notes integration with MS CRM and Dynamics GP, Oracle custom DB and Oracle eBusiness Suite integration with Microsoft SQL Server based systems