Open Table Browser

 mi=systablebrowser&tableName=inventtable

Comments

Post a Comment

Popular posts from this blog

jumpRef method to open one form to another form in d365 fo x++

Steps:    Create a method in Table and take the specific id to the parameter  public static void jumpRefId(ContractID _ContractID)     {         Args            args = new Args();         MenuFunction    menuFunction;         PersonContracts PersonContracts;         select * from PersonContracts         where PersonContracts.PersonId == _ContractID;         args.record(PersonContracts);         args.lookupRecord(PersonContracts);         menuFunction = new MenuFunction(menuitemDisplayStr("Menuitemname"), MenuItemType::Display);         menuFunction.run(args);     } step 2: call this method in form field method jumpref()  [Control("String")]     class DSPPersonContracts_PersonId     {         ...
Read more

how to write a Display Method in d365 fo x++

    [SysClientCacheDataMethodAttribute(true)]         public  display EcoResDescription ItemDescription()     {         str                                    itemdescription;         InventSum                      inventsum;         InventTable                    inventTable;         EcoResProductTranslation    ecoResProductTranslation;         EcoResProduct               ecoResProduct;         select * from inventTable where inventTable.ItemId  == this.ItemId;         select * from EcoResProduct where EcoResProduct.RecId  == inventTable.P...
Read more

Convert Amount from one currency to another curency in d365 fo x++

    public real CurrentExchangeRate(CurrencyCode fromCurrency , CurrencyCode toCurrency , TransDate    transDate)     {         ExchangeRate      exchangeRate;         ExchangeRateType ExchangeRateType;         ExchangeRateCurrencyPair  exchangeRateCurrencyPair;         real              exchRate;         if( fromCurrency == toCurrency)         {             exchRate = 1;             return exchRate;         }         else         {             select firstonly exchangeRateCurrencyPair                 where exchangeRateCurrencyPair.ExchangeRateType == Ledger::find(Ledger::current...
Read more