This X++ code demonstrates how to retrieve the last workflow approver in Dynamics 365 for Finance and Operations using the getLastWorkflowApprover method. It joins tables to select the appropriate workflow tracking information and user details, returning the user ID of the last workflow approver.
D365FO: Get dimension display value in X++
This content demonstrates how to retrieve dimension display values in X++ for Dynamics 365 Finance and Operations. By utilizing the provided code, users can access dimension display values for custom forms or SSRS reports. The function 'getDimensionDisplayValue' accepts default dimension RecId and dimension name string, facilitating the retrieval of specific dimension values.
D365: When and how to use postLoad() method
This post discusses the usage of the postLoad method in data management for Dynamics 365 for Finance and Operations. It explains how the postLoad() method can be used to provide values for unmapped fields in export scenarios. A code example demonstrates populating a custom field added to a standard data entity to export additional information from released products.
D365: How to get caller form name in Form extension class
This code demonstrates how to retrieve the caller form name and use it to run business logic in a Form extension class in X++ for Dynamics 365 for Finance and Operations. The provided example adds a display method to the RetailAddItems form to display the Site, retrieving it from the PurchTable caller form data source.
Bacpac import fails using SqlPackage.exe
While importing the bacpac file into DEV exported from UAT using SqlPackage.exe, I got this error: Error: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins. Solution: You can download the .NET Core SQLPackage v18.4 to resolve... Continue Reading →
D365FO: Submit pending vendor invoice to workflow in X++
Purpose: In this post we're going to learn how can we submit a pending vendor invoice to approval workflow in X++. Application: Dynamics 365 for Finance and Operations Business requirement: Submit a pending vendor invoice to approval workflow in X++. Solution: We can use the code below to submit a pending vendor invoice to approval... Continue Reading →
D365FO: Get last workflow approver for purchase orders in X++
Purpose: In this post we're going to see how can we get last workflow approver for purchase orders in X++. Application: Dynamics 365 for Finance and Operations. Business requirement: Get the last purchase order approver in X++. Solution: Please use the code below to get the last purchase order approver. Tip: Take a note that... Continue Reading →
D365FO: Add query ranges to form data sources in X++
Purpose: In this post we're going to learn about how can we add ranges to form data sources using event handlers. Application: Dynamics 365 for Finance and Operations Business requirement: The requirement goes like business wants to restrict access to Purchase order confirmations such that user should only be able to see confirmations for their... Continue Reading →
D365FO: Read CSV file from Azure File Share
Purpose: The purpose of this post is to demonstrate how we can read a CSV file from Azure File Share in X++. Application: Dynamics 365 Finance and Operations Prerequisites: Azure file storage account must be configured in Azure PortalFile shares must be configured under this Azure file storage accountAccess permissions must be configured for this... Continue Reading →
Detected 50000 add(s) in Excluded Changes in Pending Changes
Purpose: The purpose of this post is to share how can we resolve this issue in Visual Studio. Application: Dynamics 365 Finance and Operations Background: After applying Microsoft service update to a DEV environment, I observed that in Pending Changes window, Visual Studio detected 50000 adds sitting in the Excluded Changes tab. Interestingly all of... Continue Reading →
D365 for Finance and Operations 