Questions tagged [sapb1]
SAP Business One (B1) is enterprise resource planning (ERP) software designed for small and medium-sized enterprises, manufactured by SAP SE.
sapb1
526
questions
0
votes
1
answer
26
views
Where is the SAP UI API Samples Code Located
Does anyone know where I can find the SAP UI API samples code? I have installed the SAP Business One Studio (1000.00.170), but I can't find the path for the samples code. I also tried searching on the ...
1
vote
1
answer
31
views
UDO form can still be edited after Close
I have registered a UDO with a SAP B1 form with both Closed and Cancel services.
I close one form and the "Status" fields reads 'C' for that particular DocEntry.
When I open that form again, ...
0
votes
0
answers
20
views
Integrating SAP Business One 9.3 with Ariba using Make (Integromat)
I'm working on integrating SAP Business One 9.3 with Ariba using Make (formerly Integromat) and I'm running into some issues. I would greatly appreciate any guidance or examples from those who have ...
0
votes
0
answers
35
views
How to capture the event of a user pressing Ctrl+A to clear a SAP B1 form's fields
I am trying to capture the event of a user pressing Ctrl+A to clear a SAP Business One form's fields when that form is in focus/active.
I have tried the below but it is not catching the event.
if (...
0
votes
0
answers
53
views
BadFormat SAP B1 API Service Layer
I try to post a new attachment in SAP B1 trought SAP B1 Service Layer in the endpoint /Attachment2, this request made it by python but i Get this message:
Code Status: 400
Error uploading file: {
&...
0
votes
0
answers
40
views
SAPB1if (SAP Business One Integration Framework) B1Object atom is not updating anything on SAPB1, what am I missing?
I have a step in the B1if that is supposed, at a certain point, to update a SalesQuotation (object 23) filling the NumAtCard field in the header. It should just do that, given a DocEntry I fetched ...
0
votes
1
answer
40
views
Why in SAP B1 when I cancel a Purchase Order the Purchase Request is cancelled?
your support, how to cancel the Purchase Order without canceling the Purchase Request, SAP B1 version is 10.0
Purchase Order and
Purchase Request
0
votes
0
answers
30
views
Error While Running Addon I Created in SAP B1
I created a simple SAP addon to add an extra tab on the sales order document:
program.cs
using SAPbouiCOM.Framework;
using System;
using System.Collections.Generic;
namespace SBOAddonProject3
{
...
0
votes
0
answers
67
views
Automate [Inventory Valuation Simulation Report] in SAP Business One
Without using DI API, I want to achieve the automation of [Inventory Valuation Simulation Report] in SAP Business One 9.3 SQL version, where I can run it for specific items list in a sub SELECT ...
0
votes
1
answer
50
views
SAP B1 DiAPI does not load
We had to reinstall our System and I we need to run our old PowerShell scripts. However, it seems like PowerShell does not load the DiAPI correctly.
[System.Reflection.Assembly]::LoadFile("C:\...
0
votes
1
answer
52
views
How to remove duplicates in one column
The Receipt Qty column is showing duplicated, how to remove duplicates?
select DISTINCT T1."ItemCode" ,T1."ItemName",T2."WhsCode",
(Select IFNULL((Sum("InQty"-&...
0
votes
1
answer
62
views
How to exclude cancelled good receipt P.O
I want to exclude all cancelled good receipt P.O and incorporate in this below query. The InQTY is showing all the cancelled GRPO as well.
/*select T0."DocDate" from OINM T0 where T0."...
0
votes
1
answer
121
views
Golden Arrow Drill Down for A/R Invoice SAP B1
Upon adding a picture for the golden arrow in the last document number column, I wanted it to link to the A/R invoice of the specified Document number
I created the link however I feel like probably ...
0
votes
0
answers
49
views
Error with Opening Balances Internal Reconciliation SAP BusinessOne
Experiencing a challenge with an internal reconciliation function in SAP Business One, specifically when dealing with opening balances. The function below works well generally but throws an error when ...
0
votes
2
answers
78
views
Item is duplicating because of a text line in crystal reports
Item is duplicating because of a text line in crystal reports. If i remove the details section for the text lines, the items details dont duplicate. How many I resolve this.
Below is the structure of ...