How to Copy Values from Staging Table back to Target Table in D365 F&O through Sql

We normally have requirements where data from third party apps imported into D365 Finance and Operation table using Data Entity. Some time this has to be done through integration calling data entity through postman. Some times during testing these data in table we would need to test with same data see how it behaves. manually […]

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 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 […]