This is the first in a series of articles that are designed to help you understand how the Support Debugging Tool works and how you can leverage its different features. In the past, I have described features without explaining how these features can be used and what the differences between different modes is. With this series I hope to remedy that situation.
Based on some reader requests, this new view is a combination of my All SOP Line Items view and the recently posted script showing how to get a concatenated list of serial numbers in SQL .
In March 2012 (precisely 6th March 2012), Microsoft made available SQL Server 2012 Performance Dashboard Reports which can be used to identify whether there is a current bottleneck on the system, and if so, capture additional diagnostic data that may be required to resolve it. More information on this can be read from the download page: Microsoft SQL Server 2012 Performance Dashboard Reports . One point worth to be highlighted is that this doesn’t require Reporting Services to be installed
This was a menace for the past 4 days, to say the least. I was reported of this issue, where a user when trying to enter a bank transfer for a checkbook, on a date in previous month, he got this error message (in the title of this post) as shown below: The above message occurred only for one particular checkbook and not for others. First step was to ensure the fiscal period was not closed.
Have you ever decided to have a look at one of the SQL stored procedures in your Dynamics GP databases? If you have, you would have noticed that they are extremely difficult to read. This is because comments and formatting white space are removed by Dynamics Utilities when it creates the stored procedures