SAP Business One SDK

B1 Service Layer: Attachment manipulation

In this blog, I would like to share another new functionality planned to release in Service Layer 9.2 H Patch 03. It is an enhancement to the original attachment operation. ( Actually, it is available in 9.2 H Patch 02 and 9.1 H Patch 12 as well. ) The supported attachment type list is: pdf doc docx jpg jpeg png txt xls ppt 1 Setup an attachment folder Attachment folder …

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. This keyword specifies the grouping properties, a comma-separated list of one or more single-valued property paths that is enclosed in …

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 those specified in the request body will be replaced. Missing properties are set to their default values. Be aware of …

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 aggregation method MUST define an alias for the resulting aggregated value. Aggregate expressions define the alias using the as keyword, …

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 ( “Object already exists in the database.”) Else msgBox(“Size Update.”) END IF ________________________ Hope That was helpful for you Good …

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 they are technically “objects” in the traditional OO sense, they don’t appear to fall under the category of SAPbouiCOM.Item objects, …

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 I didn’t account for that, just assuming that everything could be obtained from the Object.Item.Specific.Value. Well, this is not the …

Read More »

c# .NET Crystal Reports Connection method for SAP Business One running on HANA

Hello Friends, I leave this post about the connection method on a .NET c# project SAP Business One AddOn, of a report build in Crystal Report 13 and 11 who will be use in SAP Business One version for HANA, hope this will work for you like was for me. best Regards SAMPLE CODE:         public static bool buildCrystalReportAlmacen(int strDocEntry,string oAlmacen,string oPrinterName, string oUserId)         {             bool Retorno = …

Read More »

Create SapbouiCOM.Matrix from Query

This is a little method that I’m fairly proud of. We have a requirement for the end users to be able to search for multiple values on a UDO. Well, as I learned with my recent work looking into CFLs, that’s not an option normally. So, what I’m going to do is this: I’m going to get the input from the users by using a comma-delimited list in the desired …

Read More »