SAP,Business,One,Customization computer SAP Business One Customizations and Integrations Programming
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
Lets make short technical introduction and then try to talk about cases studies and get popular questions answered. Lets 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 paragraph2. 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 set3. 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 performance4. 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 it5. 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 Reference6. 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 doesnt 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 LinuxLets now answer popular questionsQ. 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 compromisedQ. 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 objectsPlease call us 1-866-304-3265, 1-269-605-4904, [email protected]. 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
SAP,Business,One,Customization