Microsoft Dynamics Axapta Technical,Functional Coverage

Lookup at runtime in Enterprise portal web form ax 4.0 webTableLookup webTableLookup; Query query; QueryBuildDataSource qbds; WebSession webSession = new WebSession(); ; query = new Query(); qbds = query.addDataSource(tablenum(testTable)); qbds.addSortField(fieldnum(testTable,colm1)); qbds.orderMode(orderMode::GroupBy); webTableLookup = webTableLookup::newParameters(tablenum(testTable)); webTableLookup.addLookupfield(fieldnum(testTable,colm1)); webTableLookup.selectField (fieldnum(testTable,colm1)); webTableLookup.parmQuery(query); webTableLookup.run(); I hope this can help you a lot.

Pass table record to webform and redirect menuitem in enterprise portal 4.0 WebLink webLink = new WebLink(); WebUrlMenuFunction wmf; str url; InventDim inventdim1; ; wmf = new WebUrlMenuFunction(weburlitemstr(ItemOnHand)); webLink.menufunction(wmf); select firstonly inventdim1 where inventdim1.InventLocationId == InventLocationId.valueStr() ; webLink.record(inventdim1); url = webLink.url(false); webSession().redirectURL(url);

CommaIo urfile; LedgerTrans LedgerTrans1; Container container1; sqlDictionary sqlDictionary; TableName tablenm; ; tablenm = "LedgerTrans1"; select * from sqlDictionary where Tablename2id(tablenm) == sqlDictionary.tabId; if(sqlDictionary.RecId > 0) { urfile= new CommaIo("c:\\test.doc","w"); urfile.outFieldDelimiter("\t");/ while select LedgerTrans1 { container1= [LedgerTrans1.AccountNum,LedgerTrans1.Txt]; urfile.writeExp(container1); } }

Example of update_recordset. update_recordset InventItemInventSetup setting standardQty = 5667 join itemId,itemType from inventTable where InventItemInventSetup.ItemId == inventTable.ItemId && inventTable.ItemType == itemType::BOM;

info(strfmt("%1 - %2", DateTimeUtil::getUserPreferredTimeZone(), enum2str(DateTimeUtil::getUserPreferredTimeZone()))); //DateTimeUtil::applyTimeZoneOffsetcusttable.createdDateTime,DateTimeUtil::getUserPreferredTimeZon()); info(strfmt("%1 - %2",DateTimeUtil::applyTimeZoneOffset(CustInvoiceJour.createdDateTime, DateTimeUtil::getUserPreferredTimeZone()), custtable.modifiedDateTime));

How to get values of base in microsoft dynamics axapta by code EnumId Idenum = enumNum(YourEnumType); DictEnum Denum = new Denum(Idenum); int cnt = Denum.values(); int cntr for(cntr = 0; cntr < cnt; cntr ++) { Denum.name(cntr) Denum.index2Value(cntr) Denum.index2Symbol(cntr) Denum.index2Label(cntr) }

Following error on Event log at the time of EP Site creation. How could we resolve this error. If I will resolve then will post answer soon. SQL Database 'SharePoint_Config_26c83dac-e459-49a3-80f5-10c1b1dee635' on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error information from SQL Server is included below. Cannot open database "SharePoint_Config_26c83dac-e459-49a3-80f5-10c1b1dee635" requested by the login. The login failed. Login failed for user 'test\bcproxy'. Could you put your comment for this error