web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Subquery returned more than 1 value

(0) ShareShare
ReportReport
Posted on by

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.

bcd.jpg

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

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans