How to use Insert Record Set in Query object in D365 FO
Bulk Insertion from AOT Query – Dynamics 365 – AXGuru ttsbegin; Query::insert_recordset(table,fieldMapping,query); ttscommit; Above link shows details of how to do it.
Category: how to
How to write COC for different elements syntax
When extending a class, use classStr(<NameofBaseClass>) When extending a table, use tableStr(<NameOfBaseTable>) In the case of a form, use formStr(<NameOfBaseForm>) When extending a form Datasource use formDataSourceStr(<NameOfBaseForm>,<NameOfDataSource>) When extending a form Data field, use formDataFieldStr(<NameOfBaseForm>,<NameOfDataSource>,<NameOfField>) For a form control, use formControlStr(<NameOfBaseForm>,<NameOfControl>) When extending a data entity, use tableStr(<NameOfBaseDataEntity>) Two know more about COC follow this blog Chain Of Command For Form DataSource – Dynamics […]
How to change default pointing AXDB in D365FO in Dev Box
Raziq D365FO’s Blog | A technical blog………… (wordpress.com) K:\AosService\WebRoot\web.config this is the path of config file where we can open with notepad and change DB name. Above blog shows how to do it. My scenario is take DB backup instead restoring on same AXDB create New AXDB with different Name Eg AxDB_Test. Dynamics 365: Learn […]
How to set Cache lookup Property Based on table group
Table Group Cache Lookup Miscellaneous* See notes below Parameter EntireTable Group Found Main Found Transaction NotInTTS WorksheetHeader NotInTTS WorksheetLine NotInTTS Framework N/A Reference Found Worksheet NotInTTS TransactionHeader NotInTTS TransactionLine NotInTTS D365FO – AX – Cache Lookup Property of table – AX / Dynamics 365 For Finance and Operations blog (d365ffo.com) This useful blog explains the […]
How to Copy and Move Prospect with Attachments From one legal entity to other
First Create an Extension to SmmBusRelTable [ExtensionOf(tableStr(smmBusRelTable))]public final class SmmBusRelTable_ExtensionInside the Extension class right below method
How to get the number sequence for customer in D365FO
custTable.AccountNum = smmParameters::getNumber(smmNumbSeqUsed::Customer); This code basically does the job. note if we pass different enum to this getNumber method we can get number sequence for Prospects, Party, Leads etc. Useful method to retrieve all configured numbersequence using one parameter.
How to Hide any Form control in D365FO
write below code as a form method. FormRun formRun = this as FormRun;Var ControlName= formRun.design().controlName(FormControlstr(FormName,ControlName)); ControlName.Visible(False); You can basically call this code post form init or datasource active method This works for any control since I am using Var as it accepts any variable.
How to filter Odata query using url in D365 F&O
Hello all, In D365 F&O we need to filter the data returned by Odata query. I found a useful blog which allows you to filter the data using url. Blog D365 OData query calls: examples | Dynamics AX 365 for Operations challenges (wordpress.com). Sample for electronic address D365Url/data/ElectronicContactsAddress(ElectronicAddressId=’locationid’,Party=recid) Note: You will be able get this […]
How to write sample data contract class in D365 FSCM
This is a sample data contract class which I will use to convert to JSON format send to external systems. Watch out for next blog post to understand how to convert contract class to JSON.
How to create sample Reference lookup using EventHandler in D365 F&O
Here I have created a sample lookup for Address lookup. LogisticsLocationRecId is what used to create the reference field Below sample code.
axhowto 