SAP B1 Goods Return multiple lines error

[ErickNjrz]

hi,

in SAP B1 we need to capture a goods return with multiple line, sap is giving the following error

"[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 'Company Info' (CINF) (CINF)"

when we capture 1 line is OK, but the issue is for multiple lines

I have tried filling every field in the screen with the same result

hope you can help

thanks

[jitin_chawla]

Hi,

Along with the additional code in stored procedure, you can also check for any Formatted Search (FMS) on the window.

Kr,

Jitin

[hdolenec]

Does this happen when you click on Add button? If so, I would say the problem is somewhere in stored procedures TRANSACTIONNOTIFICATION or POSTTRANSACTIONNOTICE.

There is a code somewhere that contains a subquery whick returns more that 1 result per row (probably selecting document lines somehow). So it's working fine when you have a single line, but starts giving errors when you have more that one.

[ErickNjrz]

yes, is when I click the add button, checking the error is there is a table called CINF? a field that is called Company Info?

[hdolenec]

Yes, but I don't think that this table is a problem. You can try SELECT * FROM CINF, if you get only one result it's probably fine. More likely the problem is subquery somewhere in stored procedre, it just manifests as an error in CINF.

[ErickNjrz]

hi thanks for the response will check the stored procedures