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

Monday, November 24, 2014

Requisitions Management Purchase – Item Cost Selection

One of my customers reported that when they transfer the Purchase Requisition to Purchase Order, the cost they specified in the requisition for their items is not being transferred to the purchase order.

Checking the Requisition setup I didn’t find an option to keep the cost of requisition on Purchase Order, only the below options are available:

image

For this particular customer, they are not using the “last vendor originating cost”, so I have created a Trigger that updates the field for each update occurs on requisition screen, below the trigger code if anybody is interested.

CREATE TRIGGER [dbo].[DI_UPDATEITEMCOST]
ON [dbo].[POP10210]
AFTER INSERT, UPDATE
AS

DECLARE @ITEMNMBR VARCHAR(500)
DECLARE @UNITCOST numeric(18,5)
DECLARE CUR CURSOR FOR SELECT ITEMNMBR, UNITCOST FROM INSERTED

OPEN CUR
FETCH NEXT FROM CUR INTO @ITEMNMBR, @UNITCOST

WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE IV00103 SET Last_Originating_Cost = @UNITCOST WHERE ITEMNMBR = @ITEMNMBR AND @UNITCOST <> 0

FETCH NEXT FROM CUR INTO @ITEMNMBR, @UNITCOST
END
CLOSE CUR
DEALLOCATE CUR
GO






Regards,

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

Saturday, November 15, 2014

Dynamics GP Purchase Order Workflow: Approver requires A Full User not Limited

 

If you are looking to implement the Purchase Order Workflow, you must keep in mind that limited users will not be able to approve Purchase Orders, user should be FULL user to be able to process orders, I am not sure why Microsoft folks designed it this way but I got one of my customers to purchase additional 5 users to get this implemented!

I have requested this enhancement from Microsoft and kindly asking for your votes to get this fixed, below is the article on MS Connect:

https://connect.microsoft.com/dynamicssuggestions/feedbackdetail/view/1030936/purchase-order-approval-to-work-with-limited-users

Happy ordering!


Regards,

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

Friday, November 14, 2014

Dynamics GP Purchasing - Request for Quotations module

Thinking about this subject, can’t find a company who does not follow the standards in their procurement process, everyone brings 3 quotations from 3 different suppliers and selects the best fit from requirements and pricing!

I found this process on Connect requested since 2010 with very limited votes! I would kindly ask for your help in voting and getting this scheduled soon, below the description of the product suggestion:

I think Dynamics GP is one of the few applications in the ERP world that does not have the request for quotation functionality, the process is like this: - RFQ (enter details for items willing to purchase) - Select one or more vendors and the system should print separate RFQ for each (and prepare the system to receive responses from each) - Receive quotes from Vendors and update on system - Compare vendor’s prices against same lines in RFQ - transfer one of the quotes to Purchase order Note: The is the simplest cycle possible and there are many other advanced consideration that can be added later on like: - Issuing PO against more than one vendor quote for same RFQ - Ability to update quotation with new discounts and data maintaining original information and changes (quote version control). - Ability to make the budget commitment from RFQ point rather than PO point (and this will be major advance for the application as most of the people in business or government would like to reserve budget before knowing the vendor and not after like it is currently acquiring in GP) - Specify a minimum number of quotations if the RFQ estimated price is more than a specific value. - Include in GP workflow if possible - Link to specific one or more requisitions created in Business Portal.

Below the link for the connect article:

https://connect.microsoft.com/dynamicssuggestions/Feedback/Details/537585

Happy voting!


Regards,

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

Web Client – Date Fields “Please check and reenter the date”

If you are using the web client, you might be going through the message in the subject, this is annoying for users with too many daily transactions!

image

As reported by one of my customers! This issue occurs only when you have the date format with string month (dd-MMM-yy) like the below:

image

Just make sure that the month is numeric (dd-MM-yyyy) and you will get rid of this message!


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