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

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) / 2 million transactions...
Microsoft Dynamics GP (Archived)

2 million transactions for one customer is freezing GP

(0) ShareShare
ReportReport
Posted on by UriZ 65

We are in the process of migrating our data to GP. We loaded 2 million RM transactions to history for one customer. When you pull up that customer in Receivables Transaction Inquiry, it freezes. I would have expected GP to do a top 1000 or something. Are we doing something wrong by putting all our website orders under one customer?

*This post is locked for comments

  • Verified answer
    Craig Fuller Profile Picture
    Craig Fuller 411 on at

    UriZ, we had a similar issue after upgrading to Dynamics GP 2018. Sorry, I don't have any of the research links I previously found but know that the stored procedures that run when Receivables Transaction Inquiry (Document or Customer) is opened does not have a TOP limit on the transactions it pulls in so it pulls them ALL

    In our case it would hang the client for a couple minutes...and we have a VERY ROBUST server with over 3 million receivables transactions. I also read that this has already reported to Microsoft.

    There are at least two things to consider: The initial window opening and filter criteria.In our case I used Visual Studio to cancel the initial data pull when the window opens. This would also work for you, even with all transactions under a single customer. Secondly, I also force our users to make a filtered selection so they don't attempt retrieving all historical records. This could also work for you but since all are under a single customer, you may want to force a narrower date range or other tailored filter requirements to limit the records pulled at a time. For us, the window opens immediately and is ready for a range value to be entered. Our people are often just searching for a single document so this works fantastic.

    If you don't have a Visual Studio solution you may be able to use VBA. It has been too long since I looked at VBA to know if the procedures are available in that. I have attached a text file with my Visual Studio code as a starting point if that helps.

    ReceivablesTransactionInquiry.txt

  • Tim Wappat Profile Picture
    Tim Wappat 5,721 on at

    Yes GP2018 has performance issue bug around this. Check the latest hotfixes as I have the feeling it was addressed in one of them.

    Tim.

  • UriZ Profile Picture
    UriZ 65 on at

    Thank you Craig.

  • UriZ Profile Picture
    UriZ 65 on at

    We installed GP2018 in April of 2019. Is there a recent fix?

  • Community Member Profile Picture
    Community Member on at

    Thatnx for sharing

  • Community Member Profile Picture
    Community Member on at

    Medicare is our public health insurance system and funds a range of services such as GP visits, blood tests, X-rays and consultations with other medical specialists.  So that's why I recommend you to visit this website uk.edubirdie.com/essay-help where you can find professional essay helps.  The Medicare Benefits Schedule (MBS) lists the services the Australian government will provide a Medicare rebate for. Medicare rebates don’t cover the full cost of medical services and are typically paid as a percentage of the Medicare schedule fee.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans