SAP Business One SDK

(BR) Utilizando DI API 9.0 em ambiente IIS

As etapas abaixo norteiam para a configuração correto da DI API v9.0 em ambiente: Microsoft Windows 2012 Data Center Microsoft SQL Server 2012 IIS 8 PHP 5.x SAP 9.0 A instalação de Operação e Banco de Dados será separada, dando mais flexibilidade e segurança para a aplicação. No ambiente 1 temos: Microsoft Windows 2012 Data Center IIS 8 PHP 5.x (32 bits) DI API 9.0 (32 bits) No ambiente 2 …

Read More »

UDO Implementation DLL sample – meal order

Writing a UDO implementation DLL is not an easy task. To start with, you need to write it in C++ and compile it into a DLL. If you installed the SBO SDK, There is an example of this UDO DLL implementation. Event so,  it is not as easy as one would think of. Especially when not experienced in building a C++ DLL having reference to another DLL. There is no …

Read More »

Various SDK tests

While answering to some questions on the forum, it appers that most newcomers are lost with the samples provided with the SDK. Besides that some needs to be refreshed a bit, they don’t necessarily depicts all the API and by the way how they are used by some of the developers. To try to answer this one, I will provide in this blog the sample application I’m using to implement …

Read More »

Checking and removing UDF before updating

While upgrading some databases, we sometimes encounter checks stating that differences exists between UDT – UDF defined at the SQL-Server level and what is configured Inside Business One. One of the “bad side” of these messages is that they don’t tell what are the faulty objects, relying on the administrator to find them alone. Basically checks have to be done from both side (what is defined in the SQL-Server and …

Read More »

Connecting an add-on to SAP Business One

Presentation Connecting a program to SAP Business One is the first thing every developer has to do and the (not so easy) answer dépends on to which part of the Platform the program has to connect. Basically, the options are: Connect to the Data Interface (DI-API), Connect to the User Interface (UI-API), Connect to the UI then to the DI, Connect to the UI-DI then “derive” the connection to a …

Read More »

How to Export and Import Journal Entry using XML via DI-API

Introduction Goals Export a journal entry record in XML format thru DI-API Format and simplify the XML file to make it valid format for DI-API Import back the formatted XML file thru DI-API Please note the codes here are simplified for better understanding especially for beginners. Versions SAP Business One 8.82 (8.82.072) PL: 09 SAPbobsCOM88.dll (8.82.072) VB.NET 2013 Entire Source Code For those who just wants the code and go, …

Read More »

ChooseFromList on User Defined Form ( SDK & XML )

Objective:     To make CFL on User Defined Form through SDK and XML The Choose from List is a basic functionality in the SAP Business One application that lets the user open a ChooseFromList form by clicking a trigger item. Hereby I post the part of source code related to CFL for your reference. 1)  Declare the uqniqueid for CFL and declare the Object ID where you are collecting data from. …

Read More »

Set Default Layout DI API

    Public Sub setDefaultLayout(_LayoutCode As String, _ReportCode As String, _UserID As Integer)         Dim oCmpSrv As SAPbobsCOM.CompanyService         Dim oReportLayoutService As ReportLayoutsService         Dim oDefaultReportParams As DefaultReportParams         ‘Get report layout service         oCmpSrv = B1Connections.diCompany.GetCompanyService         oReportLayoutService = oCmpSrv.GetBusinessService(ServiceTypes.ReportLayoutsService)         ‘Set parameters         oDefaultReportParams = oReportLayoutService.GetDataInterface(ReportLayoutsServiceDataInterfaces.rlsdiDefaultReportParams)         oDefaultReportParams.LayoutCode = _LayoutCode         oDefaultReportParams.ReportCode = _ReportCode         oDefaultReportParams.UserID = _UserID         ‘Set the report as default         oReportLayoutService.SetDefaultReport(oDefaultReportParams)     End Sub

Read More »

Open file browser from SAP B1 and read data from excel sheet

Purpose of the Document: How to read contents of Excel sheet by SAP B1 Addon. Sometimes, While preparing GRPO, my Client had to enter Serial numbers of many Items. Their suppliers used to provide them that data in excel format also. So I have developed addon to read the data from excel sheet Steps – ‘1. I have created one Button on Serial Number Setup window, on Button click event …

Read More »

Open file browser from SAP B1 and read data from excel sheet

About Me: I have 4 years of experience in implementation and developing Addons of B1 8.81, 8.82. Consisting need of reading the data from Excel sheet and using it in SAP B1, I have defined steps to be followed for reading excel sheet data. I know that SAP has given ASAP methodology but in this blog am going to explain it in differ way. Purpose of the BLOG: How to …

Read More »