Tuesday, June 27, 2017

Deploy Report through x++ code

Here is the code to deploy SSRS report in Microsoft Dynamics AX.

static void deployReport(Args _args)
{
    SRSReportManager srsRptMgr = new SRSReportManager();
    SSRSReportConceptNode node = new SSRSReportConceptNode();

    node = TreeNode::findNode(@"\\SSRS Reports\Reports\SalesInvoice");

    srsRptMgr.deploymentStart();
    srsRptMgr.deployReport(node);
    srsRptMgr.deploymentEnd();
}

Refresh,Reread,Research,ExecuteQuery in dynamics AX

Refresh,Reread,Research,ExecuteQuery in dynamics AX
1. Refresh()
refreshes the user view with whats stored in the caches. This does not touch the DB.
Use this after any form change has been made through code.
2. ReRead()
 fetches only the current record from database and does not re read the complete datasource.
Use this when you need to update only the current record after modifying any value.
3 . ReSearch() 
  will execute the same query again and fetch the results from the database.
Use this if you need to get the current most data from database.
4 . ExecuteQuery()
 will run the query again just like research does but it will also take any query changes into account.
Use this is you have modified the query on run-time and need the updated results according to the new query.

Difference among Research() and Research(true) in AX 2012

Difference among Research() and Research(true) in AX 2012

Research
Calling research() will return the existing form query against the database, therefore updating the list with new/removed records as well as updating all existing rows. This will honor any existing filters and sorting on the form, that were set by the user.
Research(true)
The research method starting with AX 2009 accepts an optional boolean argument_retainPosition. If you call research(true), the cursor position in the grid will be preserved after the data has been refreshed. This is an extremely useful addition, which solves most of the problems with cursor positioning (findRecord method is the alternative, but this method is very slow).

Unit of Work Framework in Microsoft Dynamics AX 2012

Unit of Work Framework in Microsoft Dynamics AX 2012

Unit of Work Framework is use to commit number of records in a single Transaction. The main reason for introducing unit of work is that it is impossible to insert the lines table record before its header table because there is a relation between the header table and the lines table. The “Recid” of the header table is comes as a foreign key in the child table.

Let’s took an example as you can see in the Microsoft dynamics ax there are two tables i.e. MTQUnitOfWorkTable and MTQUnitOfWorkLine. These two tables are related with each other “MTQUnitOfWorkTable” is the parent table and “MTQUnitOfWorkLine” is the child table.

As you can see in the below image about these two tables and there relations.




“CreateNAvigationPropertyMethods“should be set to Yes         
Then create Class name as “MTQDemoClass” and then add Method, and write following piece of code.


Now Create New Job, call “demo” method.

Result: You can see that the records are crated in the child table having the id of the parent table

References:

https://msdn.microsoft.com/en-us/library/gg846338.aspx

Create Purchase Requisition through x++

Here is the code for creating purchase requisition through x++

public static void createPurchaseReq (Args _args)
{
    PurchReqTable   purchReqTable;
    PurchReqLine    purchReqLine.;
 
    purchReqTable.clear();
    purchReqTable.initValue();

    purchReqTable.PurchReqId    =                                NumberSeq::newGetNum(PurchReqTable::numRefPurchReqId()).num();
    purchReqTable.PurchReqName  = 'Requisition';

    purchReqTable.insert();

    purchReqLine.clear();
    purchReqLine.initValue();

    purchReqLine.InventDimId = 'Dim-0001';
    purchReqLine.LineNum     = 1;

    purchReqLine.initFromPurchReqTable(purchReqTable);

    purchReqLine.ItemId              = 'Test-001';
    purchReqLine.BuyingLegalEntity   = CompanyInfo::find().RecId;
    purchReqLine.InventDimIdDataArea = curext();
    purchReqLine.PurchQty            = 2;

    purchReqLine.modifiedField(fieldNum(purchReqLine,ItemId));
 
    purchReqLine.insert();
 
}

Error 1 Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)

You get the error when trying to deploy a report either by using VS2013 reporting tool or through AOT


The "GenerateRdlTask" task failed unexpectedly.
System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)

Resolution:
1. Go to Control Panel\System and Security\System
2. Open Advanced system settings and open Environment Variables
3. Create a New Variable
4.Variable name: COMPLUS_LoaderOptimization ; Variable value: 1
5. Click OK
6. Logout from the server and logon again.
7. Open the report using Visual Studio 2013 and deploy the AX report.
8. The report can also be deployed from AOT


Create Sales Order through code

I found few good sample code for creating sales order in a book and I was able to compile a code for posting sales order invoice. I thought I should share on my blog. It might be useful for some one.
Code for creating Sales order
SalesTableType and SalesLinetype. Insert() should be called for creating the sales order. Example is as follows. I am currently looking for code that can contains example code of creating invoice from scratch. I will send you the code in an hour.
static void createSalesTable(CustAccount _custAccount)
{
SalesTable salesTable;
NumberSeq NumberSeq;
;
NumberSeq =
NumberSeq::newGetNumFromCode(SalesParameters::numRefSalesId
().numberSequence);
salesTable.SalesId = NumberSeq.num();
salesTable.initValue();
salesTable.CustAccount = _custAccount;
salesTable.initFromCustTable();
salesTable.insert();
}
Example: Create a Sales Line
static void createSalesLine(SalesId _salesId, ItemId _itemId)
{
SalesLine salesLine;
;
salesLine.clear();
salesLine.SalesId = _salesId;
salesLine.ItemId = _itemId;
salesLine.createLine(NoYes::Yes, // Validate
NoYes::Yes, // initFromSalesTable
NoYes::Yes, // initFromInventTable
NoYes::Yes, // calcInventQty
NoYes::Yes, // searchMarkup
NoYes::Yes); // searchPrice
}
Code for posting Sales order Invoice
static void createSalesOrder(Args _args)
{
SalesFormLetter formLetterObj;
formLetterObj = SalesFormLetter::construct(DocumentStatus::Invoice);
formLetterObj.update(SalesTable::find(“SO-101248”));
}