15
Great Plains Consultant Newsflash: Custom EDI
Category: ComputersMicrosoft Dynamics GP ERP application, or popular old name Great Plains Dynamics and eEnterprise, if you have relatively recent version, is based in Microsoft SQL Server. If you are experienced SQL DBA yourself, just this fact should give you the idea on structuring select statement and make it Electronic Document Interchange code compliant.
Of course, for luxury EDI solution you can purchase Add-Ons and simply setup EDI export in the user friendly interface, however this publication is for people, who are either on the tight budget, or who have really complex EDI requirements and data format export rules. This news should also ideally help you with your Great Plains Partner, ISV and technical consultant and programmer selection:
1. Header and Trailer. In order to produce header and trailer, you should consider unions, where you simply group your records to produce single heading and footing lines
2. EDI lines. Normally these are items related lines, which you see either on customer or vendor invoice. You pull these lines from SOP30300 or POP tables
3. EDI formatting. The idea is fairly simple ? EDI format is typically fixed length fields groups. In SQL Select statement you format each fields individually with either CONVERT or CAST constructions. Sometimes, especially new EDI rules require CSV or even XML files ? if you got these ? you should be lucky to avoid doing precise fixed length formatting. EDI with XML format are becoming popular in eCommerce scenarios
4. Marking exported records. This task should be done by SQL stored procedure, this is why in EDI integration you should consider MS SQL Server DTS package creation. DTS package will allow you to export text EDI file (plus potentially email it to your vendor or even upload it to your vendor ftp) and run SQL stored procedure to mark exported records. In Great Plains for marking records you can either deploy existing fields, that are not in use by your business logic or user defined fields, plus you can create EDI export status custom table in each company database. GP doesn’t have restrictions on creating custom objects in your company database, this restriction exists in other mid-market MRP applications , such as SAP Business One
About the author
Tags: business logic, constructions, csv, edi format, edi requirements, eenterprise, electronic document interchange, erp application, export rules, isv, microsoft dynamics gp, microsoft sql server, ms sql server, package creation, plains dynamics, plains partner, select statement, technical consultant, tight budget, vendor invoice
Related Posts
- Great Plains Reseller Newsflash: Dynamics GP 10.0 Upgrade
- Great Plains Dynamics GP Consultant: Data Conversion
- SAP Business One Implementation with Custom Development
- Dynamics GP Consultant Chicago, San Diego Newsflash: Crystal Reports for Great Plains
- Great Plains Consultants Chicago, San Diego, Houston and Nationwide Support