Skip to main content

Notifications

Community blogs

Featured

Latest blog posts

View all
LikeLike (0)
X++ code to auto submit purchase order to workflow in D365FO

Hi,   In this post we will view the code to auto submit purchase order that is draft status to workflow. Please note in order to enable workflow necessary setup, workflow configuration and activation is required.   Created a runnable class and added

LikeLike (0)
X++ code to show record count during set based update operation in D365FO

Hi,   In this post we view the code to know the record count after set based update operation. For demo purpose, created a runnable class "CG_UpdateRecordSetRecordCount" and used the below code to update the field "classification group" of customers

LikeLike (0)
Advanced ranges of a query in D365FO view

  Hi,   In this post, we will view the way to provide advanced range values for different query fields of a view.   Please refer to my earlier post to know the definition of view "DAXSalesPriceAgreement" Different ranges of a query in D365FO view (dy

LikeLike (0)
Different ranges of a query in D365FO view

Hi,   In this post, we will view the way to provide range values for different query fields of a view.   Step 1: Created a view "DAXSalesPriceAgreement" and added tables PurchDiscTable and InventDim as its datasources. [/api/data/v9.1/msdyn_richtextf

LikeLike (0)
X++ code to get the max date using the SQL query and SysComputedColumn in D365FO

Hi, In this post we can view the code to get the max date by comparing different dates and display the SQL query and SysComputedColumn in D365FO. Please refer to this post to know about the details of the view DAXPurchAgreementDetails. ( ) X code

LikeLike (0)
X++ code to compare different dates and display the max value using SysComputedCol...

  Hi, In this post we can view the code to compare different dates and display the max value using SysComputedColumn in D365FO. Please refer to this post to know about the details of the view DAXPurchAgreementDetails. ( ) X code using SysComputed

LikeLike (1)
X++ code using absolute function of SysComputedColumn in D365FO

  Hi,   In this post, we will view the code to use absolute function of SysComputedColumn in D365FO.    Please refer to my earlier post to know the details about the view DAXCustomerTransMeasures. X++ code using SysComputedColumn to use max and min a

LikeLike (1)
X++ code using SysComputedColumn to use aggregate function "sum" in D365FO

    Hi,   In this post, we will view the code to use aggregate function "sum" of SysComputedColumn in D365FO.    Please refer to my earlier post to know the details about the view DAXCustomerTransMeasures. X++ code using SysComputedColumn to use max