ATTENTION: Fix for Issue – SmartConnect Excel Templates Stop Working after Applying Microsoft Updates from 12/9/2014
We wanted to bring to your attention a solution for a recent issue where our SmartConnect Excel templates stop working after applying Microsoft updates from 12/9/2014. The typical symptom is that none of the buttons in the Excel Template will push, they appear to be static pictures. This is caused by a Microsoft security update that was issued on 12/9/2014.
Vaidhyanathan Mohan : Nice post up there on Ben Hosking’s CRM Blog… Originally posted on Hosk’s Dynamic CRM Blog : Now and again I get asked how to become a better CRM Developer, so I thought I would create a blog to point people towards and here it is. 1.
A customer has reported an issue with web client that many sessions are open while no body is working, they wanted to kill all these sessions without restarting the server, few researches over the internet returned the following CMD commands that did the trick, just Right Click the cmd.exe and run as administrator, then paste the following commands: Taskkill /F /IM Microsoft.Dynamics.GP.Web.Services.Runtime.Process.exe Taskkill /F /IM conhost.exe Viola! You saved an hour of manually killing these in your task manager or session manager. Note: To make sure that the windows cleans all sessions at night, I saved these commands into Batch.bat file and scheduled this with windows scheduler to run every night 4 AM, so users can find a clear log next morning.
Dynamics GP: You cannot print unauthorized Purchase Order and the Purchase order is not available in the commitment
One of my customers reported an issue with their purchase orders after upgrading to Dynamics GP 2013 R2, below the message they got: The customer is using PO Commitment to validates budgets and somehow the purchase order was not available in “CPO10110” table, the script below will fix this for you by taking the record information from POP10110: INSERT INTO CPO10110 (PONUMBER ,ORD ,ACTINDX ,REQDATE ,VENDORID ,APPROVL ,Committed_Amount ,POLNESTA ,QTYCANCE ,UNITCOST ,PostedSubtotal) SELECT PONUMBER ,ORD ,INVINDX ,REQDATE ,VENDORID ,1 AS APPROVL ,0 AS Committed_Amount ,POLNESTA ,QTYCANCE ,UNITCOST ,EXTDCOST AS PostedSubtotal FROM POP10110 WHERE PONUMBER = @PONUMBER Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 firstname.lastname@example.org http://www.di.jo
When you see the window print button you expect that the information of the window you are on is being printed on a report writer report, and when one of your customers inform you that no action is being taken upon pressing the report you just feel like the user is not aware whats going on and a privileges issue should take place! Well for Purchase Requisition Entry form this is not the case! the window print is not linked to any of the available reports, clicking the button will do nothing and you will feel a little bit confused about what to be done! The button indeed does not have a report assigned, but you can design your report on SSRS and link it to this button! Just click the Small Arrow near the print button and hit “Assign Reports”, then select the report you need to link, see the below for clarification: Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 email@example.com http://www.di.jo