When posting an invoice, delivery note…etc. from a sales order a common form is used called SalesEditLines: This form is quite complex and uses several framework classes to build itself and the data within it. Recently I was asked to add a new range to the query that builds the results in the […]
Hi, Sometimes we need to add fields to a report that uses transactional data. Normally these have their own transactional tables such as CustInvoiceJour, however this report is different. If you check the method \Classes\PurchPurchaseOrderDP\createData you can see that the DP class uses PurchLineAllVersions and PurchTableAllVersions to get its data for the report. We will […]
Sometimes we would like to run an SSRS report via code to produce a report without user interaction or to call it during a process. To do this we could call the menu item that launches the report, but more often than not we would like to prepopulate it or call it without user interaction. […]
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 […]
I was on site with a 2009 customer the other day who were starting to develop their own reports. Being quite a few years since I have done it I had forgotten this trick to get the report name that is being run. If you modify the method \Classes\SysReportRun\run and include this line: […]
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 […]
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()
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 […]
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 […]
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 […]