SAP,Business,One,Integration,v computer SAP Business One Integration via SDK Programming Importing T
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
And we had it deployed several years ago in our own consulting practice for internal timesheet submission and automatic transfer to accounting system. Lets begin with workflow description and go down to code. Please note that this code is presented here just to feel the level of programming complexity or simplicity and it requires initialization files and supplementary SQL scripts. Now lets go to details:1. Timesheet entry in Microsoft CRM. We do not have any customization in CRM itself and we do not have ISV add-ons as well. Sales process begins with lead entering and then if we got the deal then lead is transferred into account and contact. We prefer Contract and Contract Line creation as it allows us to track budget on the Contract Line level and have consulting rates pinned to the Contract. When contract is invoiced we open the case and have our consultants and software developers submit their time in Tasks linked to the case. When project manager closed the case then it is scheduled to be transmitted to SAP Business One in the form of Sales Invoice. Integration is running tonight via Windows Scheduler2. SQL Scripts. We do not provide them in this publication. Their logic is simple. They pull newly closed cases and place them into the queue table in custom SQL database. Following Microsoft recommendation we do not create custom objects directly in CRM database and instead we have created custom database where all views and tables are hosted. If you review CRM database in SQL Server Management Studio you can probably agree that table names are self-evident3. SAP BO Software Development Kit part. SB1 deploys three tiers architecture with database layer, application server and client interface. It is not recommended to feed data via SQL insert statements and this is why you have to appeal to Software Development Kit where code snippets are available in VB or C#. In our case we have chosen C#. This is DOS application without user interface and we believe that it makes it straightforward for being used as the sample in your programming efforts. It was originally created for version 2005A but we believe that code review to make it compatible to 2007A or even for 8.8X is simple enough for somebody who treats himself as Microsoft Visual Studio programmer with reasonable exposure to SAP BO architecture. If you do not see the code below then please find this publication directly on EFaru website4. Some tips. Version update requires SDK project to be recompiled in the Microsoft Visual Studio in the environment where new version workstation is installed as the installation brings new DDLs. We also consider this code as the solution and not as canned software product. Again in our opinion SAP BO and MS CRM tandem is rare combination and the market is too narrow to support canned add-on. So feel free to contact us, but do not bother with technical details5. Please call us 1-866-304-3265, 1-269-605-4904, [email protected]. We have local presence in Chicagoland, Southern California, South West Michigan, Houston and Dallas areas of Texas. We serve customers USA and Canada nationwide and internationally via web sessions and phone conferences (Skype is welcomed)
SAP,Business,One,Integration,v