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

Calculated query with parameters in HANA/CrystalReports

I'm having trouble trying to explain my necessity, so I'll describe the scenario. Scenario: Product A has a maximum production of 125KG at a time. The operator received a production order of 1027,5KG of product A. The operator have to calculate…
Romulomsn
  • 13
  • 2
1
vote
1 answer

HANA DB : How to use CONCAT syntax more than 2 fields

I'm using query in HANA Studio , It's work CASE WHEN T0."U_XXX_SalEmp2" is not null THEN CONCAT (T7."SlpName",CONCAT ('+',T0."U_XXX_SalEmp2")) ELSE T7."SlpName" END AS"Sales Emp", But I want to CONCAT more fields **For Example :** CASE WHEN…
Anubise
  • 13
  • 1
  • 5
1
vote
2 answers

Sending Batch REST requests to SAP Business One Service Layer using RestSharp

I am trying to use SAP Business One Service Layer batch in order to achieve REST transactions. For a start, before dealing with actual data modification requests, I want to create a simple post to get two Business Partners in the same request. I…
davidthegrey
  • 1,205
  • 2
  • 14
  • 23
1
vote
0 answers

pywintypes giving Class not registered error while key exist

I have a script where I am trying to load a COM object in Python. import win32com.client.CLSIDToClass, pythoncom, pywintypes import win32com.client.util from pywintypes import IID from win32com.client import Dispatch CLSID =…
Meraj Rasool
  • 651
  • 2
  • 12
  • 23
1
vote
2 answers

Cannot save some fields like 'Telephone', 'Email', 'Tax',.. of Sales Employee using DI API

I want to add (or update) sale employee (database table: OSLP) using DI API. The object to use is SalesPerson, but in its public properties I dont see 'Telephone', 'Mobile', 'Fax',... I just added successfully a record without these properties, it…
NULL
  • 13
  • 1
  • 4
1
vote
4 answers

SAPB1 and django integration

im working on a new project where by i wish to be able to build a django project around an existing SAPB1 application that is in production. My goal of doing so is to be able to extract certain information from SAP database and sync them with my…
neowenshun
  • 860
  • 1
  • 7
  • 21
1
vote
1 answer

A solution for a join to get all the data that is not in the main query based on a field from the main query

So I have the below case in crystal reports Main Report which has a query that shows the batch details of an invoice Sub-report which shows the details of the batches included in the main report but are not included in that document. So for…
1
vote
1 answer

Crystal Reports page numbering

I am using CR to create a catalogue from multiple sales quotes. I will print these multiple quotes into a binder as a sales catalogue. My issue is that the page numbering needs to start at a different value based upon the quote's final place in the…
1
vote
3 answers

How to format date in where?

I have this script: select * from OPDN A where A."DocDate" between '2020/01/01' and '2020/01/31' How to achieve the format "MM/DD/YYYY" in the WHERE clause? select * from OPDN A where A."DocDate" between '01/01/2020' and '01/31/2020' The column…
Carlo Angeles
  • 29
  • 1
  • 4
1
vote
1 answer

Crystal Report text functions

i'm using ItemName field in a Crystal Report. The field contains the item name and dimensions: - Egg Pot & Saucer 47x41cm I wish to suppress the dimension details, leaving just the text part of the string. I'm looking for a set of functions that…
1
vote
1 answer

Handling a event in different instances of a class separately using an indexed singleton

I'm working with the following singleton classes: FormA, FormB and ShareFormDataEvent. When I click in a button on FormA, a instance of FormB is created. On the InitializeMethod of FormB, I subscribe to a ShareDataEvent that is declared in…
1
vote
1 answer

How to Stop SAP B1 Form_Data_Add event if some criteria is not matching in Code ,not by the Validation Sql Query

When I am adding a Sales Order, I have a method For VAT checking. The method returns data in bool. If the bool value is False the Form_DATA_Add the event should not work further it should stop the adding process.
user9273506
1
vote
1 answer

How to open SAP Business One Report Viewer Using c#

I am creating an add on which will open a Crystal Report from BP Master, there will be a button which will open that. But i am not be able to call the default SAP B1 Report viewrr . Can anybody sugest me that ?
user9273506
1
vote
1 answer

SAP Business One Add BP Campaign Using C#

I want to generate a campaign of Business Partner in SAP B1 using DIAPI. Can anyone helpme with this.
user9273506
1
vote
1 answer

Unable to handle a button click event in SAP B1 UI API

I'm starting with SAP B1 UI API (9.0) and I'm trying to handle a button click without any luck so far. This is how I'm doing it (removing unnecessary to make it shorter): static void Main(string[] args) { SetApplication(args); var cParams =…
dcg
  • 4,187
  • 1
  • 18
  • 32