Sunday, December 7, 2014

Dynamics GP Web Client: Kill all web client sessions

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.


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

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:

image

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
me@mohdaoud.com
http://www.di.jo

Wednesday, December 3, 2014

Dynamics GP 2015 with 120+ enhancements!

As promised, Microsoft has released Dynamics GP 2015 on time! 120+ enhancements were introduced, see below the first look into the product:

Before you plan your upgrade, keep in mind that SQL 2008 is no longer supported, you must upgrade at least to SQL 2012 or later.

1. Icons has been Changed!

image

2. Login Page has been changed!

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Related Posts:

Related Posts with Thumbnails