Dynamics Community Forum Thread Details

PSTL Item Combiner error - subquery returned more than one value

Hi -

I'm struggling with an error that I've gotten on a few items we're trying to combine in one of our companies. Most of the items combined without an issue, but on four of them I'm getting the following error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.

Clicking OK from there, I get the stored proc error from TACallItemCombine and it returned the following results:

DBMS: 512, Microsoft Dynamics GP: 0

After that, the reconcile tool locks up the company that I was trying to combine in and I have to remove the login through the SY00800 table.

Going through what few other threads are out there, there are no foreign characters in the item number or item descriptions (alpha numeric only), and I'm not sure where to go to figure out where the error is taking place. Since the stored proc is encrypted, I can't view the definition to figure out where it might be failing, too.

Any ideas what might be going on or how to fix this? Most worked, just four items aren't. There's nothing that I can find that would signify a difference between those that worked and those that did not to cause the error.

Thanks!

Quick Links