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

SAP B1 - Service Layer on-premise availability

Related at this question SAP Business One - > Rest API for embedded incident, I'd like to know if Service Layer (REST API in OData format) is available both on-premise and cloud solution. From many different documents I've already seen it's not…
bit
  • 934
  • 1
  • 11
  • 32
1
vote
1 answer

Find differences between two strings in SQL

I want to find the difference between two strings and string manipulation isn't my strong suit. I have the following code. SELECT T0.[Code], T0.[U_CardCode], T1.CardName, T0.[U_Subj], CASE WHEN T0.[U_SubStatus] = 'o' THEN 'Open' ELSE 'Closed'…
Nick Jones
  • 93
  • 8
1
vote
1 answer

SAP B1 DI-API replaces character on save

I wrote a small c# service importing tracking numbers to a single UDF separated by a , character (comma). The problem is that occasionally (maybe every 200th document) a comma is saved as a semi-colon. A kind of similar issue I have is with the…
Phil
  • 135
  • 9
1
vote
1 answer

Count character groups in string with semi colons

Had a bit of a search but couldnt find an answer to this problem. String manipulation is not my strong suit. I have the following example string. 7849;7985;8044;8253;8254;16733 I need to count the number of 'Ids' in the string. Using the above…
Nick Jones
  • 93
  • 8
1
vote
2 answers

B1 query | Monthly sales consolidated for different time periods (i.e. 1 / 3 / 6 / 12 months)

really struggling with this one. Looking for a way to query sale volumes for different time spans all put into one table. Let's assume it is Aug 13th. I then want summed up sales volumes for: Jul 1st 00:00:00 - July 31st 11:59:59 (last 1…
little_endian
  • 69
  • 8
1
vote
1 answer

How do I add a selection icon in SAP B1 Crystal Report Parameter Field

I have created a Crystal Report that will be added in SAP B1. This has two parameter fields @ItemCodeFrom and @ItemCodeTo. The Crystal Report will pass the parameter values to a store procedure. At the moment the parameter fields are static- you…
Jaime Dolor jr.
  • 897
  • 1
  • 11
  • 28
1
vote
1 answer

Attach user form to UDF which is created in system form

I'm learning sap b1. I have created a field in marketing document. When I enter any value in this field and press on tab button, my user defined form should be open with the data from OITM table and find textbox and highlight the record with value…
neha
  • 23
  • 3
1
vote
1 answer

Still getting NULL value for column in SQL pivot table

Bit stumped on this one. In my below query it outputs fine except one month where for one of the item groups there was no invoices for that month. As such, its outputting a blank field which in turn is not giving me a grand total for that…
Nick Jones
  • 93
  • 8
1
vote
0 answers

How to catch find button event & apply condition after record search?

I have used a following code for navigation of records in sales order. if (pVal.MenuUID == "1291") //Last Data Record { Application.SBO_Application.MessageBox("Last"); SAPbouiCOM.Conditions conditions = new…
neha
  • 23
  • 3
1
vote
1 answer

SAP B1 Service Layer Login POST request gives error code -304 with an empty message

I'm trying to reach SAP Business One Service Layer APU via PostMan and Python (with requests module). However, when I try to POST to /Login endpoint to our Service Layer it gives me the following JSON result: { "error": { "code": -304, "message": {…
neisor
  • 384
  • 4
  • 15
1
vote
1 answer

unique join entries sap b1 query

Quick query I need a hand with, a should know how to do this but im drawing a mental blank. I have the following query which shows the right equipment cards for all the customers EXCEPT those that have 2 x subscriptions from the @SWA_CT_SUBSCR…
Nick Jones
  • 93
  • 8
1
vote
1 answer

Expected END found B1 Validation Configuration

This is probably something simple but I can't see the answer. I am using b1 usability package and trying to set validation configuration on a field to provide the value the query spits out. I've run the query in query generator in SAP B1 with no…
Nick Jones
  • 93
  • 8
1
vote
2 answers

How can code User input parameter from first date to last date (SQL query manager)

I need help, I write the code and have to use The Last Date from user parameter >> [%1] in statement but when I execute ..the filled window force me fill from the last date to first date. It should be fill from the first date to last date. when I…
Kieng
  • 17
  • 6
1
vote
1 answer

Crystal Reports not showing SAP b1 query

I have the following query; SELECT TOP 1 T0.custmrName, T0.callID, T0.BpShipAddr, T1.Name, T0.createDate, T0.subject, T0.manufSN, T0.internalSN, T0.itemCode, T0.itemName, CAST(T0."resolution" AS varchar(MAX)), T5.DocNum, T7.DocNum AS…
Nick Jones
  • 93
  • 8
1
vote
3 answers

XSLT for-each, trying to create header-line structure

This is not the browser type XSLT, this is for processing data (SAP B1 Integration Framework). Suppose we have two SQL Tables, HEADER and LINE and we want to avoid the kind of work where we first SELECT from the HEADER and then launch a separate…
Elek Szid
  • 13
  • 2
1 2 3
…
33 34