Tag: middle-east

Average Days To Pay Calculation – History & Open (SQL Script)

In my previous post, Average Days to Pay Calculation (SQL Code) , I had provided a SQL stored procedure that calculates a customer’s ADTP for a given point of time (between two dates). While this was perfect, it does not include fully applied but open invoices

Continue Reading

Dynamics GP Web Client: Kill all web client sessions

| 12/07/2014 | 0 Comments
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.

Continue Reading

Dynamics GP: You cannot print unauthorized Purchase Order and the Purchase order is not available in the commitment

| 12/07/2014 | 0 Comments

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

Continue Reading

Dynamics GP 2015 with 120+ enhancements!

| 12/03/2014 | 0 Comments

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

Continue Reading

Requisitions Management Purchase – Item Cost Selection

| 11/24/2014 | 0 Comments

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.

Continue Reading

Dynamics GP Purchasing – Request for Quotations module

| 11/15/2014 | 0 Comments
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).

Continue Reading

No Print for Purchase Requisitions!!

| 11/11/2014 | 0 Comments

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

Continue Reading