Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Dynamics AX 2012

Item Group is not specified Dynamics Ax 2012

by

Until and unless you have not good grip on functional side, you are unable to deliver customization. This idea constantly grow in mind and now started to grow as fear,

What if the functional consultant is not available or not provide good testing. And your piece of Code breaks in Production.  In ERP things goes beyond unit testing, We need extensive scenario based testing. In ERP development is easy, but covering all possible scenarios is tough, you have to grow functionally.

 

So I started to explore functional side by my own. And small issue starts to popup and now I started to document as I faced them 1 by 1 during learning process.

 

So I got very small issues. When I tried to use a newly created item in purchase line.

Item Group is not specified for item.

 

 

 

It took me almost 10-15 minutes where is the Item group in Release product detail form.

 

I found it in Manage Costs fast tab.

Process upload jobs encountered ProcessSourceRequestHeaderException Dynamics Ax 2012 R3.

by

After completing VAT patch in Dynamics Ax 2012 R3, We got error in Retail Process job.

 

Process upload jobs encountered ProcessSourceRequestHeaderException. Error Details: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessSourceRequestHeaderException: ProcessSourceRequestHeader failed to execute all delete requests —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessReadRequestsException: Read request num: 1 on table:[ax].[RETAILFISCALDOCUMENT_BR] failed to execute. —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Query: SELECT [ACCESSKEY],[AUTHORITYCODE],[CHANNEL],[CONSUMEREFDOCINQUIRYURL],[CONTINGENCYDATETIME],[CONTING FROM [ax].[RETAILFISCALDOCUMENT_BR] WHERE [ReplicationCounterFromOrigin]>@__scSqlFilterParam0 AND [ReplicationCounterFromOrigin]<=@__scSqlFilterParam1;;

ParamNameList: ;

ParamValueList:  —> System.Data.SqlClient.SqlException: Invalid column name ‘EFRREGISTERNUMBER’.

Invalid column name ‘FISCALESTABLISHMENTTRADENAME’.

Invalid column name ‘ORIGINALDISCOUNTAMOUNT’.

Invalid column name ‘SENDBYEMAIL’.

Invalid column name ‘SOFTWAREHOUSECNPJ’.

Invalid column name ‘TAXAUTHORITYINFO’.

Invalid column name ‘THIRDPARTYFORMATTEDADDRESS’.

Invalid column name ‘THIRDPARTYICMSCONTRIBUTOR’.

Invalid column name ‘THIRDPARTYIE’

 

 

Yes one thing is clear that some fields in missing In Retail store database. On opening in AX, The same table has more fields then retail store db, these fields came with Patch. Some Sync problem.  So I have to follow these steps to complete the sync

 

Retails==> setup ==> Scheduler subjobs.

 

 

Scheduler Sub jobs select the required table and click on Transfer folder list

 

 

 

Functions => mapping.

 

Click on Yes

 

Run the process job, error is gone.

Update Has been Cancelled, Sale Order Invoice Dynamics Ax 2012 R3

by

I was got following error on test server.

 

“Update Has Been Cancelled”

 

I just fixed the Error with following article.

From <https://stoneridgesoftware.com/update-has-been-cancelled-error-when-generating-a-purchase-order-invoice-in-dynamics-ax/>

 

Posted by

 

Eric Meissner

 

I used to write post, which 100 % true what Gary Vaynerchuk Once said ” Document don’t create”.

 

The whole idea of creating vs Documenting is interesting. Yes I am doing Documenting.

According To Gary

 

 

In very simple terms, “documenting” versus “creating” is what The Real World and the Kardashians is to Star Wars and Friends. And don’t get confused—just because you’re “documenting” doesn’t mean you’re not creating content. It’s just a version of creating that is predicated more on practicality instead of having to think of stories or fantasy—something that’s very hard for most people (including myself).

 

From <https://www.garyvaynerchuk.com/creating-content-that-builds-your-personal-brand/>

 

 

Domain role with multiplicity 0..1 or 1 can hold at most 1 link Dynamics Ax 2012 R3

by

I just applied the patch. After resolving all errors, I got errors when I try to refresh DataSet in Report designer. I added the new custom fields in temp table.

 

I got this error

 

 

I follow http://axdax.blogspot.com/2015/11/Domain-role-with-multiplicity-0..1-or-1.html

 

Which described as Follow

 

 

  1. Change the datasource type to Query.
  2. Delete the whole query text in the “Query” field.
  3. Save, rebuild and change the values on the datasource back to the ones intended

 

This results number of ambiguous report parameters. If you can delete old parameters and use new, It will perfectly fine. Its works for me. But it creates problem where report has multiple DataSet ie. PurchOrderconfirm report.

What I configure that there is version difference of report’s dataset and temp Table returned by DRP report. So I revert back report and dataset and First I compiled the temp table and then synchronized it. After that I refreshed the DataSet. The error removed. Later I added custom fields in Temp table and refresh the data set. Report successfully shows the custom report.

Best why, export last version of both report and Temp table. Compile and refresh the report dataset. After that start adding custom filed and refresh data set.

Team Explorer for Microsoft Visual Studio 2012 not found for Code merge Dynamics Ax 2012 R3 apply update

by

I was apply patch on Dynamics AX 2012 R3. During update checklist process. I found, Code merge check box was disabled. Message described that we need Team Explorer for Microsoft Visual Studio 2012 to enable it.


Microsoft Official download link was not working.  I downloaded it from here, And it works for me.

https://download.freedownloadmanager.org/Windows-PC/Team-Explorer-for-Microsoft-Visual-Studio-2012/FREE-

 

Remember, the above link is unauthenticated and third party, download it on your own risk. But some how the other we need to download it.

Relation between VendPackingSlipJour and PurchParmTable Dynamics Ax 2012 R3

by

Couple of days ago, I was helping a young developer. Who was doing some customization. He added some customization in PurchParmtable and want information in VendPackingSlipJour Table.

It was very strange that there is no direct relationship between vendPackingSlipJour and  PurchParmTable.

 

After Exploring I found that There is ParmId field in VendPackingSlipVersion table.

And we can get VendPackingSlipVersion by static method with PurchId and PackingSlipId, DeliveryDate.

 

This ParmId has relation with PurchParmTable.

I wrote down following code snippet to get Value from PurchParmTable, with respect to VendPackingSlipVersion.

 

 

 

display real _netWeight()
{
PurchParmTable _purchParmTbl;
parmid _id;
_id=VendPackingSlipVersion::findFromInterCompanyPackingSlip((this.PurchId),
(this.PackingSlipId),(this.DeliveryDate)).ParmId;
select *from _purchParmTbl where _purchParmTbl.ParmId==_id;
return _purchParmTbl.NetWeght;
}

 

Hopes this help

ODBC connection and Null value Handling Dynamics Ax 2012 R3.

by

Today I have very small tip to share. I noted down, some odbc connection posts in my blog. All these post shares the code snippets , that used to open odbc connection and did query on SQL server directly. Couple of days ago, I need similar code snippet to read data from SQL server and Insert into another connect. But that code did not had reference to handling null values. So I note down that code snippet too, for future reference.

 

These all odbc connection , command return results in “ResultSet” class.

 

This ResultSet  class has method  “wasnull”. According to documentation, its behavior is strange. First we have to call the get method and then we call “WasNull” to verify that value appears is null or not.

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

 

So whole code snippet will be like.

public void run()
 

{

Connection Con = new Connection();

ResultSet R;

str sql;

Statement Stmt;

SqlStatementExecutePermission permission;

Real _RealValue;

sql = "SELECT * FROM InventTrans ";

Stmt = Con.createStatement();

permission = new SqlStatementExecutePermission(sql);

permission.assert();

R =Stmt.executeQuery(sql);

 

while ( R.next() )

{

_RealValue =R.getReal(1);

if (  R.wasNull(1) ==boolean::false)

{

 

info (" Not null");

}

Else

{

Info (" Null ");

}

 

 

 

}

CodeAccessPermission::revertAssert();

 

}

Relation between PurchLine and PurchReqline Tables in Dynamics AX 2012 R3.

by

In one of SSRS Report requirement, client wants to see Purchase order quantity, Invoice Quantity against items purchase requisition Quantity.

 

Instead of writing a query on ItemId and InventdimId, I found out of the box function In PurchReqLine table. This method return the reference of Purchline. With reference of Purchline, I can get Purchase order Number and get Item Invoiced quantity.

 

PurchLine       purchLine;

PurchReqLine reqline;

 

_purchLine = reqline.purchLine();

 

 

The relationship between Purchline and PurchReqline is RecId, Purchline contains the Reference RecId of PurchReqline.

 

PurchLine       purchLine;

 

if (this.PurchId && this.LineRefId)

{

select firstonly purchLine

where purchLine.PurchId           == this.PurchId    &&

purchLine.PurchReqLineRefId == this.LineRefId  &&

!purchLine.IsDeleted;

}