https://www.evernote.com/shard/s9/sh/6d33b45f-d609-4cb9-ad93-b69e2cef47d4/ad665c88f2cac912003e5ee642b72c9d
Microsoft Dynamics Ax
An alternative to the WinApi functions
by Bo Jensen •
The WinApi class holds some nice functions for file manipulation, like the WinApi::fileExistsWinApi::copyFileWinApi::deleteFileWinApi::moveFile I think every programmer has used one of those functions in Ax at one time or another, as they can be really helpful. They have one big drawback though: They need to be executed on the client tier. Trying to use…
Microsoft Dynamics Ax
Stack trace: Invalid attempt to call WinAPI::findFirstFile running in CIL on the client.
by Bo Jensen •
This error you will normally encounter when running a batch job. The issue is that batch processing doesn’t suppport WINAPI::findFirstFile method. Actually I was trying to find a file in the folder and moving to some other folder, you can use this alternative: public void run(){ System.IO.DirectoryInfo di; System.Type arrayType; System.Array array; System.IO.FileInfo fi; FilePath…
Microsoft Dynamics Ax
Import duplicate company data to use for testing [AX 2012]
by Bo Jensen •
I found this article on Microsoft Technet which describes how to setup the data-import correct when importing duplicate company data within the same application. Import duplicate company data to use for testing [AX 2012]
Microsoft Dynamics Ax
X++ code to Count Records in Query
by Bo Jensen •
Following code illustrates how we can use SysQuery::countTotal() method to get the number of records in Query. static void Query_cntRecords(Args _args) { Query query = new Query(); QueryRun queryRun; QueryBuildDataSource qbd; ; qbd = query.addDataSource(tablenum(CustTable)); queryRun = new QueryRun(query); info(strfmt("Total Records in Query %1",SysQuery::countTotal(queryRun))); } Microsoft Dynamics…
Sharepoint
Resolving "The super user account utilized by the cache is not configured."
by Bo Jensen •
If you have a SharePoint Publishing site and you check the event viewer every once in a while you might see the following warning in there: Object Cache: The super user account utilized by the cache is not configured. This can increase the number of cache misses, which causes the page requests to consume…
Microsoft Dynamics Ax
Importing Customers, Vendors and Products in AX 2012 – AX Support – Site Home – MSDN Blogs
by Bo Jensen •
Importing Customers, Vendors and Products in AX 2012 – AX Support – Site Home – MSDN Blogs.
Microsoft Dynamics Ax
Job to Import Vendor/Customer Postal Address in Dynamics Ax2012 | Amirs Microsoft Dynamics AX space
by Bo Jensen •
Job to Import Vendor/Customer Postal Address in Dynamics Ax2012 | Amirs Microsoft Dynamics AX space.
Microsoft Dynamics Ax
How to quickly set up Application Integration Framework (AIF) for testing Axd documents – Ivan (Vanya) Kashperuk blog – Microsoft Dynamics AX – Microsoft Dynamics Community
by Bo Jensen •
As many people find it hard to setup AIF, I have tried to help them by creating an automated way of doing the initial setup, which can be used for testing the documents using a 1-box setup and FileSystem transport adapter.
Microsoft Dynamics Ax, SQL Reporting Services
How to: Add a Drill Through Action on a Report [AX 2012]
by Bo Jensen •
MSDN does document how to add a drill through action on a report. http://msdn.microsoft.com/EN-US/library/cc582049.aspx However I feel it is quite invasive and it could be done a lot cleaner without touching too many standard objects.
Microsoft Dynamics Ax, SQL Reporting Services
SRS report does not reflect the new query changes – cache issue [AX 2012]
by Bo Jensen •
In some scenarios you may see that your query changes doe not reflect in the report. This is due to some caching that is done. The obvious thing is to delete the AUC files and clear out your data usage. But there is a new table that we need to be aware of in this…
SQL Reporting Services
SSRS Page Break After X Number of Records « Jeff Prom's SQL Server Blog
by Bo Jensen •
In SQL Server Reporting Services you can add a page break after a desired amount of records. Here is how you do it.
Microsoft Dynamics Ax, SQL Reporting Services
Dynamics AX: Calling a Custom Dynamics AX 2009 SSRS report and passing parameters – From X++
by Bo Jensen •
I found this great example on http://dynamics-ax.blogspot.dk/ on how to create a simple custom SSRS Report for Microsoft Dynamics AX.
Microsoft Dynamics Ax, SQL Reporting Services
Dynamics Ax Internals: Quick walk-through of developing a report in Ax2012
by Bo Jensen •
The following is a quick-and-dirty approach to building a basic SSRS report in Ax2012. This uses an Ax query as the primary datasource, and uses display methods on the table(s) to retrieve additional information. This is not an approach you should take for all reports, particularly those that require more complex calculations or parameters, but…
Microsoft Dynamics Ax
Debug managed code executing on a remote AOS in AX 2012
by Bo Jensen •
A new feature in AX 2012 is that some pieces of code are run on the server side (AOS) and are executed in managed code. For example X++ scheduled batch jobs are compiled to common intermediate language (CIL) before beeing executed on the AOS. This is the same for services code.
Microsoft Dynamics Ax
Debugging managed code in AX 2012
by Bo Jensen •
Since a lot of X++ code is now executed in CLR there should be a possibility to debug it. The standard AX debugger cannot help here since it is capable of debugging interpreted code only. However, Visual Studio 2010 can do the job.
Microsoft Dynamics Ax, SQL Reporting Services
Simple SSRS report example by using Ax-Query and Ranges
by Bo Jensen •
In this report I am going to use the Ax-Query in the SSRS business logic and report will be generated by using SSRS Business logic.
Microsoft Dynamics Ax, SQL Reporting Services
Use a Dynamics AX display method in SSRS report | Arjen Stolk
by Bo Jensen •
There are a lot of display methods that I would like to use in a SSRS report. Here is an example of the use of the display method ‘reservedPhysicalInSalesUnit()’ from the sales line. In order to use this method, you need to be able to identify the sales line. For this you need the SalesId…
Microsoft Dynamics Ax
How to Set the Query Range on a SSRS Report | Amir's Microsoft Dynamics AX space
by Bo Jensen •
I found a couple of examples on how to set the QueryRange on SSRS reports on Amir’s AX Space
Microsoft Dynamics Ax, SQL Reporting Services
Walkthrough: Creating a Report Bound to a Report Data Provider Class (X++ Business Logic) [AX 2012]
by Bo Jensen •
In this walkthrough, you use a report data provider (RDP) class with business logic to process data and then display the outcome of the business logic on a report.