Posts

Insert Customer VAT number and Registration Type Manually from backend (SQL) Query in D365 F&O

 -----Insert Registration Types---------- insert into TAXREGISTRATION(TaxRegistrationTypeApplicabilityRule, REGISTRATIONNUMBER,DirPartyLocation,VALIDTO) select TAXREGISTRATIONTYPE.RECID,'300187978800003',(select top 1 RECID from DIRPARTYLOCATION where LOCATION=(select top 1 RECID from LogisticsLocation  where LOCATIONID='000012001')),'2154-12-31 00:00:00.000' from   TAXREGISTRATIONTYPE where  TAXREGISTRATIONTYPE.TAXREGSTRATIONTYPE='TRN'
Post a Comment
Read more

how to get item attribute value on d365 fo x++

     public str getAttributeValue(ItemId _itemid, str _AttrName)     {         inventTable                     InventTable;         EcoResProductAttributeValue     ecoResProductAttributeValue;         EcoResAttribute                 ecoResAttribute;         EcoResValue                     ecoResValue;         select * from         InventTable         join EcoResProductAttributeValue         where ecoResProductAttributeValue.Product == InventTable.Product         &&  InventTable.itemid == _itemid         join  ecoResAttribute         where ecoResProductAttributeV...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more

Lookup Default Dimension displayValue in Form field Lookup method in d365 fo x++

 public void lookup()         {             QueryBuildDataSource    qbds,qbds1;             SysTableLookup          sysTableLookup;             DimensionAttribute      dimAttr;             Query                   query             = new Query();             sysTableLookup                            = sysTableLookup::newParameters(tableNum(FINANCIALDIMENSIONVALUEENTITY), this);             //dimAttr         = DimensionAttribute::findByName(DSVanSalesSystemParameter::Find().DimensionName, false);             sysTableLookup.addLookup...
Post a Comment
Read more

Get Value from Args and add range on on menu Item in Form in d365 fo x++

         public void init()         {             super();             if(element.args().menuItemName()== menuItemDisplayStr(DSPExpenseClaimRequestWF))             {                 DSPExpenseClaimRequest ExpenseClaimRequest   =    element.args().record() as DSPExpenseClaimRequest;                 QueryBuildRange qbds =  DSPExpenseClaimRequest_ds.query().dataSourceTable(tableNum(DSPExpenseClaimRequest)).addRange(fieldNum(DSPExpenseClaimRequest, RecId));                 qbds.value(queryValue(ExpenseClaimRequest.RecId));                 qbds.status(RangeStatus::Locked);             }         }
Post a Comment
Read more

Get Payment Voucher against Purchase Invoice in d365 fo x++

 SettlementViewBuilder settlementViewBuilder = SettlementViewBuilder::construct();             settlementViewBuilder.parmIncludePaymentJournals(NoYes::No);             settlementViewBuilder.parmRestrictSearchToOriginalDocument(NoYes::Yes);             SettlementView localSettlementView = settlementViewBuilder.createView(vendTrans);             select * from localSettlementView             where localSettlementView.TransactionType    ==  LedgerTransType::Payment;
Post a Comment
Read more