Crystal Reports for Microsoft Great Plains overview for developerWritten by Andrew Karasev
Continued from page 1
3.Consider SQL Views if you dont want complex links in Crystal Report itself or if you need unionization from several companies SQL view is answer. 4.Consider SQL Stored Procedures. Sometimes you can not pull data in one view you need temporary tables to be created and final query should be based on these temp tables this is when you need stored procedure. 5.Call Crystal Report from GP Screens via VBA/Modifier if user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window you can use Modifier and VBA to call Crystal Reports engine. 6.Create SQL Query to probe data we always recommend tuning your query and see that you are getting adequate results in any case Crystal Report is just a nice tool to show results of your query.Happy customizing, querying and designing! If you would like us to do job: 1-866-628-0577, help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally ( www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
| | EDI: Electronic Document Interchange for Microsoft Great Plains overview for Software Developer/Programmer/DBAWritten by Andrew Karasev
Continued from page 1
--Additional fields go here from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join RM00101 d on a.CUSTNMBR=d.CUSTNMBR join (select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, LNITMSEQ as LNITMSEQ, CMPNTSEQ as CMPNTSEQ from SOP10200 union select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200 group by SOPTYPE, SOPNUMBE ) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1)) left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE where a.ADDRESS3<>'Exported' and a.SOPTYPE=3 and upper(d.USERDEF2)='YES' order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc 2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0: update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3 3. Communication with UNIX EDI Client or Server each case requires individual approach. You may have to assign file directory, exposed to UNIX system or use old DOS command to move file, or you can have automatic email. Good idea is to write communication application in your favorite programming language 4. Scheduled DTS Package - you should probably create DTS package to do all steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX Happy programming! if you want us to do job - give us a call 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally ( www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
|
