Skip to main content

Posts

SQL Reporting service Error during Reporting Extension Installation from Setup

If you are facing following Reporting service Error during Reporting Extension Installation from Ax 2009 setup. Then you need to try following. Check whether Is "SQL Server Reporting Services" running? Install SQLSP2. Do this it is working 100% 1. Open the registry and find the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key. 2. Right-click the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key and choose New > Key. 3. Name the key Reporting Services. 4. Right-click the Reporting Services key and choose New > String Value. 5. Name the string value Version. The Version string value will have a type of REG_SZ. 6. Double-click the Version string value and enter 9.00.3042.00 as the value data. Click OK.

W3SVC Error During Reporting Extension installation in MSD axapta

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.

Get customer Transaction Balance in MSD Axapta

 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));

How to get customer Alternate address by coding in MSD Axapta

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); }

Change company example in MSD Ax

 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); }

Calculate Onhand physical inventory in MSD Axapta

 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())); }