Dynamics Community Forum Thread Details

Subquery returned more than 1 value

I'm having no luck in finding out the root cause of a challenge.

Payables Batch Entry and the printing of an edit list.

This is a new company (client has just gone 'live') and when we go to run the edit list on the open AP, GP2013R2 throws the following error.

The company was created a couple weeks ago, using PSTL.

I've checklinked the setups and nothing seems to resolve.

I went through the PM40100 and 1 record exists (although it does have a dex_row_id = 2, which I thought was odd).

I can go into the test company and it works like a champ. I've tried separate batches and the error persists.

Any and all suggestions are appreciated.

Thanks,

Jon

I do remember such an error in the payable management module in GP 2013, which was mostly resolved with 2013 Service Pack 2. Here is the hotfix reference

81827.1.png

Although, I can see that you are on GO 2013 R2, right ?

If you are quite sure that there is no customized SQL codes running on the database level of your Dynamics GP, which can be apparently tracked using the SQL Profiler, you may try the clear data utility for the payables (since you have no transactions), don't include the master tables and then proceed with trying to print an edit list report. Does it solve the issue ?

Furthermore, you may try to take a backup of this current company into a test environment and upgrade to the most release (2015 R2), is it possible ?

Your feedback is highly appreciated,

Quick Links