Announcements
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
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.
Thatnx for sharing
We installed GP2018 in April of 2019. Is there a recent fix?
Thank you Craig.
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, 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.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156