Tips And Tricks Dynamics AX

How to Print Discount Group Name in the Sale Order Lines. Solution. I write this Method in SalesLine Table Method Section. display str DiscountGroupName() { return pricediscgroup::find(0,1,inventtablemodule::find(this.ItemId,2).linedisc).Name; } Now create a new StringEdit Control  in SaleLine form in Overview Section of SalesLine lines area. and use the above method in Method Property. Arif For any SSRS work please contact : SMS +923328244088 Skype: arifcomputerwala

How to Print Vendor or Customer Transaction with respect to Currency Group / Sort When we need to monitor total/sum of secondary currency we need to sort and group it by Currency. Please follow my blog article to show total / Sum  in your report and then show this in Vendor / Customer Transaction List Report in DAX2009. to see how to secondary currency total in Transaction Report click this http://microsoftdynamics2009.blogspot.com/2011/01/how-to-get-secondary-currency-total-in.html Please contact javanetpak@yahoo.com for further detail and also you can comment on this blog article. Best Regards Arif

Problem : Get Secondary currency total in Dynamics Transection Reports in A/R and A/P in Dynamics 2009. Solution : In AOT open the reports. Now Open the required report like CustTransList or VendTransList and do as in the image. just change the SUMALL property to Yes of the Secondary Currency Field. If you have any queries. Please send your queries to arif@paramoutbooks.com.pk. Arif

Problem  : Get Invoice # of the returning Item on Credit Note in each Item Line in AX 2009 There is a field "InventTransIdReturn"  in Saleline which has link id of InventTransID which resides in InventTrans so I write a function like this return InventTrans::findTransId(SalesLine::findInventTransId(CustInvoiceTrans.InventTransId,false).InventTransIdReturn).InvoiceId; It is working great. Dear reader may I jump right in the code. If you have any question please write me at arif@paramountbooks.com.pk

"Unable to Load Client Print Control" message when printing CRM v4.0 reports Issue: When clicking the Print icon to print a CRM v4.0 report (in a SQL Server 2005 database) you receive the message "Unable to Load Client Print Control" and the report does not print. Cause: Windows Security Update KB956391, an automatic security update. Once installed it causes the issue above with Windows Server 2003, Windows XP, and possibly others. Windows Vista machines do not appear to be affected. Solution: Install the fixes below on the necessary servers and reboot each server. CRM Server: Microsoft Report Viewer Redistributable 2005 Service Pack 1 http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en SQL Server: Security Update for SQL Server 2005 Service Pack 2 (KB954606) http://www.microsoft.com/downloads/details.aspx?FamilyID=4603c722-2468-4adb-b945-2ed0458b8f47&DisplayLang=en#filelist SRS Serv...

Please send us your experiences and share with other functional consultants.

In order to have Master Planning disregard the quantity of an item in a specific Warehouse in AX, the following setup must be enabled: 1.        The "Coverage plan by dimension" in the Dimension Group of the item must be checked. 2.        Open Inventory Management, then Setup, then Inventory Breakdown, then Warehouse, then Master Planning tab, and check the Manual check box for the warehouse where you do not want Master Planning to analyze its quantity. 3.        Specify the warehouse in the Sales Order of the item. The following steps can be used to test the previous information. 1.        Create a Warehouse named “Test” and have the Manual checkbox marked in the Master Planning Tab. 2.        Create a Dimension Group named “Test” with only Warehouse as the active dimension and with the following checked: o     Pri...