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

329 questions
17
votes
1 answer

VS2013 doesn't seem to attach correctly - a debugger is attached to but not configured to debug this unhandled exception

While coding a console app, I'm using an SAP DLL. I'm getting the following error when trying to add an SAP object: A debugger is attached to but not configured to debug this unhandled exception. To debug this exception detach the current…
Urik
  • 1,298
  • 2
  • 18
  • 35
16
votes
1 answer

Is it possible to do Data Driven Testing using SAPb1 Testcomposer?

Is it possible to do data driven testing using SAPb1 Test Composer automation tool instead of changing the scripts every time for new updation. Thanks in advance.
Pramod
  • 2,241
  • 2
  • 17
  • 25
13
votes
0 answers

Create Custom ActiveX Controls for SAP B1

I am trying to create custom control for SAP b1 using ActiveX. I created Windows Forms Control Library Made Project Assembly Info COM-Visible (Project properties => Application => Assembly Information) Registerd for COM interop (Project properties…
xurca
  • 2,356
  • 2
  • 21
  • 26
11
votes
3 answers

SAP B1, How to display fetched Image from ItemImage?

I'm fetching an image from SAP B1 Service Layer. In postman, I'm able to view it as image/png, but there is an issue displaying it. What's the correct way to show it in ? require(fetchedImage) - doesn't work I have created a Cloud Function…
Dhaval Jardosh
  • 6,258
  • 4
  • 22
  • 57
8
votes
3 answers

How to integrate with SAP B1 using DI Server integration?

We are trying to integrate SAP business one to our application using Java Where can we find more information on it any Documents, API , tutorial, links, how to start/do it pointer towards the right direction will be appreciated. SAP's Developer…
Fossil
  • 171
  • 1
  • 2
  • 15
4
votes
0 answers

Automate initialization of SAP B1 "Analytics Services" for tenant

I would like to automate actions over SAP Analytics Services, especially Initialize Analytic Services on tenants. Analytics Services run on https://analytics-server:40000/Enablement using SAML2 SSO to authenticate, where I'm stuck on generating…
Laky
  • 465
  • 3
  • 15
4
votes
2 answers

Is it possible to install SAP B1 SDK on Visual Studio 2017?

Is it possible to install SAP B1 SDK on Visual Studio 2017 ? If Yes? how ? I tried changing registry for VS 2017 but i could not find it.
4
votes
1 answer

Compare randomly placed info in string?

I have two tables that look like the following: PKey Description Group 1AF2 Item 1 101 2B2E4 Item 2 102 3G54A1 Item 3 101 4TR7 Item 4 103 And like this: PKey Rate 1 …
phroureo
  • 367
  • 2
  • 14
4
votes
2 answers

Is the password hashing algorithm SAP uses known?

Version used: SAP B1 9.0 Background We want to supply a simple authentication web form for external users, and would like to use the SAP B1 user management to administrate users (and of course passwords). Since we were not able to find the…
Levite
  • 15,387
  • 7
  • 47
  • 46
4
votes
2 answers

Error attaching a file using the DI API in SAP Business One 9

I'm creating an application to attach scanned documents at SAP documents, but I have some problems with that process. I'm using SAP BO 9 PL8 and found the next problems: When I try to add a new attachment line in a existing attachment (using the…
PedroHdez
  • 41
  • 1
  • 3
3
votes
2 answers

How are unique IDs / sequence numbers generated in SAP B1?

I'm wondering if anyone knows how SAP B1 (SAP Business One) generates the unique primary keys it uses in various tables. Examples of what I am talking about would include OCRD.DocEntry and OCPR.CntctCode. These integer columns that get…
Rob3C
  • 426
  • 7
  • 14
3
votes
1 answer

Why SAPbobsCOM.Company COM is too slow to instance on windows server?

I developed an console application to connect to SAP B1 via DI API and notice the line below is too slow to execute. It takes about 1 min to run. SAPbobsCOM.Company oCompany = new SAPbobsCOM.Company(); *I'm using SAPBusinessOneSDK.dll and already…
Maykol Rypka
  • 472
  • 6
  • 18
3
votes
2 answers

Drupal Commerce and SAP Business One

Is there any possibilities to connect Drupal Commerce (or Ubercart) with SAP Business One ?
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,121
  • 5
  • 18
  • 36
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…
1
2 3
21 22