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
2 answers

Select different fields than GROUP BY in SQL Server

I am trying to run a query in SQL Server where the columns I select are different than how it is grouped. This query is used in SAP Business One. The problem, is that if I group by all the same columns that are selected, nothing is grouped. Here is…
user2336671
  • 59
  • 1
  • 4
0
votes
2 answers

Sync Data between SAP and DataModels in Django

Now I'm developing an application under Django, it's an ERP for WareHouse Management. And the main application is made with SAP Bussiness One. I have access to tables in SAP (MSSQL Server), but I need build WareHouse Management using Table ITEMs in…
ManuParra
  • 1,471
  • 6
  • 18
  • 33
0
votes
1 answer

How To activate Menu in OK and UPDATE mode

I enabled some menu in right click event. The first time it works well. For example 'Add Row' menu is pressed, it adds row. Again I right click button, and it's not showing the menus which I enabled in right click event. I need to add row again and…
Dhivya Thangavel
  • 39
  • 1
  • 9
0
votes
1 answer

SAP Webservice error creating production order

I've got an issue with an application we are writting using the SAP business one web service. It was working ok with our test database, but when we have gone onto a test production database we have hit the issue. When we are adding a production…
beakersoft
  • 2,316
  • 6
  • 30
  • 40
0
votes
2 answers

SAP Business One Automatic Row numbering for Matrix

I am making an add-on for SAP B1 8.82. I would like automatic row numbering for my matrix column "#" i.e. UID "V_-1". Is there a feature in 8.82 that can help me do this? I am using UserDataSource for my matrix. How do I get to have row numbers that…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
0
votes
4 answers

Is there an ABAP Workbench in SAP Business One 2007?

Here comes a simple question but hard to find its answer. Is there an ABAP Workbench (also known by the transaction code SE80 in SAP R/3) in SAP Business One 2007? The workbench should be open and not just for SAP use. I would like to know if it's…
fabiopagoti
  • 1,467
  • 14
  • 31
0
votes
2 answers

SQL Select from 3 tables with sum

I am using Microsoft SQL Server 2008 R2. I want to join 3 tables and then group them by period (months) and get the sum of all amounts for each period and maximum exchange rate. I have this SQL statement below. SELECT T2.Name AS Period, T1.LineTotal…
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
0
votes
1 answer

Custom status bar suppressed by SAP's default status bar

Am trying to find items based on item name.If items are present status bar stating "Item Found" is displayed else Item not found is diplayed.My problem is the status bar does not stay .its is overridden by SAP's default status bar operation…
Karthik
  • 2,391
  • 6
  • 34
  • 65
-1
votes
2 answers

SAP B1 Integration framework XPATH to read webservice XML response

I have a B1IF package which call a webservice to export some data from B1 When I call this webservices I get an XML as response, but I can't read it. This is what I get from the webservice
Nicola Bazzani
  • 11
  • 1
-1
votes
1 answer

Upgrade of SAP B1 from version 9.2 PL 07 to 10.0 PL 02

I'm encountering the following problem. When upgrading SAP B1 database from 9.2 PL 07 version to 10.0 PL 02 version (on MS SQL) i get an error -5002 - internal error, on Dashboard Packages object. Does anyone had a similar case? Maybe someone knows…
sanctus
  • 17
  • 8
-1
votes
1 answer

Dynamic SQL with Subquery returning more than 4000 characters

I'm trying to create a dynamic query that retrieves the columns of a table (as new columns might be added in the future) and this query might also be used on multiple databases with different table configurations. The purpose right now is to compare…
Chester van Ree
  • 105
  • 8
-1
votes
1 answer

SAP Crystal Report Cannot edit Command

Please help me how to edit command in SAP Crystal report. When I open Database Expert and rigt click the Command, its show Rename and Properties, not show Edit Command or View Command.
user3703510
  • 3
  • 4
-1
votes
1 answer

Stock transfer using sapb1 jco getting error

Following is my code to do a warehouse movement in SAPB1. According to the documentation I should use the object 67(SBOCOMConstants.BoObjectTypes_oStockTransfer) to get the Stock transfer object. But when I use it I am getting the following error.…
arjuncc
  • 3,227
  • 5
  • 42
  • 77
-1
votes
1 answer

How to set value in date UDF using SAP B1 JCO?

I am able to set String value to UDF using JCO like below. invoice.getLines().getUserFields().getFields().item(java.lang.Object aIndex).setValue(java.lang.Object aValue) But it is not working for date type UDF like (Purchase date, Payment Date). Is…
Anup Ganatra
  • 366
  • 1
  • 6
  • 23
-1
votes
1 answer

Warehouse Stocks in Horizontal format/Layout

Below mentioned query produces attached results but I want to translate stocks on warehouse code wise in horizontal layout: SELECT T0.[ItemCode], T0.[ItemName], T1.[OnHand], T1.[WhsCode] FROM OITM T0 INNER…
shahzad
  • 11
  • 7
1 2 3
…
33 34