Purpose

Calculate & evaluate complex algebraic expressions given in a string.

For example

str expression = “((12 + 2/2)*2)-6”;

After calculation above expression, result should come 20.

Issue

In Microsoft dynamics AX 2012,  EvalBuf() function was available for calculating complex algebraic expression.But in D365 finance and operation the function evalBuf() is missing and you cannot use it anymore.

Solution with sample code

We can use ProdMathEvaluator::evaluate() instead of EvalBuf().

[code language = “cpp”]
str expression = “((12 + 2/2)*2)-6”;
info(strFmt(‘%1’, ProdMathEvaluator::evaluate(expression)));
[/code]

Note

The expression string should not comma separator “,” etc otherwise you will get below error

[code language = “cpp”]
str expression = “((12 + 2/2)*2)-6”;
expression = strRem(expression, “,”); // removing comma
info(strFmt(‘%1’, ProdMathEvaluator::evaluate(expression)));
[/code]

cheers 🙂

piyush adhikari

Purpose

Open A New Web Page or Browser Tab Using X++ in D365 Finance and Operation.

Sample Code

[code language = “cpp”]
new Browser().navigate(“URL”, true);
[/code]

cheers 🙂

piyush adhikari

Purpose

Writing Display Method In Table Extension Of Standard or Base Table.For example:Writing display in table extension “VendTable”.

Sample Code & Instruction:

1. Create a new extension class for table.
2. Write a new display method and also define method attribute [SysClientCacheDataMethodAttribute]
3. Add a form control in form and change the properties as per below screenshot

[code language = “cpp”]
[ExtensionOf(tableStr(VendTable))]
final public class ACXVendTable_Extension
{
public static display Description vendorGroupName(VendTable _this)
{
return VendGroup::find(_this.VendGroup).Name;
}
}
[/code]

cheers 🙂

piyush adhikari

Purpose

Demonstration of Form Datasource Field Event or Data Event “onValidating”.Validating field values in form level.

Sample Code

1. Create a new class.
2. Copy “onValidating” event from Form Datasource field & paste the same into the class.

[code language = “cpp”]
[FormDataFieldEventHandler(formDataFieldStr(SalesTable, SalesLine, SalesPrice), FormDataFieldEventType::Validating)]
public static void SalesPrice_OnValidating(FormDataObject sender, FormDataFieldEventArgs e)
{
var args = e as FormDataFieldCancelEventArgs;
FormRun formRun = sender.datasource().formRun();
boolean ret;
SalesTable salesTable = formRun.dataSource(formdatasourcestr(SalesTable, SalesTable)).cursor();
SalesLine salesLine = formRun.dataSource(formdatasourcestr(SalesTable, SalesLine)).cursor();
formRun = sender.datasource().formRun();
if (CustTable::find(salesTable.CustAccount).AcxOverrideSalesPrice == NoYes::Yes && salesLine.SalesQty > 0)
{
ret = checkFailed(‘Override Sales Price Is True On Customer Card.’);
args.cancel(true);
}
}
[/code]

cheers 🙂
piyush adhikari

Purpose

Customizing & Writing Event Handlers Of Table in Microsoft Dynamics D365/AX7. Modifying table field values using switch statement of FieldId

Sample Code

[code language = “cpp”]

[DataEventHandler(tableStr(PurchLine), DataEventType::ModifyingField)]
public static void PurchLine_onModifyingField(Common sender, DataEventArgs e)
{
PurchLine purchLine = sender;
AcxDesigns acxDesigns;
ModifyFieldEventArgs modifyFieldEventargs = e as ModifyFieldEventArgs;
AcxWeightRangeMaster weightRangeMater;
;

switch(ModifyFieldEventArgs.parmFieldId())
{
case (fieldNum(PurchLine, AcxDesignCode)):
select firstonly1 AcxDesigns
where AcxDesigns.DesignCode == PurchLine.AcxDesignCode;
purchLine.AcxOrnamentCategoryCode = AcxDesigns.OrnamentCategoryCode;
purchLine.AcxOrnamentSubCategoryCode = AcxDesigns.OrnamentSubCategoryCode;
break;

default:
break;
}
}

[/code]

cheers 🙂
piyush adhikari

Purpose

Customizing & Writing Event Handlers Of Table in Microsoft Dynamics D365/AX7. Validating table field values using switch statement of FieldId

Sample Code

[code language = “cpp”]

[DataEventHandler(tableStr(PurchLine), DataEventType::ValidatedField)]
public static void PurchLine_onValidatedField(Common sender, DataEventArgs e)
{
PurchLine purchLine = sender;
ValidateFieldEventArgs validateFieldEventArgs = e as ValidateFieldEventArgs;
boolean ret = ValidatefieldEventargs.parmValidateResult();
;

if (ret)
{
switch (validateFieldEventArgs.parmFieldId())
{
case fieldNum(PurchLine, ItemId):
InventTable inventTable = InventTable::find(PurchLine.itemId);
if (InventTable.ACXPOType != PurchLine.purchTable().ACXPOType)
ret = checkFailed(‘Purchase Order Header PO Type Should Be Same As Item PO Type’);
break;
default:
break;
}
ret = ValidatefieldEventargs.parmValidateResult(ret);
}
}

[/code]