Posts

Showing posts from December, 2024

Table Level Event Handler in d365 fo x++

[DataEventHandler(tableStr(PurchAgreementHeader), DataEventType::ModifiedField)] public static void PurchAgreementHeader_onModifiedField(Common sender, DataEventArgs e) { ModifyFieldEventArgs    event = e as DataEventArgs; PurchAgreementHeader    purchAgreementHeader = sender as PurchAgreementHeader; FieldId                 fieldId = event.parmFieldId(); date                    emptyDate; switch(fieldId) { case fieldNum(PurchAgreementHeader, BankGuarantee): if(purchAgreementHeader.BankGuarantee == NoYes::No) { purchAgreementHeader.BankGuaranteeExpirationDate = emptyDate ; purchAgreementHeader.BankGuaranteeNumber         = “”; purchAgreementHeader.Bank                         = “”; } break; } }   OnInserting - This method will be called during insertion of the record on the table. [DataEvent...

Data Entity Computed Column Method in d365 fo x++

1). Create Code extension of Data entity by right click on data entity. 2). create data entity extension and add unmapped field in data entity. 3). writea method as below    public static server str getInternalPackingSlipId()     {         DataEntityName  dataEntityName= tablestr(DSAQMVendPackingSlipJourBiEntity);         str             VendPackingSlipJour;         str             qry;         VendPackingSlipJour = SysComputedColumn::returnField(DataEntityName, identifierstr(VendPackingSlipJour), fieldstr(VendPackingSlipJour, Recid));         qry = strFmt('select top 1 VendPackingSlipVersion.InternalPackingSlipId from VendPackingSlipVersion' +             ' where VendPackingSlipVersion.VendPackingSlipJour = %1' +             ' order by...