SAP B1 is friendly to Microsoft Visual Studio programmers via its so-called Software Development Kit. In the next version 9.0 expected in the fourth quarter of 2012 it is rebranded as ‘Business One Studio’.
Let’s make short technical introduction and then try to talk about cases studies and get popular questions answered. Let’s begin with SDK categorization:
1. UI API. ‘The UI API provides programmatic access to windows, menus, and events in SAP Business One. The UI API allows you to create new windows, modify existing windows, add new business logic, add or modify application menus, and more.’ After introduction from ‘Help Center’ we would like to mention that user interface modification might be vulnerable to such future projects as upgrades. We would rather recommend you to concentrate on integration type of projects and see next paragraph
2. DI API. ‘The DI API provides a programmatic interface to SAP Business One through a set of fully functional business objects. The DI API provides access to the business logic and data-access layers of SAP Business One.’ It is much easier to review integration code and recompile it with new release DLL set
3. DI Server. 'The DI Server is an extension of the DI API and supports all its objects. It is intended for high-volume data integration, where numerous client connections must be managed simultaneously and optimized for speed. It is also suitable where Web-services architecture is preferred.' Here you should think about maximum performance
4. Code samples are available in C# and VB. This is one of the reasons for you to consider coding in these languages. However if you are comfortable to translate to your favorite .Net compliant language feel free to deploy it
5. Table structure. Here you have to combine client interface and SDK. Login B1 and in menu View->System Information mark it. Open the form where you need to know the table and place cursor over and read field and table name on the bottom left corner. Write down table name and in Help Center search it. Try the following exercise. Open Sales Order form and place cursor over Customer field. And you should see the field Name CardCode and table ORDR. Then review this table in Help Center Search. If you are comfortable to find the table on your own directly in Kit then go to Customization Tools -> Database Table Reference
6. Integrations. It is recommended first to create user defined tables in client application and then use them as staging objects. You can import records to such table directly via SQL insert statement as it doesn’t participate in core business logic. Next step is DI API programming in Visual Studio where you read records from staging table and create AR Invoices, Purchase Orders, etc.
7. Integration with Linux and PHP. This is frequent request due to the fact that custom ecommerce portal are often hosted in MySQL on Linux platform. Good recommendation is to consider SOAP XML Web Service with SDK libraries. Web service is computer platform neutral and could be called from Linux
Let’s now answer popular questions
Q. We would like to program integration directly in SQL Stored Procedures without DI API. Table structure seems to be simple. What do you think?A. We do not support this idea. Business One has application server which is responsible for such important data integrity features as transaction rollbacks. Data might be compromised
Q. Is it possible to address user defined tables and fields in programming project?A. Yes it is possible. Business One Studio 9.0 features better support regarding user defined objects
Please call us 1-866-304-3265, 1-269-605-4904, help@efaru.com. We have local presence in Chicagoland, Southern California, Atlanta Georgia, 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). We are working on Brazilian ERP consulting market in Sao Paulo since 2004
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
