Microsoft Dynamics Axapta Technical,Functional Coverage

If you are facing W3SVC Error During Reporting Extension installation in axapta as following image.  To solve this error you can try following things. Open IIS Manager and navigate to the Web server node in the tree. In the Actions pane, click Start if you want to start the Web server or Stop if you want to stop the Web server. Using a command line Open an elevated command-line window. At the command prompt, type net stop WAS and press ENTER; type Y and then press ENTER to also stop W3SVC. To restart the Web server, type net start W3SVC and press ENTER to start both WAS and W3SVC.

 To Get customer Transaction Balance in Axapta you can try following code to get balance for particular customer. You can try code in job to check output. CustTrans custTrans; ; select sum(AmountMst) from custTrans where custTrans.AccountNum == '00000343'; info(strfmt("%1",CustPaymManTrans::openAmountMST('00000343')+custTrans.AmountMST));

To get customer Alternate address by coding in Axapta you need to use table dirpartytable which directly related to address tableby recid and tableid with address table. Custtable has unique partyid for each customer. CustTable custTable; Address address; DirPartyTable DirPartyTable; ; select custTable where custTable.AccountNum == '00000234'; select DirPartyTable where DirPartyTable.PartyId == custTable.PartyId; while select address where address.AddrRecId == DirPartyTable.RecId && address.AddrTableId == DirPartyTable.TableId { info("Name "+address.Name+" street "+address.Street+" zip "+address.ZipCode+" city "+address.City+" state "+address.State); }

 This is a good example to know how to use change company method to get data from multiple companies. CustTable CustTable; ; changecompany('dt1') { CustTable = null; select firstonly CustTable; info(CustTable.Name); } changecompany('dt2') { CustTable = null; select firstonly CustTable; info(CustTable.Name); }

 Inventsum is right table to get onhand stock for items. Onhand stock stored dimensionwise. Inventdimid is unique id for dimension combination. InventDim inventDim; InventSum inventSum; ; while select inventSum join inventdim where inventSum.ItemId == 'item1' && inventdim.InventLocationId == 'loc1' && inventdim.inventBatchId != '' && inventdim.inventDimId == inventSum.InventDimId { info(strfmt("%1",inventSum.physicalInvent())); }

Error description: SysWorkflowEventDispatcher-raiseWorkItemAcknowledgementEvent ClrObject static method invocation error. Exception has been thrown by the target of an invocation.  This error occurs due to IIS service stopped or interrupted. User need to run issreset command over command prompt.

If you are getting the error while refreshing the Temp Table in Visual Studio, and also getting the same error to add RDP class in Designing the SSRS report  Error is:  "An error occurred when retrieving the meta data for the query.  Exception occurred on the meta data service on client or server.  See Exception details below:  >data or calculated fields with type"Record" are not supported". Solution: 1.redeploy meta data, BI service from services node, also try refresh BC proxy setting from AX configuration 2.There is problem in RDP Class can you please Check any field is missing or else you can do one thing just in Visual studio Take the name for the DS and Remove and try to add once again ten you will find out the Error clearly then you can fix that from AX