Questions tagged [sap-business-one-di-api]
74 questions
0
votes
0 answers
Connect to HANA database from docker container
I need to connect to SAP HANA database from docker container.
It's asp net core web api project
I added those lines to my dockerfile:
# Create hdbclient directory and copy hdbclient folder to the container
RUN mkdir -p /usr/sap/hdbclient
COPY…
Beqa Latsabidze
- 212
- 4
- 12
0
votes
1 answer
Is it possible to use a Crystal Report designed for one database on another without modifying the DB or fields?
i want to import one crystal report to another database like i have created a report for a database and i want to use it for another database(another client) is there any possiblity to do this without any changes in DB and fields. if does then…
irtaza malik
- 13
- 2
0
votes
1 answer
Which causes huge performance difference in C# & SAP DI API, when using SAPbobsCOM.Company "Local" and "External"
I use this code to load data from SAP DI (SQL Query) to a DataTable:
namespace SAPApp
{
class SAPData
{
public void GetSAPData(Company oCompany)
{
if (oCompany.Connected)
{
dt.TableName =…
0
votes
1 answer
Building a SAP Business One add-on using .NET >= 5 is officialy supported?
I cannot find any official document by SAP that states building a SAP Business One add-on using (both DI AND UI API) using .NET >= 5 is officially supported.
I've tryed building a .NET 7 test add-on and it seems to work.
But I don't know if it is…
Pao'lino
- 59
- 5
0
votes
1 answer
Getting Error code -1120 while creating table in the SAP B1
`Hello All,
I am trying to create a table in the SAP B1. But I am getting an error code "-1120".
For creating a table I have fetched a data from the json file.
And by using that data I tried to create the tables in the SAP B1.
But I am getting an…
CoolMaster
- 1
- 1
0
votes
2 answers
How to register SAP Business One DIAPI in AppService in Azure
I have an ASP.NET Core web API project that locally works fine with interop.SAPbobsCOM because I have in my machine all installed and registered but when I publish it in App Service in Azure I get this error
An unhandled exception was thrown by the…
kintela
- 1,283
- 1
- 14
- 32
0
votes
1 answer
Can I alter the code and name user fileds of an user table in SAP Business One
When you create a user table, the Code and Name fields are always created by default and I was wondering if I could eliminate the Name field and leave the Code field but as a primary key and of type int for example without this affecting subsequent…
kintela
- 1,283
- 1
- 14
- 32
0
votes
1 answer
Outgoing Payments with check payment primary form items via DI-API
I'm trying to add an OP with check payment with a primary form item but after saving the payment the chosen CFWid won't reflect in SAP but instead shows the default cash flow.
I have successfully added an OP with Bank Transfer Primary form items,…
riggs
- 25
- 3
0
votes
0 answers
stale dated Inventory - Sap Business one(B1) - 9.2
I have the below query working in SAP B1. but this caters age only from the last purchase date.
I want to have a report based on the date of purchase(and not the date of last purchased)
The Oitm table only gives the last purchased date.
Is there any…
shahzad
- 11
- 7
0
votes
1 answer
Error when I try to connect DI-API oCompany object to my database in SAP B1
I am trying to connect to a production database from a C# console project in .NET6 with VS 2022 using this piece of code
using SAPbobsCOM;
void InsertarActividad()
Company oCompany = new Company();
oCompany.Server = "IP_Server";
…
kintela
- 1,283
- 1
- 14
- 32
0
votes
1 answer
How do I catch the item event in SAP B1 after all elements on a form have loaded?
I am creating an addon in SAP Business One and I need to fill a matrix with data as soon as the form loads.
I have the following code:
private void Application_ItemEvent(string FormUID, ref SAPbouiCOM.ItemEvent pVal, out bool BubbleEvent)
{
…
Kinyanjui Kamau
- 1,890
- 10
- 55
- 95
0
votes
2 answers
How to discover Sap B1 service layer address and port
I am using a B1 client environment, and the support do not know the address for the service layer. Is there anywhere in the configuration where I can see server name and port so Ican user the service layer?
Geovane
- 31
- 2
0
votes
0 answers
500 Internal Server Error with Guzzlehttp in laravel
I am developing a project where I am saving master data to SAP Business One. I can receive the data locally and I want to send it to the handle with a button. When I click the button I get this error
codes as below
enter image description…
elisen
- 1
- 1
0
votes
0 answers
How can I display data in a datagridview in vb.net?
I am new here and in the world of programming. What I need to do is fill a datagridview from a query that I make through a method called "DoQuery", which is inside the "SAPbobsCOM" package. I would really appreciate if someone could help me with…
Alejandro Vecca
- 11
- 2
0
votes
1 answer
Substitute a common HANA sub-select with a Scalar Function?
We replaced an often used sub-select with a scalar function using SELECT INTO. The passed arguments make sure that the resultset always contains only a single integer:
CREATE FUNCTION MAT_AVAIL (DocEntry INT, LineNum INT)
RETURNS VAL INT
LANGUAGE…
boennhoff
- 1
- 3