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: