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

SAP B1 9.1 Open sales order Quantity query

I need to have a query where i can see open sales order quantity (PO and In stock) but i need to see based on customer reference. i have a customer who many stores. and his order # joins a store #. so under every order there can be 100 stores at a…
shahzad
  • 11
  • 7
-1
votes
1 answer

Add-on connection timed out yet it's fully functional

I have an add-on programmed in c# for SAP B1. I created an installer and successfully registered it under SAP B1.But the problem is whenever I start the add-on in SAP B1, after sometime it says "add-on connection timed out". And in add-on manager…
Isuru
  • 430
  • 5
  • 21
-1
votes
1 answer

SQLCMD - removing timestamp from date & formatting fields to 2 decimal places

I am using SQLCMD to export out a SQL query from my server. One of the fields I am exporting is a date field - but when it is exported it has a time stamp as well - eg: 2015-12-15 00:00:00.000 How do I go about removing the timestamp from the date…
Rick
  • 45
  • 7
-1
votes
1 answer

Handle processes in c# update function

I'm an intern at a software company. I have an add-On programmed in c# for SAP B1. In this add-On i'm using my own update function due to some reasons(can't use clickOnce because of checksums in SAP). This update function is included in the main…
Isuru
  • 430
  • 5
  • 21
-1
votes
1 answer

Webi 4.x publication

I am working on BO 4.1. There is a webi report that has list of students, courses and instructors grouped by programs. The report needs to be published to the program directors. Since each program has one primary director I have made a publication…
Aaron
  • 29
  • 1
  • 2
  • 10
-1
votes
1 answer

SAP B1 determine ObjectType Code for table

I already create a User Table (name= ORN_TB1_VIDS) with single fields like (id,name,rented) so I'm trying to make a ChooseFromList to display my table (ORN_TB1_VIDS) but I don't know what is the correct ObjectType Code for my table . Could someone…
rr7
  • 163
  • 2
  • 12
-1
votes
1 answer

Undefined namespace prefix 'jbdc'

Hi guys, I'm trying create a webservice with SAP B1if whatching that tutorial: Part1: https://www.youtube.com/watch?v=N9hLVwJDEz4 In part 4 at minute 7:23 the guy wrote a part of xsl on document and he saved, when i go save i have next error:…
Agostinhob07
  • 87
  • 9
-1
votes
1 answer

What is a platform independent way to access SBO?

So, is there any direct way to do that (without using a proxy)?
Dawid Ohia
  • 16,129
  • 24
  • 81
  • 95
-1
votes
1 answer

How to duplicate one whole entry in SAP business one?

How can i Duplicate the whole entry as new Entry with next auto number.For example if form contains Trading number(4) and trading details(a,b,c). Trading details(a,b,c) should duplicate with new trading number(5). I searched in forum and got only…
Dhivya Thangavel
  • 39
  • 1
  • 9
-2
votes
1 answer

How to populate several item UDF fields into one header UDF field?

I have created 5 UDF fields in item master using SAP Business One as you can see in the below picture: Now I want to fetch those 5 UDF value in Bill of material (BOM)'s header level UDF field 'Drawing no' as you can see in the below picture: As of…
anamika Singh
  • 1
  • 1
-2
votes
1 answer

SAP B1 SDK - How can I execute a query and fill the result in a combo box

How can I execute a query using RecordSet from SAP B1 SDK and fill the result in comboBox in C# windows form application?? for example I want to do query in order to gather saved languages in OLNG table
Mead Alsorani
  • 41
  • 1
  • 12
-2
votes
1 answer

Display individual prices on each row

I am currently using MS SQL Studio 2017 and SAP B1. The table i am working with is called the ITM1 Table. Inside this table are the following fields... ItemCode, PriceListNo, and Price. Inside price list it is sequenced as follows... 1 2 3, 1 2 3, 1…
Andrew Gray
  • 47
  • 8
-2
votes
1 answer

Make SAP Business One C# code for MS SQL compatible with SAP HANA

I have the following code that is compatible with MS SQL. I use it to log errors using Log4Net. How do I make this compatible with SAP HANA, as in the correct syntax? string connectionString = @"Data Source=server;Initial Catalog=SBODemoUS;Persist…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
-2
votes
1 answer

Proforma Invoice for Sales Order

I have to design the Proforma Invoice by using the Crystal Report SAP B1 and If there are multiple line items in the sales order and we wanted to get the Proforma Invoice copy for a particular line item means how to generate that? Please assist me..…
Prati
  • 37
  • 1
  • 2
  • 8
-2
votes
2 answers

Application Fails to Log Off

I have an application and I am facing some serious problems. This application is preventing the user to log off. Each time when log off it crashed. How to log off properly? Any suggestions will be well received. Thanks.
A. Ne
  • 9
  • 1
1 2 3
…
33
34