Stack Overflow
Stack Overflow

Questions tagged [sapb1]

SAP Business One (B1) is enterprise resource planning (ERP) software designed for small and medium-sized enterprises, manufactured by SAP SE.

SAP Business One (B1) is enterprise resource planning (ERP) software designed for small and medium-sized enterprises, manufactured by SAP SE.

SAP Business One runs on Microsoft SQL-Server or SAP HANA database engines.

Related tags

501 questions
3
votes
2 answers

Timeout Expired (cmd.CommandTimeout = 0 being ignored)

I'm receiving this error: Timeout Expired even after setting the cmd.CommandTimeout = 0. The query is pulling from a SAP database, in SAP the SQL query runs fine however when I try run it on an adapter in visual studio I get that Timeout Expired…
L--
  • 33
  • 1
  • 6
3
votes
5 answers

SAP B1 : Read from Matrix

I'm trying to read from a Matrix. The code that I have until now is: SAPbouiCOM.Matrix matrix = (SAPbouiCOM.Matrix SBO_Application.Forms.ActiveForm.Items.Item("38").Specific; SAPbouiCOM.Column col = matrix.Columns.Item("1")…
Miguel Ribeiro
  • 31
  • 1
  • 1
  • 3
3
votes
1 answer

Dialog box does not work for SAP Business One Add-On

I have used the code below for my SAP Business One add-on that reads Excel sheets from a dialog box. While testing my addon, I placed a breakpoint at Thread.Sleep(1); // Wait a sec more in Visual Studio 2012. This enables the dialog box to open…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
3
votes
2 answers

Drupal Commerce and SAP Business One

Is there any possibilities to connect Drupal Commerce (or Ubercart) with SAP Business One ?
Jean-Simon Lyonnais
  • 83
  • 1
  • 1
  • 7
3
votes
0 answers

Subdivide a single column to multiple

hi alli want to know is it possible to subdivide a single column to multiple sub columns in a grid or in a matrix in SAP B1. and i am using version 8.82. i need this requirement for the display purpose.sample format is month(main column)LOP days…
Sivajith
  • 1,181
  • 5
  • 19
  • 38
2
votes
1 answer

Add-On Registration (ARD +Zip) files in SAP B1 through automation (DevOps)

I want to know about can we do Add-On Registration (ARD + Zip) files through automation or using DevOps Tools. If you have any method then let me know or refer to an article.
Mehboob Ahmad
  • 21
  • 2
2
votes
2 answers

SQL query for finding the latest sale price for an item for a customer

Hi I have the following data set generated from database (of a SAP Business One system) I generated this result by using the following query: SELECT T1.[ItemCode], T0.[DocNum], T1.[Price], T0.[CardName] FROM OINV T0 INNER JOIN INV1 T1 ON…
Parmeet Singh
  • 23
  • 3
2
votes
1 answer

Creating sub menus (folders) under the Administration menu in SAP Business One 8.81

I am developing an payroll add-on for SAP Business One 8.81. I can be able to add menus below the last menu item that comes with the SAP application i.e. Reports. I am trying to add a setup submenu for my payroll add-on under the…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
2
votes
1 answer

rownumber() function to count adjacent cells

I need to update contact person data using DTW (can't do directly with sql script). 'CardCode' is the key field. 'CntctCode' is the record but you cannot update on the field. You must import use a number starting with 0 and increasing for each…
Digital_Speed
  • 43
  • 5
2
votes
1 answer

Date format is not working in some computers, SQL Query

Below date format is not working in some computers I do know why, SELECT FORMAT (getdate(), 'dd/MM/yyyy ') as date I use SQL Query. What is the problem? Please anyone can help me
Schadrack Rurangwa
  • 413
  • 12
  • 28
2
votes
1 answer

How to disable Sap Business One form's default resizing behavior?

I'm developing the custom UI layout system for our custom SBO forms. I.e. catching form's resize event and arranging the controls according to our specific layout logic. The problem is that, apparently, SBO tries to arrange controls according to its…
Titan
  • 2,875
  • 5
  • 23
  • 34
2
votes
3 answers

Connect Sap B1 hana with C# Application using DI API

I am Trying to Connect MY Sap B1 HANA on C# Web Based Application using DI API but my connection is giving me error. Here is Error Screenshot Failed to Connect SLD,make Sure Your SLD Server is Available and Connected. Any Relevant Help would be…
shahzaib
  • 49
  • 1
  • 10
2
votes
1 answer

SAP Business One c# development, form and button events

I am creating an addon and for that I have successfully connected DI and UI API. I am creating everything (forms, buttons, textbox, etc.) manually by code to learn as this is my first one. When I debug, I can see my form with all the fields I…
Ranu Vijay
  • 1,137
  • 9
  • 18
2
votes
1 answer

OpenFileDialog in SAP B1 Add-On C#

I am working on SAP B1 Add-On using C#. When I call OpenFileDialog.ShowDialog() this exception is thrown: Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has …
Montaser
  • 57
  • 5
2
votes
1 answer

SAP CCO Java Plugin include external library

I am developing plugin for SAP CCO. I need to communicate with fiscal device from plugin for that i use jSerialComm library. When i call jSerialComm method from my code i am getting InvocationTargetException.(Throwable) line: not…
Beqa Latsabidze
  • 212
  • 4
  • 12
1
2
3
…
33 34