Error: 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression' when running a receipt process

When running a receipt process, a user may receive Error: ' Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.'.  After that error they may receive Error:  Could not drop object 'dbo.RECEIPTINGCONSOLIDATEDOUTPUT_a850bae2_bcb3_4cc2_b0fa_5987ca2116b3' because it is referenced by a FOREIGN KEY constraint.'
We are currently evaluating this issue and will update this article when we have more information.

Work Around:
If your Receipt process uses a selection, add the below Filter Criteria to it:

'Needs Re-receipt is Equal to No'

Environment

 3.0.516.20

Was this article helpful?