Posts

Showing posts from July, 2011

Automating the start and stop of Microsoft Dynamics GP logs with the Support Debugging Tool - Part 2

Image
Yesterday, we tackled the first part of this Support Debugging Tool project, showing how to implement the logging trigger portion. To recap, the application logging files (DEXSQL.LOG and Dexterity Script Log) will begin to record when the Hold checkbox on the Vendor Maintenance window is marked. However, registering the logging trigger will only occur when the Vendor Maintenance form is opened, and unregister, when the Vendor Maintenance form is closed. This will provide an effective set of actions to be recorded as opposed to logging every single action that occurs within the application. Now that we have implemented the logging portion, we need the two non-logging triggers: the trigger that will start the logging trigger, and the one that will stop it. The Start Trigger We will start by setting up the non-logging trigger that will activate the VEND_HOLD_CHG logging trigger (which in turn will begin logging only when the Hold checkbox is marked). We will want to attach this tri

Automating the start and stop of Microsoft Dynamics GP logs with the Support Debugging Tool - Part 1

Image
If you haven't noticed, it is - unofficially, of course - Support Debugging Tool week. With the fairly recent release of build 15  and a revision of that build , the tool has just gotten better with heaps of new features and improvements over existing ones! And I am exploring some really cool stuff that can be done with the product. Yesterday I showed how you can use the Automatic Debugger Mode's non-logging trigger capabilities to Default "Include Totals and Deposits" in the Sales Transfer Entry  window Today, I will touch on the topic of Automatic Debugger Mode and non-logging triggers again. However, this time I will show how you can use non-logging triggers in combination with logging triggers to capture vital application logs upon the occurrence of some Microsoft Dynamics GP application event without user intervention. This may sound a little esoteric, but the concept is simple. For this example we will use the Vendor Maintenance window, a very familiar win

Defaulting "Include Totals and Deposits" in Sales Transfer Entry with the Support Debugging Tool

Image
More times than I care to count I have been called in to fix records left behind because the Include Totals and Deposits option was not marked when transferring a sales document from an existing order to an invoice. The problem is, it is so easy to forget to mark that box if you are doing this for hundreds of transactions fractured in multiple batches, especially at the end of the week when invoices need to be submitted to customers, prior to the FedEx truck arriving at 4:00 PM. Sales Transfer Documents window While this "fix" has been provided as a Modifier with VBA project before, I thought, why not really prop this up a bit with a Support Debugging Tool non-logging trigger and take advantage of the Automatic Debugger Mode functionality? Well, I have done just that! The first thing we need to do is setup the trigger itself. In this case, we want to select a Focus Event trigger that will fire exactly on a field change condition. The field in question is the '(

Reconciling unchanged bank statements

Image
Just recently, I worked on a case with a partner, whose client had a checkbook setup. For the past serveral months, the bank account associated to the checkbook has had no transaction activity. The client still receives a bank statement each month with no transactions. When the client would try to enter the cutoff date information into the Reconcile Bank Statment window, even though the difference is zero, the system is not letting them reconcile the statement. Reconcile Bank Statement window They keep receiving a message that they need to mark the items they want to clear. Select Bank Transctions window - error when attempting to reconcile As a result of not being able to complete the reconcile, the Last Reconciled Date field is not being updated on the Checkbook Maintenance window. Checkbook Maintenance window To overcome this issue, we had the client enter both an interest income and an other expense adjustment for a penny ($0.01), as shown below: Reconc

SSRS: The deployment has exceeded the maximum request length allowed by the target server

Image
Earlier today, I was deploying SQL Server Reporting Services (SSRS) reports for a client who just upgraded from version 9 to version 2010 R2 on Microsoft SQL Server 2008 R2. Upon beginning the deployment, the following error came up: maxRequestLength error deploying BI reports The error and it's resolution are pretty clear and called for setting the maxRequestLength attribute to "20690" in SSRS's  web.config file. Web.config The SSRS web.config file can typically be found under the %programfiles%\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Report Server, for a Microsoft SQL Server 2008 R2 SSRS installtion done in Native mode. If you have other types of deployments, for example, SharePoint integrated, it will be necessary to consult with your system administrator. You can then proceed to use Visual Studio or, simply, Notepad to edit the web.config file, locating the httpRuntime element of the XML document. web.config - httpRunti

SmartList Builder and creating Calculated Fields with Extender data

Image
Just recently, I ran into a case where the partner was creating a SmartList Builder calculated field using data from the  RM Open table (RM20101) via an Left Join table operation with the Extender Window Field Numbers . In fact, this is a very typical scenario for a lot of deployments where Extender is used, especially when you cannot use the standard Extender functionality to integrate with out-of-the-box smartlists. The original SLB calculated field look something like this: Extender Calculated Field When the SLB smartlist was deployed, a number of results came back as zero for the records where there was no entry in the Extender Window Field Numbers table, even when the Sales Amount and Current Trx Amount fields had a value in the RM Open File table. Paying a bit more attention to the issue made me think of how LEFT OUTER JOINs are processed by the Microsoft SQL Server query engine. This is best illustrated with the following example: RM Open Extender

Microsoft's upcoming products available for download

Image
A bit away from the Microsoft Dynamics GP world, but at the same time so close, here are some very good news on the upcoming release of Microsoft SQL Server "Denali", Office 2010 and SharePoint, and Internet Explorer. Download SQL Server Code Name "Denali" CTP3 SQL Server Code Name "Denali" Community Technology Preview (CTP3) provides the foundation for the cloud-ready information platform, and will help customers unlock insights across the organization and quickly build solutions that extend data across on-premises and public cloud. Office 2010 and SharePoint 2010 Service Pack 1 Now Available Service Pack 1 is now available for the 2010 family of products, including Office, SharePoint, Project Server, FAST, Search Server, and Groove Server. For more on deployment, see these articles: Apply Office 2010 Service Pack 1 and Deploy Service Pack 1 for Project Server 2010 . Also, download the Service Pack 1 for SharePoint Foundation 2010

SSRS: GL Trial Balance Summary report returns no data

Image
This one comes courtesy of my friend Steve Sieber at McGladrey . After installing Microsoft Dynamics GP 2010 R2 and deploying the SQL Server Reporting Services reports, you will encounter an issue when printing the GL Trial Balance Summary SRS report located under Financial. 1. Launch Report Manager and click on the company for which you would like to run the report (the issue can also be reproduced in the Fabrikam (TWO) company database). Click on Financial | Trial Balance Summary, enter all the parameters and options for the report the click on View Report , the following is returned: GL Trial Balance Summary - SSRS As you can see, even though the correct parameters are selected, the report returns no records. 2. If the GL Trial Balance Summary report is executed from GP with the same parameters, the report correctly delivers the expected records and result: GL Trial Balance Summary - GP From a technical perspective, the GL Trial Balance Summary SSRS report executes

More Microsoft Dynamics GP Word Templates Articles

Image
If you have been keeping up with this blog, you will remember that sometimes around October of 2010 I posted a series of articles related to Microsoft Dynamics GP Word Templates - see Microsoft Dynamics GP 2010 Word Templates summary for more information. These articles focused on "how to's" and troubleshooting aspects of Word Templates. Now the Dynamics Support and Services Team Blog has decided to launch a new set of video-articles detailing more common aspects of working with Word Templates. You can now visit the Community Team blog for the release article  and the schedule of when these videos will be out. The good news is the first two are out! Take a look at: Adding the Developer tab in Microsoft Word after installing the Microsoft Dynamics GP Add-in for Microsoft Word - Video Helpful tips when modifying Word Templates in Microsoft Dynamics GP 2010 - Video Please visit the Dynamics GP Support and Services Blog  for these videos and to find a collec

Violation of PRIMARY KEY constraint 'PKSY60100'

Image
Just recently, I assisted a partner with an issue they were having creating a new company in Microsoft Dynamics GP 10 - though, I supposed the same could happen with any other version. In the process of creating the company record, almost at the end of all the routines executed by Dynamics Utilities they were getting the error: Violation of PRIMARY KEY constraint 'PKSY60100'. Cannot insert duplicate key in object 'dbo.SY60100' KB Article 871699  suggests the problem could be that the DYNAMICS database is associated with a database owner (dbo) other than DYNSA. After running the sp_helpdb system stored procedure, it was determined that the database owner of the DYNAMICS database (and other company databases) was indeed 'sa'. Knowing this obviously helps, and the solution is as simple as changing the database owner back to DYNSA. The partner then ran the sp_changedbowner system stored procedure to reset the database owner to DYNSA and got the following er