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
1
vote
1 answer

How to extend an user definded table in SAP B1 10.0?

I am trying to change a selection table within our packing list menu in our SAP system, but I do not know how to do this. My colleague, who is out indefinitely, has created a table of packing materials for our warehouse staff. This table is now to…
1
vote
1 answer

Does the SAP B1 Service Layer require HANA backend?

In the available documentation about the Service Layer I have read, that there is a requirement to run a HANA backend, if the Service Layer is to be used. This info can be found e.g.…
Koenigsberg
  • 1,726
  • 1
  • 10
  • 22
1
vote
0 answers

SAP B1 Inventory Counting : Getting error as Internal error (-5002) Occurred

We are implementing inventory counting service in our application & we are making calls using DIAPI. When we perform the add operation on inventory counting we are getting an error: Internal error (-5002) occurred We are using SAP B1 V10 with…
1
vote
0 answers

Internal Server error 500 in Tomcat log - Problem with x-forwarded-for header

I need to configure external access for a service based on SAP Business One. The service in this example is a Mobile service so one can use a mobile app provided by SAP. In order to use the app, the URL needs to be externally accessible. We want to…
1
vote
1 answer

How to properly inactivate a Business Partner via DI API?

I need to inactivate thousands of abandoned Leads. I'm doing it by loading up each one, setting Valid = NO, and saving it back to the database. Here is my code: var ocrd = Company.GetBusinessObject( SAPbobsCOM.BoObjectTypes.oBusinessPartners ) as…
Charles Jenkins
  • 340
  • 4
  • 10
1
vote
1 answer

ItemEvent in SAP B1 SDK with a SAP form created in Visual Studio 2015

I truly really need your help. I want to be able to deal with a Click on an Item on my Form which has been created in Visual Studio 2015 this is my Main Methode : static void Main(string[] args) { try { Application…
1
vote
0 answers

Multiple instances of forms has data writing to first opened form

I have this SAP B1 addon where a user can open multiple instances of a UDO from. The form is loaded from XML. SAPUtility.LoadFromXML(SboConnection.SboApplication, GUI.FormsPath, "SalesOrder.xml"); I have CFLs but when I open the 2nd form and select…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
1
vote
1 answer

SAP B1 Error: 'Item - Can't set value on item because the item can't get focus. [66000-153]'

I am using SAP B1 Studio to make an 2 edittexts with choose from lists for CardCode and CardName. I keep getting the error 'Error: 'Item - Can't set value on item because the item can't get focus. [66000-153]' after I make a selection from any of…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
1
vote
1 answer

Sending Attachment to SAP B1 remote Service Layer

In a C# application, I want to send files to "remote SAP B1 service layer". I have tried many ways to send an attachment to this remote service layer, using their b1s/v1/Attachments2 endpoint, but I continuously receive an error "A file with this…
1
vote
1 answer

GetByKey() not working in some users in SAP B1

So I have this problem where I want to get DocEntry in OPCH table so I use the GetByKey(). The problem is that it works in all users except this particular user where GetByKey() returns false when I logged in to this specific user. here is my…
Rak
  • 139
  • 5
  • 20
1
vote
1 answer

How to send data in one message to a telegram bot?

Now I'm making a method, after which the data is successfully sent from the telegram bot to the user. Now I have made this option. However, the problem is that all data is sent separately. And if we assume we have 20 books in the matrix, we get 21…
David
  • 13
  • 3
1
vote
1 answer

SAP B1 with C#: how to apply an input mask to an edit text

I have a "Sales Order" table. It has a column "Total (LC)". I need to check the data entry with C#. Namely, I need to enter only numbers in the field. As far as I understand, this should work when I start entering something in this field. Do I need…
Mary
  • 11
  • 1
1
vote
2 answers

How to connect SAP Business One Service Layer using .NET Framework

I am unable to connect SAP Business One Service Layer using .NET Framework. It throws the error Internal Server Error with status code 500. HttpClient client = new HttpClient(); string json = JsonConvert.SerializeObject(new { …
1
vote
0 answers

Undo the total amount round / A/R invoice - document total, field cannot be updated (odbc -1029) SAP B1

I am trying to undo the automatic total amount round in A/R RESERVEI NVOICE b1 on an add on extension. The error throws after: txtDocTotalAfterDiscountFreightCharge.Active = true; txtDocTotalAfterDiscountFreightCharge.String =…
1
vote
2 answers

Put two queries into one query - Query - SQL - SAP B1

I have a very simple Inventory in Warehouse query, and now I need to do a sum in the IsCommitted column with another query that I have called "Set Demand". Like this = Sum( [IsCommited] + "Set Demand Query qty") Warehouse query SELECT T0.[ItemCode]…