30 January, 2015 (14:48) | Dynamics AX | By: Howard Webb
Recently we have had an issue whereas in the AX client the “File” in the top left drop down was replaced with the text “MMANDBA+”, the tools option was not available and there were a number of other odd errors: A few co-workers investigated this and found that the issue is down […]
Tags: 2012, AX, Dynamics, Dynamics AX, Dynamics AX 2012, MMANDBA+
Comments: 1
29 August, 2014 (14:12) | Dynamics AX, SSRS | By: Howard Webb
If you need to reprint a sales invoice there is a method on the CustInvoiceJour table called printJournal. Calling this method will print using the original print management destination but you can override the destination by passing in an instance of SalesInvoiceJournalPrint. Below is an example of calling it and forcing the print destination to […]
Tags: 2012, AX, custInvoiceJour, Dynamics, Dynamics AX, Dynamics AX 2012, print destinations, printJournal, report, Sales Invoice, SalesInvoiceJournalPrint, SQL server Reporting services, SSRS, SSRS report, X++
Comments: 1
17 August, 2014 (15:53) | Dynamics AX | By: Howard Webb
Hi, This post is more for my memory more than anything else. If you need to get the number of records returned in a query or a query run you can use the following method: SysQuery::countLoops(QueryRun) This will return the same result as looping through the query using queryRun.next()
Tags: 2012, AX, countLoops, Dynamics, Dynamics AX, Dynamics AX 2012, Query, QueryRun, SysQuery, X++
10 June, 2014 (11:02) | Dynamics AX, SSRS | By: Howard Webb
One of our customers produce multiple PDF files for external customer statements. They wished to rename the file with the customer account number. To do this we have edited the following method: \Classes\CustAccountStatementExtController\runPrintMgmt I declared the following variables To make sure that I get just the file name correctly I have used […]
Tags: 2012, AX, Dynamics, Dynamics AX, Dynamics AX 2012, External customer statement, filename, filenamesplit, PDF, print destinations, runPrintMgmt, split file name, SSRS, SSRS report, X++
Comments: 2
7 May, 2014 (14:13) | Dynamics AX | By: Howard Webb
When writing a select statement or using a query you do not have to worry about if the table is a date effective table or not, the frame work handles this for you and will as default return the record that is current. If you are using a view however you need to do a […]
Tags: 2012, AX, Date effective, Dynamics, Dynamics AX, Dynamics AX 2012, table, view, X++
4 March, 2014 (10:54) | Dynamics AX | By: Howard Webb
When developing a new form or a new table that will have display or edit methods we should be thinking about how costly these types of methods are. Adding lots of these methods to a form can cause a large delay in opening and refreshing as these methods are recalculated every time a refresh is […]
Tags: 2012, AX, cacheAddMethod, CacheDataMethod, caching, Display method, Dynamics, Dynamics AX, Dynamics AX 2012, Edit method, Performance, X++
Comments: 3
28 February, 2014 (15:48) | Dynamics AX, SSRS | By: Howard Webb
Drill through links in SSRS are controlled by C# code which produces a URL that can be processed to call AX which can open a form with the appropriate record. There is a common class (DrillThroughCommonHelper) that will need to be either referenced or modified if you would like to use a lookup in Your […]
Tags: 2012, AX, Dynamics, Dynamics AX, Dynamics AX 2012, report, SSRS, SSRS report
27 February, 2014 (16:38) | Dynamics AX, SSRS | By: Howard Webb
If you are developing a larger auto-design report which groups data together it might be worth adding document navigation to the query to allow the end user to jump between sections of the report: To do this you will need to set up grouping on your table to allow the jumping. The label […]
Tags: 2012, AX, Dynamics, Dynamics AX, Dynamics AX 2012, Navigation Llink, report, SSRS, SSRS report
29 September, 2013 (00:57) | Uncategorized | By: Howard Webb
The SSRS print destinations are stored on the report’s contract and can be accessed and set with the following code on the controller: controller.parmReportContract().parmPrintSettings();
Tags: 2012, AX, Dynamics, Dynamics AX, Dynamics AX 2012, parmPrintSettings, print, print destinations, SSRS