Tag: sql
Understanding Support Debugging Tool Logging Modes
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.
Dynamics GP SOP line items with serial numbers and comments
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 .
Microsoft SQL Server 2012 – Performance Dashboard Reports
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
Cashbook Bank Transfer Error: Date entered is not a current period for checkbook Checkbook ID
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.
Finding resources
Almost on a daily basis I find myself looking for things like system requirements, end of support dates, build numbers and downloads for the various products that I work with.
How to format Microsoft Dynamics GP SQL Stored Procedures
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
Fiscal Year Start Date & End Date – SQL Query
I am currently working on custom SSRS dashboards performance tuning and related exercises. One task among all is to automate the Fiscal Year Start Date and Fiscal Year End Date based on which Fiscal Year we are in.
Loading ...