Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

2 million transactions for one customer is freezing GP

Posted on by 55

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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 2 million transactions for one customer is freezing GP

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 2 million transactions for one customer is freezing GP

    Thatnx for sharing

  • UriZ Profile Picture
    UriZ 55 on at
    RE: 2 million transactions for one customer is freezing GP

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

  • UriZ Profile Picture
    UriZ 55 on at
    RE: 2 million transactions for one customer is freezing GP

    Thank you Craig.

  • Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: 2 million transactions for one customer is freezing GP

    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.

  • Verified answer
    Craig Fuller Profile Picture
    Craig Fuller 409 on at
    RE: 2 million transactions for one customer is freezing GP

    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

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans