Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Thursday, July 14, 2016

Microsoft Dynamics 365

We have been reading the news for a while, and the term "Dynamics 365" has been intensively trending among Microsoft customer and partner networks. So much news has come out of Microsoft World Partner Conference #WPC2016 in Toronto specifically about the future of the Dynamics line of business software, the wall street journal published previously this month; July the 6th, that "Microsoft Corp. plans to update its business software line called Dynamics on Wednesday, weaving together the web-based versions of programs that manage a variety of corporate operations to better compete in markets where it trails giants like SAP SE and Oracle Corp". 
In fact, Dynamics 365 will offer an embedded experience within office 365 in order to manage the various business operations such as; finance, sales, marketing, field service...etc. For instance, you will be able to create customers, vendors, quotes and even invoices without leaving outlook. 
Microsoft WPC 2016







In this essence, Dynamics 365 will unify the ERP and CRM cloud services offered by Microsoft along with Office 365, Power BI and Power Apps ...etc. under a single Microsoft AppSource. This includes; but no limited to, AX 7 (the online version of Dynamics AX, "Ranier"), CRM online, Project Madeira, Office 365, Power Apps. Therefore, Dynamics GP, NAV and SL will not be part of Dynamics 365 nor will be replaced by it. In fact, the roadmap presented by Microsoft at WPC shows the new versions of GP, NAV and SL along with the new great addition, Dynamics 365.
Microsoft WPC 2016
Furthermore, additional details were presented as related to Dynamics 365 roadmap, which are illustrated below:
  1.  April 2016  | Project Madeira public preview launches in US
  2. July 2016 | Project Madeira public preview launches in Canada
  3. Q4 CY16 | Microsoft Dynamics 365 for financials available in US and Canada
  4. CY17 | Microsoft Dynamics 365 for sales, Business edition available
  5. CY17 | Microsoft Dynamics 365 for marketing, Business edition available
  6. CY17 | Microsoft Dynamics 365 financials available in 4 additional countries
  7. CY17 | Microsoft Dynamics 365 for business plan available

  1. >> Reference: Microsoft WPC 2016 
I am not going to dig into furter licensing details, but will consider the above part as sufficient details in order to briefly shed a light on the future of Dynamics family as related tothe new offering, and that; most important of all, Dynamics GP, NAV and SL; which are not part of this offerings, will continue to flourish and introduce greater new versions. 


Best Regards,
Mahmoud M. AlSaadi

Monday, July 11, 2016

Purchase Requisition Workflow History - SQL View


Purchase requisitions in Dynamics GP with workflow history can be reported through inquiry windows, which provides a thorough details of all the changes/ modifications, approvals of rejections that were applied on the requisition. In this post, I am providing an SQL script that can be used to retrieve these details.

SQL View - Result Set

>>    The script can be downloaded from this link >>>> Download Link
 
/*--------------------------------------------------------------------------
Creation Date: The 9th of July, 2016
Created by: Mahmoud M. AlSaadi
The main purpose of the script is to provide the details of the workflow history 
of purchase requisitions.

Revision No.            RevisionDate    Description
1                       09/07/2016      Original Version
----------------------------------------------------------------------------- */

CREATE VIEW DI_POPReq_WorkflowHistory
AS
    SELECT  ISNULL(C.WfBusObjKey, '') WFBusObjKey ,
            ROW_NUMBER() OVER ( ORDER BY A.DEX_ROW_ID ) RecordSequence ,
           -- A.WorkflowInstanceID ,
        --A.WorkflowStepInstanceID ,
            Workflow_History_User ,
            A.Workflow_Name ,
            A.Workflow_Step_Name ,
            ISNULL(B.WorkflowTaskAssignedTo, '') WorkflowTaskAssignedTo ,
            CASE C.Workflow_Status
              WHEN 1 THEN 'Not Submitted'
              WHEN 2 THEN 'Submitted (Deprecated)'
              WHEN 3 THEN 'No Action Needed'
              WHEN 4 THEN 'Pending User Action'
              WHEN 5 THEN 'Recalled'
              WHEN 6 THEN 'Completed'
              WHEN 7 THEN 'Rejected'
              WHEN 8 THEN 'Workflow Ended (Depricated)'
              WHEN 9 THEN 'Not Activated'
              WHEN 10 THEN 'Deactivated (Depricated)'
              ELSE ''
            END AS WORKFLOW_STATUS ,
            CASE Workflow_Action
              WHEN 1 THEN 'Submit'
              WHEN 2 THEN 'Resubmit'
              WHEN 3 THEN 'Approve'
              WHEN 4 THEN 'Task Complete'
              WHEN 5 THEN 'Reject'
              WHEN 6 THEN 'Delegate'
              WHEN 7 THEN 'Recall'
              WHEN 8 THEN 'Escalate'
              WHEN 9 THEN 'Edit'
              WHEN 10 THEN 'Final Approve'
              ELSE ''
            END AS Workflow_Action ,
            A.Workflow_Due_Date ,
        --A.Workflow_Due_Time ,
            Workflow_Completion_Date ,
        --Workflow_Completion_Time ,
        --Milliseconds ,
            A.DEX_ROW_ID ,
            Workflow_Comments
    FROM    WF30100 AS A
            LEFT OUTER JOIN WFI10004 AS B ON A.WorkflowInstanceID = B.WorkflowInstanceID
            AND A.WorkflowStepInstanceID = B.WorkflowStepInstanceID
            LEFT OUTER JOIN WFI10002 AS C ON C.WorkflowInstanceID = A.WorkflowInstanceID
GO


GRANT ALL ON DI_POPReq_WorkflowHistory TO DYNGRP;



Purchase Requisition Window

Purchase Requisition - Workflow History

SQL View - Data Set


Best Regards, 
Mahmoud M. AlSaadi