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
2
votes
1 answer

SAP B1 DI API - Differences between SBObob GetItemPrice and CompanyService GetItemPrice?

What's the main differences between the DI API methods for GetItemPrice? The SBObob accepts less parameters (and returns a Recordset), but as far as I can tell it provides the accurate price for the item taking into accounts any Business Partner…
2
votes
0 answers

SAP B1 9.2 Webservice - PHP - (OrdersService Method GetByParams)

I get an Error when try to consume a webservice of SAP B1 9.2 (OrdersService->GetByParams): env:Sender-Unknown SOAP Command I can get login, logout and call Update method from OrdersService.wsdl without problem. This is my code for call…
2
votes
1 answer

Add delivery info to query in SAP Crystal Reports

Below is a query linking Purchase Orders to Sales Orders. My understanding is that in order to include delivery doc # to this report, I need to add one more table - ODLN (so there would be an additional field titled "Delivery Doc#" aka…
vnguyen
  • 327
  • 1
  • 3
  • 16
2
votes
1 answer

While Loop SAP B1 SQL stored procedure for blocking

I have an issue with my stored procedure SAP B1. What I'm trying to do here is storing the sum of the quantity, group by the manufacturing order and insert it into the temp table. Then use a while loop to go thru each ID to compare with the user…
David Lai
  • 23
  • 3
2
votes
1 answer

Change due date for production order in SAP B1 with the DI SDK

I am trying to change/update the due date of a production order in SAP B1 with the code below: public static void ChangeDueDateForProductionOrder(SAPB1Credentials credentials, int poAbsEntry, DateTime dueDate) { …
rotgers
  • 1,992
  • 1
  • 15
  • 25
2
votes
1 answer

Move user defined field to the main form

Is it possible to move a user defined field (UDF) to the main form/window on a certain position ? If yes, can someone provide an example? For example I do not know how to get the field from the UDF window or how to get a reference of the UDF window.
V G
  • 18,822
  • 6
  • 51
  • 89
2
votes
3 answers

sql server comma delimted string values into one row

I have a query that returns a row of multiple Itemcodes. The result is Date group list of item code 2015-04-15 118 FYCT-00063,FYCM-00016,FYCM-00064,FYCF-00018 it's working fine but i need the result like this, with quotes…
2
votes
1 answer

SAP Business One: Connection Error When I try to connect to UI API

I got this error message "Connection - Could not find SBO that match the connection string [66000-85]" when I try to connect SAP Business One UI API. I connect like the following : private void SetApplication() { SAPbouiCOM.SboGuiApi…
RedsDevils
  • 1,413
  • 9
  • 26
  • 47
2
votes
0 answers

Can't get ActiveX WebBrowser to render in anything other than default without using registry key

I have a problem with an ActiveX webbrowser control, ProgID="shell.explorer.2" in a VB.Net addin development to work within SAP Business 1 running 32 bit on a 64 bit server. It's set to display pages from localhost:1234 which is an OWIN SelfHosted…
Mark Rabjohn
  • 1,643
  • 14
  • 30
2
votes
4 answers

Do breakpoints introduce delay?

How is that setting a breakpoint in my code allows the following code to complete which would fail otherwise. Here is the problem. I'm writing an add-on for SAP B1 and encountered following problem. When I load a form I would like to enter some…
kamilwydrzycki
  • 451
  • 2
  • 6
  • 16
2
votes
1 answer

Automated way of import MSSQL tables into SAP B1?

I am working with SQL Server 2008 & SAP Business One 9.0. I have ten sql server tables which have been imported into the SAP SQL Server database that I would like to add to the SAP Business One client as UDT, UDO & Business objects. I know I can do…
user2955856
  • 21
  • 1
  • 5
1
vote
1 answer

link between purchase order and AP reserve invoice

How do I get every AP reserve invoice for a purchase order using the SQL version of SAP Business One? My current query: SELECT OPOR.CardCode, OPOR.CardName, OPOR.U_ReferenceNo, OPOR.NumAtCard, OPOR.DocNum, OPOR.U_ShipmentTime, …
1
vote
2 answers

SAP B1 How to create approved document from approved draft via SDK

I've tried sample code like this; SAPbobsCOM.Documents oDocDraft = SAPbobsCOM.Documents)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oDrafts);
oDocDraft.GetByKey(docEntry);
oDocDraft.SaveDraftToDocument(); but this only creates regular…
Leotardo
  • 25
  • 4
1
vote
1 answer

B1ServiceLayer - get user behind SSO login

we are working in a CloudControlCenter environment. Now have to login with the SAP Business One SSO (Single Sign On) over Active Directory. So for example we do following requests: POST https://hana:50000/b1s/v1/Login { "UserName":…
Leotardo
  • 25
  • 4
1
vote
0 answers

Multi-level expand in SAP rest API Service Layer

I'm trying to get the Batches per ItemGroups. Is it possible to expand the ItemGroups in Item that is expanded from BatchNumberDetails? BatchNumberDetails?$expand=Item($expand=ItemGroups) What i want to achieve is like the code above. To expand…
1 2
3
33 34