D365FO - X++ View | Assign value to String Computed Column in X++ View

 1. Create a view.

 2. Add new field in the customize view.


3. Go to Property >> View Method >> Initially No Method will shown.

4. Go to Methods >> Right Click >> New Method.

5. Write the following X++ code to assigning the value to newly added view field.

 public static server  str getValue()

{

return SysComputedColumn::returnField(viewstr(XXX View Name) ,identifierStr( YYY DataSource Name),fieldStr(YYY DataSource Name, ZZZ Field Name));

}

Note : Target field's  view (XXX), data source(YYY) and field(ZZZ)  name need to replace in the red color Highlighted

6. Build and Synchronize the database. 

7. Select the Newly added field and Go to the Property >> View Method >> .Dropdown and Select the newly created method getValue().

8. Build the Project once again.

NOTE: if you are facing any issue, you can verify the input value from SQL Trace. 

Comments

Post a Comment

Popular posts from this blog

DMF (1073676279) - Issue Fix

 Problem Statement:      When  I tried to Import the data via DMF I got the following error message. <?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 -    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlPackageImport.AddDataFlowComponent(Package _Package)    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerImport.CreateAndExecutePackage()    at DMFExecutePackage.PackageCreator.processEntity()    at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-1073676279</ErrorCode><SubComponent>Microsoft.SqlServer.DTSPipelineWrap</SubComponent><Description>Exception from HRESULT: 0xC0010009 -    at Microsoft.SqlServer.Dts.Pipeline.Wra...
Read more

Read the JSON data via REST API (X++)

  Problem Statement:           Read the data from outside Application. Here I am fetch the JSON data from Shopify Integration and push it in to the D365FO System.   Development steps:       Step 1 : Create Runnable Class.      Step 2 : After create the Runnable class, use the following Library in your solution.                               using System.Net.HttpWebRequest;                               using System.Net.HttpWebResponse;                               using System.Text.Json;                               using System.Text.Json.Serialization;  ...
Read more

Activate Financial Dimension in Dynamics 365 FO. (On- Premises)

  If you want to activate the financial dimension in Dynamics 365 on on-premises, you need to do a following step. 1.      Open SQL and go to D365FO Database. 2.     Execute the following Query                   select * from SQLSYSTEMVARIABLES         update SQLSYSTEMVARIABLES SET VALUE = 1 WHERE PARM =                     'CONFIGURATIONMODE' 3.      Execute IIS Restart. 4.     Refresh the Page. 5.     After activating the financial dimension, you need to revert the option.              update SQLSYSTEMVARIABLES SET VALUE = 0 WHERE PARM                     =   'CONFIGURATIONMODE' 6.    Execute IIS Restart. 7.    Refresh the Page.
Read more