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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Query Returned no Resu...
Microsoft Dynamics GP (Archived)

Query Returned no Results (Business Portal)

(0) ShareShare
ReportReport
Posted on by Jason Terry 40

I am having this problem inside the sales and the purchasing module.

Sales -> Payment by Customer.   Customer list comes up fine you select a customer and the "Customer Payments LIst" and "Customer Payment Detail" says Query retuned no results when I know there should be.   The really strange part is I have 1 or two customers I can click on and it works fine.   If I go to Documents by Customers no matter who I click on I get Query retuned no results. If you watch the screen you can see the little squares appear for a moment when it runs the query.

Purchasing -> Payments by Vendor.  I get the same thing Query retuned no results when I know it should.

Setup.  WSS 3.0 GP10 SP3 BP 4.0

I checked for bad querys and have not found any. 

I am guessing it is something to do with security but no matter what I do I can seem to get it to display.  I have tried it as a sales manager, Super User, and System Account.

Any help on this problem would be greatly appreciated.

 

*This post is locked for comments

I have the same question (0)
  • Jason Terry Profile Picture
    Jason Terry 40 on at

    So I have found part of the problem.  On the payments by customer is only displaying Payments that are open.  So the question is how can I get it to display open and history payments.

  • Jason Terry Profile Picture
    Jason Terry 40 on at

    I was able to sove this problem.

  • Michael Marinaro Profile Picture
    Michael Marinaro 9 on at

    I'm having the same problem. What ended up being your solution?

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    Michael,

    There are probably a couple options in this case.  The web part is tied to the Receivables Cash Receipt entity, so it's not showing historical items.  You could add a web part to the page that is tied to the Receivables Cash Receipt History entity, which would return the history records.  Another option may be adding a web part that is tied to the Receivables Credit Posted entity.  This may show more than you want though.

    Perhaps Jason could reply with his specific work around? 

    Thanks

    Rob

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans