Tips And Tricks Dynamics AX

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