Convert amount from one currency to another currency using X++

 You can use the following X++ code snippet for currency amount conversion.


    CurrencyExchangeHelper currencyExchangeHelper;

    AmountMst amountMST;

    CurrencyCode FromCurrency =  'PKR';

    AmountCur amountCur = 5000;

    currencyExchangeHelper = CurrencyExchangeHelper::newExchangeDate(Ledger::current(), systemDateGet());

    amountMST =  currencyExchangeHelper.calculateCurrencyToCurrency(fromCurrency, SLDFabCostSheetsCalculation.Currency,amountCur,true);

  

    info(strFmt("%1", amountMST));

Comments

Post a Comment

Popular posts from this blog

Create custom workflow in D365 X++

Image
 For the creation of Custom Workflow in Dynamics 365 F&O, Kindly follow the following steps; 1. Create a custom Enum WorkflowStatus or you can use an existing one.   2. Create a new table EmployeeLeave as defined below and add the above Enum as a field and name it LeaveStatus . 3. Create a new form EmployeeLeaveForm by using the above table as a data source.   4. Create a new Display Menu Item EmployeeLeaveForm for the above form and add to any  Module by creating an extension of the Module Menu from the application Explorer. 5. Create a new Query EmployeeLeaveQuery  and add  EmployeeLeave as a data source.                 6. Create a new Workflow Category EmployeeLeaveCategory .   7. Create a new workflow type EmployeeLeaveWorkflowType .   • Category: Select the workflow category from the previous step • Query: Select the query created for the document table • Document menu item: Sel...
Read more

Convert table rows to JSON in X++ D365

To convert table rows to JSON in X++ , you can use the JSON serialization capabilities provided by X++'s built-in classes. Here's an example demonstrating how to achieve this:   Assuming you have a table named MyTable with fields Field1, Field2, and Field3, and you want to convert its rows to a JSON array:   static void ConvertTableRowsToJson(Args _args) {      MyTable myTable;      str jsonString;      int i;        // Create an empty array to store JSON objects      Array jsonArray = [];       // Retrieve data from the table      while select * from myTable      {          // Create a JSON object for each row          JsonObject jsonObject = new JsonObject();          jsonObject.addField("Field1", myTable.Field1);          jsonObject.addField("Field2", ...
Read more

How to Create Number Sequence in the D365 X++ ?

Image
 If  you want to create the number sequence in the D365 X++, Kindly follow the following steps: 1- Create a Project of D365 F&O with your model as shown below, 2- Create an Extended Data Type (EDTs) in the Project. 3- Now create a class of number sequence as shown below code; protected void loadModule()     {         NumberSeqDatatype datatype = NumberSeqDatatype::construct();         datatype.parmDatatypeId(extendedTypeNum( EDTs ));         datatype.parmReferenceHelp(literalStr("Unique key used for the  Id."));         datatype.parmWizardIsContinuous(false);         datatype.parmWizardIsManual(NoYes::No);                 dataType.parmWizardHighest(999999);         datatype.parmWizardIsChangeDownAllowed(NoYes::No);         datatype.parmWizardIsChangeUpAllowed(NoYes::No); ...
Read more