Skip to main content

Posts

Relation between RouteVersion and ProdRoute in Axapta or D365Fno

 What is  link RouteVersion table with ProdRoute table? Answer: a route is made of up the tables RouteTable  and Route .  Additional data (like process time, etc.) is stored in table RouteOpr in rule form. There is not direct relation between  RouteVersion table with ProdRoute table because prodroute table used in route form as temperary table so you can get data in RouteOpr data using item id not any other record reference.   Then RouteVersion is used to associate a RouteTable record with an InventTable record, or a released product, using ItemId as the relationship.  single route can be associated with multiple released products.    I hope it will help you to save lot of time if you are technical. Thanks in advance.

Timeout handling for EP ax 2012 web setting

 First you create a backup of the web.config file. By default the file is located in the following directory: “C:\inetpub\wwwroot\wss\VirtualDirectories\80” Open the web.config file in Microsoft Visual Studio or a simple text editor like Notepad then find    </configSections>. Add timeout section  <Microsoft.Dynamics> <Session Timeout="45" /> </Microsoft.Dynamics> Other all settings <Microsoft.Dynamics> <Session Timeout="45" MaxSessions="300" /> <ServerState Enabled="true" MaxNumberOfInMemoryCachedItems="100" MaxNumberOfInMemoryCachedLargeItems="25" /> </Microsoft.Dynamics>

How to set Query build range on Form Data source in Axapta

 In this post you will learn How to set Query build range on Form Data source in Axapta (Ax 2012) . You can refer below code and apply in Init method of form data source.

How to get , Mark and Marked records in Axapta(Ax 2012 and D365 FnO)

  Mark all records: public void selectall(boolean _select) { CustTable     localCustTable; localCustTable = this.getFirst(); while(localCustTable) { this.findRecord(localCustTable); this.mark(_select); localCustTable = this.getNext(); } } Read marked records: CustTable     localCustTable; localCustTable = this.getFirst(1); //get marked while(localCustTable) { //do something localCustTable = this.getNext() }   OR: for(localCoInfo = CustTable_ds.getFirst(1);localCoInfo;localCoInfo = CustTable_ds.getNext()) { //do something }

Refresh Data, Dictionary, Element by code in Axapta

  // Reset data CG_RefreshAll::reset(); CG_RefreshAll::doDictionaryFlush(); SysEvent::fireEvent(SysEventType::FlushDictionary); if (args && args.parmEnum() == NoYes::No) info("@SYS68566"); // Data flush CG_RefreshAll::doDataFlush(); SysEvent::fireEvent(SysEventType::FlushData); if (args && args.parmEnum() == NoYes::No) info("@SYS98783"); // AOD Flush CG_RefreshAll::doAODFlush(); CG_RefreshAll::clearManagedCaches(); CG_RefreshAll::clearGlobalObjectCaches(); SysEvent::fireEvent(SysEventType::FlushAOD); SysExtensionCache::clearAllScopes(); CG_RefreshAll::clearGlobalCaches(); if (args && args.parmEnum() == NoYes::No) { info("@SYS68564"); }

Date Time Formatting On SSRS Report using D365FnO