Skip to Content
0
Jan 21, 2023 at 07:52 AM

Calling Store from SQL query in SAP Business One Application

76 Views

I am executing the following query to execute the Stored procedure but getting error, please help me out to execute from date and to date input

CALL WMS_DELIVERED_SALES_SALESMAN_WISE((SELECT TOP 1 T0."DocDate" from OINV T0 where T0."DocDate" ='[%0]'),(SELECT T1."DocDate" from OINV T1 where T1."DocDate" ='[%1]'),(Select T2."BPLName" from OBPL T2 where T2."BPLName" ='[%2]'),(Select T3."SlpName" from OSLP T3 where T3."SlpName" ='[%3]'));

Error

1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;305 single-row query returns more than one row: 'User-Defined Values' (CSHS) (at pos 137)