Home / SAP Business One SDK (page 2)

SAP Business One SDK

About update SAP business one cloud extension

Dear All These are the steps when you update the new addon on cloud. 1. Unassign tenants 2. Undeploy service units 2 times. 3. Remove extension from CCC 4. Clear addon from presentation server: a. Delete addon folder from “C:Program Files (x86)SAPSAP Business OneAddOns” b. Delete addon relevant information in …

Read More »

Guidelines for Modifying SAP Business One Data

We can always see customers/partners using several direct updates in some form of Add-Ons/TransactionNotification. Below are some guidelines: Question1: Is it permit to INSERT/UPDATE/DELETE on UDTs through HANA Studio, Coding, B1if? Answer: Direct updates not allowed. It is ok for UDTs of type [No Object & No Object with Auto. …

Read More »

Sample code to Update existing Item Batches Properties via DI API

Hello Everyone, Below is a sample C# code I wrote for updating an existing Item Batches properties for SAP 9.1.      private static void BatchUpdate()      {           SAPbobsCOM.CompanyService oCompanyService;           oCompanyService = oCompany.GetCompanyService();           SAPbobsCOM.BatchNumberDetailsService oBatchNumbersService;           oBatchNumbersService = oCompanyService.GetBusinessService(SAPbobsCOM.ServiceTypes.BatchNumberDetailsService);           SAPbobsCOM.BatchNumberDetailParams oBatchNumberDetailParams;           oBatchNumberDetailParams = oBatchNumbersService.GetDataInterface(SAPbobsCOM.BatchNumberDetailsServiceDataInterfaces.bndsBatchNumberDetailParams);                      …

Read More »

B1 Service Layer: Grouping

In this blog, I would like to share another new functionality planned to release in Service Layer 9.2 H Patch 03. It is about the oData grouping, which is an important extension to the original oData protocol. Grouping behavior is triggered using the query option apply and the groupby keyword. …

Read More »

B1 Service Layer: Entity CRUD – Update

In this blog, I would like to share how to do business object update operation via Service Layer API. As Service Layer follows OData protocol, it uses HTTP verb PATCH or PUT to update entities. The semantic difference is: A PUT request indicates a replacement update. All property values with …

Read More »

B1 Service Layer: Aggregation

In this blog, I would like to share a new functionality released in Service Layer 9.1 H Patch 12. It is about the oData aggregation, which is an important extension to the original oData protocol. Aggregation behavior is triggered using the query option $apply. Any aggregate expression that specifies an …

Read More »

SAP Update EditSize for UserFieldsMD

Hello, i want to share with a code for updating UserFieldsMD EditSize First you have to got the TableName of UserFieldsMD and the FieldID then; Dim IRs as integer = 0 Dim _SizeInt As Integer = 50 oUserFieldMD as SAPbobsCOM.UserFieldsMD oUserFieldMD.EditSize = _SizeInt OUserFiedMD.Update() IF IRs <> 0 then msgBox …

Read More »

Get Value of a Matrix Cell

While attempting to “convert” or cast an SAPbouiCOM.Cell object into an SAPbouiCOM.Item object without success, I’ve come to the determination that Cells are NOT in fact “unique” objects in the UI API. My second hint to this was the fact that individual cells don’t seem to have UniqueIDs. So, while …

Read More »

Get Value From (Any?) SAPbouiCOM.Item

As some may know, I’ve written a procedure toBuild a VB.Net DataTable out of an SAPBouiCOM Matrix. Well, I just tried using that nice little method on the Sales Order form, and I ran into an error. Apparently, one of the objects in this particular matrix is a checkbox, and …

Read More »

Query Manager Syntax

Below is a Query Manager query that I wrote with additional comments. I’m going to be making “use” of this query often as a template and example of how to quickly and easily setup future Query Manager queries. I know some people like to make things more complex and sort …

Read More »

On Naming and Such

So, we’ve been having a discussion around the office on what should be our standard, if any, regarding naming conventions, and when to use objects and sub-objects rather than to just use the full context of the objects. I might be using the wrong terminology here, but here’s an example …

Read More »

Search XML to Grab Info

I created the following procedure a while ago, and decided to share it, because I’m fairly proud of it. I wrote it to grab the user’s default font settings from the SAP configuration file, but I think it could be used to parse virtually any XML file and extract just …

Read More »

DI UI API Xref

So, I spoke in an earlier post somewhere that I was working on a spreadsheet to try to coorelate all of the DI API and UI API objects. I’m building this as I go, but I thought that if I was to get it out here for the community to …

Read More »

SAP – The Unrelational Database

I noticed within Microsoft’s SQL Server Management Studio that several of the main tables (ORDR, OWTR, etc.) seemed to have no foreign keys at all linking the tables. I was hoping that I could get a visual Entity Relationship Diagram of the tables somehow, so that I could see what …

Read More »

The Importance of Documentation

I’m getting very frustrated with SAP’s lack of proper and up to date documentation for B1. I’m sure others have felt this way as well, so I’m working myself on documenting everything that I can find for my own purposes, as I need to find the information. I hope that …

Read More »