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
0
votes
0 answers

Escape value in MSSQL Server with Java

How can I escape a value for usage in a query to MSSQL Server? I know how it would be possible using JDBC but since I'm using SAP Business One DI API there is no way (I'm aware of) of using prepared statements. It would be sufficient to know how to…
ooxi
  • 3,159
  • 2
  • 28
  • 41
0
votes
2 answers

SQL Help - Sales by State (SAP Business One)

Wondering if anyone can help me with a query that I'm trying to use to extract sales information from my database. I'm trying to build a report to show all sales by state. I have come across this code and while it is close to what I need it doesn't…
user3560648
  • 1
  • 2
0
votes
0 answers

SAP Client unable to access server "Internal Error 1102 131-183"

I've been trying for a few days to work out what's wrong with connecting to our SAP server from a workstation installed with a client. My setup: server: Win 2008 R2 SQL Server 2008 R2 SAP B1 8.82 PL 14 Workstation: Win 7 64bit SQL Native Client 2008…
JustAGuy
  • 5,151
  • 11
  • 41
  • 55
0
votes
1 answer

How I can SAP B1 to integrate to visual studio 2008?

I installed visual studio 2008. After I installed SAP B 1, but I do not integrate to visual studio 2008. How ı can integrate SAP B 1 in visual studio 2008 ? How I can SAP B1 AddOnInstaller.Net Wizard add to on Visual Studio 2008 like below picture…
Serdar
  • 17
  • 5
0
votes
2 answers

Create UDO in SAP Business one

i created UDO by using SDK in SAP Business one,but when i run the project i can't find the default form. any one help me what is the problem ? my code is : SAPbobsCOM.UserObjectsMD UDO =…
user3441072
  • 1
  • 1
  • 2
0
votes
1 answer

Display All BP info in a Gridview

I managed to connect to SAP B1 database using C# and SAP DI API version 9.00 and display ONE BP info. What I want to do is display all BPs or one BP info in a GridView. What I couldn't figure out is displaying all BPs/one BP info in a Gridview. In…
Sam
  • 406
  • 1
  • 11
  • 24
0
votes
2 answers

Need to learn how to use SQLCMD to export a query from SAP B1

I use SAP B1 at work and want to export a CSV file in a batch file so that I can schedule the export every 15 minutes to be uploaded to a website. This is what I have at the moment: SQLCMD -S SERVER-VMSQL -d SBO_COMPANYNAME -U sa -P adminpassword -Q…
Rick
  • 45
  • 7
0
votes
1 answer

Pivoting a table by month and year

Let's start with the query I already have, just for reference: /*Parameter Area*/ /*SELECT FROM [dbo].[OSRT] P0*/ declare @StartDate as datetime /* WHERE */ set @StartDate = /* P0.FromDate */ '[%0]' /*SELECT FROM [dbo].[OSRT] P1*/ declare @EndDate…
Brandyn Baryski
  • 3
  • 1
  • 3
0
votes
1 answer

Can SAP Business One Query a View?

I built a view on MSSQL Management Studio and then I have a query to reference that view. It works fine on Management Studio. However, it would appear that B1 cannot query a view. Is that true? If there is a way, how?
user3059028
  • 67
  • 7
0
votes
1 answer

Permanently add SAP Business One Studio for Microsoft Visual Studio add on to SAP Client menu

I am developing in SAP Business One Studio for Microsoft Visual Studio (VS2010) and whilst I am able to preview my forms (.b1f) files in the SAP Business One Client, I cannot permanently add them. On logging out of the SAP Business One client and…
user2955856
  • 21
  • 1
  • 5
0
votes
2 answers

SAP Business One I Query inventory base on user defined field

I am running a query on a product. I need a field that will look at the user defined field which contains another product and check that stock level. Any help would be great.
user2774184
  • 1
  • 2
0
votes
1 answer

Using EntityFramework with SAP Business One without losing warranty?

i'd like to know if someone is using EntityFramework with SAP Business One? If yes how do you handle the warranty. SAP only allows to Insert/Update/Delete through their DI Server API otherwise you lose the warranty. So if i am only allowed to select…
darkdog
  • 3,805
  • 7
  • 37
  • 47
0
votes
2 answers

SQL List and Sum together

I have a SQL query in SAP B1 that lists sales for the week. I also have a query that makes a Sum of those same sales. How do I combine the queries so that the result is all the rows of sales with the sum shown as a row below those rows? SQL List…
user2576487
  • 13
  • 1
  • 5
0
votes
1 answer

Could not find installable ISAM - Reading Excel Sheets through SAP B1

I am trying to read an Excel sheet (.csv) by opening a dialogue box from SAP business one. I have not tried this before and am receiving the following error when trying to read the excel sheet: private void GetFile() { using…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
0
votes
5 answers

More than one Case in same query are generating more than one row

My problem is actually I have multiple tables and I'm using two case statements to generate one column for ARV1 and one for ICA1, but I need the results are generated in the same row. When I usecase, generate the two columns but the values are…
Skatalitico
  • 37
  • 7
1 2 3
…
33 34