AX – D365FO – Importing CSV Using RunBaseBatch X++

class ImportCsv extends Runbasebatch { Filename ItemFileName; Filename filename; DialogField dialogFilename; #define.CurrentVersion(1) #define.Version1(1) #localmacro.CurrentList fileName #endmacro } public Object dialog() { DialogRunbase dialog = super(); dialogFilename = dialog.addField(typeId(FilenameOpen)); dialogFilename.value(filename); return dialog; } public boolean getFromDialog() { fileName = dialogFileName.value(); return super(); } void ImportInventtable() { CommaIo file = new commaIo(ItemFileName,'r'); Container con; InventTable inventTable; int … Continua a leggere AX – D365FO – Importing CSV Using RunBaseBatch X++

AX – D365FO – Error : “Access denied to method processreport in class” in AX2012

"If the permission node under the design of the SSRS report seems OK you can try to export and re-import the SSRS report by XPO. For me, it solved the problem (on AX2012 R2 CU7) without having to add any permission on roles or privileges. Under the hood, we found out that re-importing the report … Continua a leggere AX – D365FO – Error : “Access denied to method processreport in class” in AX2012

AX – D365FO – Calling an External Web Service from X++ in AX2012

You can use the Bing ™ Search service API to include search functionality in your Microsoft Dynamics AX application. You use the Application ID from Bing to create a service reference in a project in Visual Studio and then add the project to the AOT. Then you call the search service from X++ with a … Continua a leggere AX – D365FO – Calling an External Web Service from X++ in AX2012

Create Application user in Azure for use in Dynamics 365

When using multifactor authentication for your Dynamics 365, it tends to cause issues with the KingswaySoft connector, as MFA is not supported by their toolkit. Therefore – as an alternative to disabling the MFA – you can switch to OAuth authentication in the KingswaySoft connection manager and connect with a Azure Application user, and I … Continua a leggere Create Application user in Azure for use in Dynamics 365

AX – D365FO – Error : Setting Server Report parameters in Ax 2012 (rsItemNotFound)

Scenario: when I am trying to open a report in AX 2012  R2 CU7 it is displaying an Infolog with an error. "Error while Setting server Report parameters and the report cannot be found(rsItemNotfound)" Solution: Make sure that the reports are deployed and all are in the correct layer. In order to deploy a report, procedure is Open a … Continua a leggere AX – D365FO – Error : Setting Server Report parameters in Ax 2012 (rsItemNotFound)

AX – D365FO – Request for the permission of type ‘SqlStatementExecutePermission’ failed.

While running one Job , where I was trying to execute one SQL statement in AX, I got the below stack trace : Request for the permission of type 'SqlStatementExecutePermission' failed.(S)\Classes\SqlStatementExecutePermission\demand(S)\Classes\Statement\executeQuery(C)\Jobs\test - line 21 So what is the solution for this , Very simple , we need to run this job on Server , So … Continua a leggere AX – D365FO – Request for the permission of type ‘SqlStatementExecutePermission’ failed.

AX – D365FO – Executing a direct SQL statement

This recipe will demonstrate how to execute direct SQL statements. We will connect to the current Dynamics AX database directly using an additional connection and will retrieve the list of vendor accounts. How to do it... Open AOT, and create a new class called vendTableSql with the following code: class VendTableSql { } server static void main(Args … Continua a leggere AX – D365FO – Executing a direct SQL statement