Open Table Browser

 mi=systablebrowser&tableName=inventtable

Comments

Post a Comment

Popular posts from this blog

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

Jumpref Method in form The table does not exist as a root FormDataSource for the form in d365 fo x++

  The table does not exist as a root FormDataSource for the form Posted by  ajdoering  on  March 28, 2012 If you are Receiving this error: “Could not process the lookupTable value on the Args instance. The table ‘TableName’ does not exist as a root FormDataSource for the form ‘TableNameForm’” I may have found a solution for you. AX 2012 gets very angry when you call a form using a record from a datasource that is not the main form datasource. For example, if you have a form with SalesTable and SalesLine joined to it, and you call the form with a SalesLine record, this error message will pop-up. If this is for View Details, The easiest way to fix this is as follows: 1. Override the jumpRef() on the datasource field 2. Create Args and MenuFunction variables 3. Find the record for the main datasource table 4. Set args.record() to the main datasource record 5. Set menuFunction to the menu item that would be called if you went to View Details 6. Call the menu item wi...
Read more