Publications

Display method to get financial dimension value: #FinDimBusinessUnit - replace with name of financial dimension.

Errors: Application specific parameters setup is not completed for the 'VK' company. Error while evaluating expression for path 'ContainerForLookups/ReportFieldLookup' Set breakpoint to: class…

Edit: System administration / Setup / Key Vault parameter Fetch value:

If you want to change a value for the field Primary for country/region in the address record from Yes to No, the simplest way which I find it's: - open table browser for DirPartyLocation table - find a related record for the address -…

Custom scripts with zero downtime - create a new model containing only one Runnable class - write code in main method of that class - create deployable package from VS for that model - upload package to System administration / Periodic…

private InventDim copyInventDim(InventDim _inventDim) { InventDim inventDimLocal; inventDimLocal.InventDimFieldsMap::initAllDimensionsFrom(_inventDim); inventDimLocal = InventDim::findOrCreate(inventDimLocal); return inventDimLocal; }

If you want to make a lookup control on your own dialog or form with functionality for searching by more than one field in lookup, you can do it. For example, let's look at how product search works in multiple fields, we can use the…

There is ItemCoverageSettingsV2 data entity with a lot of key fields. And therefore when you try to update it with PATCH request it will fail: PATCH https://environment.dynamics.com/data/ItemCoverageSettingsV2(dataAreaId='vk',…

Will add Direct Delivery checkbox and Direct delivery warehouse fields to Retail and Commerce / Products and Categories / Commerce product hierarchy: The fields needs to be added to RetailProductAttributesLookup table, then added to the…

Error: Execution of scripts was prohibited. Use the XsltSettings.EnableScript property to enable it. An error occurred at (1087,9). Is referencing to a line in the XSLT transformation file where scripting function is called And declaration…

Recalculate InventSum for specific item

Class execution: /?cmp=DAT&mi=SysClassRunner&cls=VKTest Table browser: /?mi=SysTableBrowser&TableName=AccountantStaging&cmp=DAT&lng=en-us&limitednav=true Mobile handheld: /?mi=action%3AWHSWorkExecute&cmp=DAT SysFlushAOD…

Contract classes: JSON example: Runnable class to serialize contracts to JSON and then deserialize JSON back to same contracts: JSON does not have to completely match the contract. In that case only matching properties will be filled in.…

Generate random number using X++: Varian 1: Varian 2:

X++ code to make HTTP post/put requests to external services:

Here is how you can store encrypted passwords in D365FO: 1. Preferably create a new table specifically for this purpose Create a new field of type container and EDT EncryptedField called "Password" 2. Overwrite update and insert methods of…

To get azure account name and key from D365FO, create following runnable class: Get AccountName and AccountKey from the infolog: UPD 18-09-2024. Will be deprecated soon: https://portal.changepilot.cloud/MC869863 New tenants created after…

Expand controll Events node and right click on OnLookup and select Copy event handlr method. To supress standard lookup method and following warning message: More than one form was opened at once for the lookup control. Use following code:…

Restore data base from same tenant (company) 1. Open as Administrator PowerShell Install if not installed d365fo tools in power shell - Install-Module -Name d365fo.tools - Invoke-D365InstallSqlPackage 2. Restore database if BACPAC file in…

public str getErrorStr() { SysInfologEnumerator enumerator; SysInfologMessageStruct msgStruct; Exception exception; str error; enumerator = SysInfologEnumerator::newData(infolog.cut()); while (enumerator.moveNext()) { msgStruct = new…