Advanced techniques in SAP BO Data Transfer Workbench integration scenarios. This method allows you to establish ongoing integration from such systems as Microsoft CRM, Oracle custom database, Lotus Notes Domino, etc.
Microsoft 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:
Microsoft Dynamics GP, or former ERP name is Great Plains Software Dynamics / eEnterprise gives you, programmer or software developer vide spectrum of report design tools: Crystal Reports, Microsoft SQL Server Reporting Services, GP ReportWriter, MS Access, MS Excel to name some of the popular.
In this small technical paper we would like to introduce you into Crystal Reports design for Dynamics GP, assuming that you are new to GP and need some starting help. We also assume here, that you are on MS SQL Server Database: GP 10.0, 9.0 and 8.0, if you are on GP 7.5 and earlier: 7.0, 6.0, 5.5, 5.0 or 4.0 where Great Plains was available on Ctree or Pervasive SQL/Btrieve, please review database connection options, described in our earlier articles ? you will need to install Ctree/Faircom or Pervasive ODBC drivers. Let’s come back to Crystal for GP on MS SQL Server:
Microsoft Great Plains or current name of this mid-market ERP is Dynamics GP has various development and programming options: Dexterity, eConnect, VBA/Modifier, SQL stored procedures openness, SDK for Microsoft Visual Studio developer to name few popular.
The topic is very popular as more GP MRP and accounting systems are in process of being installed and implemented. Special interest we expect from eCommerce developers, where such questions as automatic batch posting, Sales Order deposits application are very popular ones.
It is always a good advise to adopt procedures and functionality available in out-of-the-box version of any ERP application, including SB1, however it is common, when standard logic doesn’t allow to automate unique business processes
in this case you have to program modified logic in Software Development Kit. Let’s review SDK in the format of this small article:
1. Programming Language and IDE. You can use either VB or C#.Net and Microsoft Visual Studio will be your tool, assuming that you are on Windows and MS SQL Server platforms. Generic C# programmers are available on the market, however it is recommended to consider contracting certified SB1 SDK developer, who has expertise in B1 objects structure and technical side of business logic