Manufacturing: 'Subquery returned more than 1 value. This is not permitted when the subquery follows' error manufacturing

When you are manufacturing an Item on the Fly on invoice printing the following error may be displayed:

This was logged as a defect on IS-14530

Please note it’s recommended that this issue should preferably be handled and fixed by a professional Evolution support consultant.

This is due to the solution requiring an understanding on how to run SQL scripts in the comapny database to correct the above problem.

Therefore, please contact either your Evolution business partner (BP) or Evolution Support to get this issue resolved.

Apply the following steps:

1. Backup the company and ensurea ll users are logged out of it.

2. Run the following SQL script on the comapny database: 

The solution will be to run the script 

alter FUNCTION [dbo].[_efnGetBomComp]( 

  @StockID int, 

  @MFPID int) 

RETURNS TABLE 

AS 

RETURN 

( 

SELECT st.Code,st.SerialItem,bm.bShowComponentsOnGRV, bm.bShowAvailAllLevels, bm.bShowCompOnInv, bc.*, idManufProcessLine = 0, iAttributeGroupID = 0

FROM bomcomp bc

left join bommast bm on bm.bomid = bc.bommasterkey

left join stkitem st on bc.componentstocklink = st.stocklink

WHERE (bm.bomstocklink = @StockID)

)