Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Dynamics Ax 2012

The formatter threw an exception while trying to deserialize the message Dynamics Ax 2012 R3 SSRS

by

On running report, following error message appear in info box.

The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was ‘Element ‘http://tempuri.org/:queryBuilderArgs’ contains data from a type that maps to the name ‘http://schemas.datacontract.org/2004/07/XppClasses:SrsReportProviderQueryBuilderArgs’. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver if you are using DataContractSerializer or add the type corresponding to ‘SrsReportProviderQueryBuilderArgs’ to the list of known types – for example, by using the KnownTypeAttribute attribute or by adding it to the list of known types passed to the serializer.’. Please see InnerException for more details.

2016-12-06_9-58-01

 

Solution:

  • Stop AOS service.
  • Stop Sql Server Service.
  • Start SQL server Service.
  • Restart SQL Server reporting services.

 

 

Time field on SSRS shows time format Report Dynamics Ax 2012

by

Today is another small tip,

I was developing a custom report. Queried table stored the date and time in separate fields ie. Transdate and transtime. On  mapping the transtime to report, its showed time format. Instead of time value.

2016-10-28_19-18-27

For it solution, I added the string field on report temp table and then convert the time with time2str function and map to the field.

Complete statement is below.

TableTmp.StransTime  = time2Str(_Trans.transTime, TimeSeparator::Colon, TimeFormat::AMPM);

 

As result, report will display the trans time instead of its format.

2016-10-29_1-56-07

Display methods in Report SSRS Dynamics Ax 2012 .

by

Hi, All, today I have to modify the report. Interestingly this report was built on AOT Query, instead of Data provider class. Current Scenario I was working on Worker Report. The requirement was to show’s primary position and department. HCMWorker table has two display method returns these values.

We can add these display methods into reports by following way.

For example I am modify the out of the box HCMWorkersHiredInPeriod Report.

 

2016-06-13_15-25-16 2016-06-13_15-25-51

 

2016-06-13_15-47-15

 

ddd

 

 

 

 

 

Now Problem appears, we need different values then provided by out of the box display methods. For example we need Position Title instead of Primary Position Id. for this Add new display method that will return the Position Title instead of Position Id, compile table synchronize table, restore the AOT Query and refresh the report data Set. If there is no error in your working environment you will find required methods in report Data set.

 

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists. Dynamics Ax 2012

by

Hi, All today I got error while creating Leger entry

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

I found some issue with free sequence number in NumberSequenceList . I manually delete the free sequence number with following statement.

static void Job14(Args _args)
{
NumberSequenceList list;

while select forUpdate * from list where
list.NumberSequenceId ==5637145445 && list.Status ==NumStatus::Free
{
ttsBegin;
list.delete();
ttsCommit;
}

}

 

I got again got help from Andre answer on dynamics Ax community

Reference: https://community.dynamics.com/ax/f/33/t/138926

Workflow status and comments Query Dynamics Ax 2012.

by

 

I have to explore Out of the box workflow status and comments.  After dig down, I found following three tables are important to get all information.

 

WorkflowTrackingCommentTable

WorkflowTrackingStatusTable

WorkflowTrackingTable

 

 

Reference of row on which workflow is applied or run can be found workflowTrackingStatusTable two field ContextRecid and ContextTableId

SSRS for Dynamics Ax 2012, group sum based on condition

by

Small tip today, In one of my custom SSRS report for Dynamics Ax 2012 on group total, requires conditioning,
For example sum did not include the value in the based on certain value of other field.

I used following expression to solve this problem.
=Sum(iif(Fields!FieldName.Value <> “abcdxyz”, Fields!FieldName.Value, CDbl(0)))
I took help from following link:

http://www.sqlservercentral.com/Forums/Topic1174757-150-1.aspx

Git with Dynamics ax 2012

by

Recently I explored GIT as source control tool. As per work with Microsoft Technologies I worked with TFS and Source save.  In Dynamics Ax 2012 context I found AX2GIT on codeplex and

https://github.com/Go-ERP/Ax2Git/wiki

https://github.com/Go-ERP/Ax2Git

https://ax2git.codeplex.com/

 

I download ax2git zip. After extraction I found  XPO.

ssss-001

 

So I decided first to download its perquisites. i.e. Git and tortoise for Git. I used following links

Git from   http://msysgit.github.io/

 

Tortoise Git from http://tortoisegit.org/

 

After Installing tortoise and Git, windows right click popup menu shows me  git and tortoise options as follow

www

 

 

To check git works, I create a new folder and create Git Repository there by windows right click popup menu.

 

Following popup appeared

333

After click on ok, I found following pop up to show success message

ss

 

 

Now I opened Dynamics ax and import the ax2GIt.xpo

 

 

 

Import it, it overwrite some Ax artifacts.  When Xpo successfully imported, right click on any node in AOT => add-ins have Git menu.

 

Git

 

 

 

 

Currently Ax2Git support only export.

I opened one of my existing project and export it GIT options. Right click on project node when project open with all its detail. And click on add-ins=>Git=> Export AOT selection.

2016-04-05_12-58-10

 

And click on Export AOT selection

welcome to the world of git

 

As I am working Dynamics Ax 2012 CU8 demo vm so current layer option will.  Other as per documentation, it will create separate branch for each layer.

Export to folder process starts

process

And I target folder I found folders in all files are exported properly.

It will creat

 

 

Selected all folder and commit the changes.

 

asdsa

 

 

 

 

All files are successfully committed.

 

For testing it reflect changes, I open Ax form and add following empty comment in one of the form

2016-04-05_13-11-50

 

On again export project from AX. Repository folder it shows some changes are not commit.

Reflect changes

On checking the right click to see the diff
reflect 2-001

Yellow highlighted items line it shows the difference, what previously checked in new exported code

2016-04-05_13-23-28

 

Labels migration from one environment to other Dynamics AX 2012

by

Usually I forget this step during code migration from environment to other. So I note it down for future reference.

The best way to move labels from environment to copy the *.lac file form location

C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\Application\Appl\Standard

And paste on some common folder in target environment.

And then import it by right click on aot => labels =right click and create from file.

new enviroment

Excel power query with Dynamics Ax 2012 R3

by

 

End user in Pakistan industry love the Excel. I worked in local Pepsi franchise for two years. Everything they need raw data or reporting data into excel. They called it cycle. Because their office work cycle starts and end on excel. How much complex report you developed for them, if it not converted into excel it is useless (I was working in Oracle 6i reports at that time). So recently I decided to explore excel power query that helps to extract complex data from AX to excel. Later user can easily convert or format according to his / her needs. So here are some my key notes to connectivity with Excel power Query.

Currently for this article I used demo data and Microsoft demo vm AX R3 cu9.

For Excel power Query you have to download add in from following link. It works fine for excel 2013.

https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=be43bca0-3131-4c19-940f-f3d4f441efa2

 

When you open the above link in browser following screen will open

Download Link

Click on download button. Following screen will open

2016-02-19_10-27-38

As per my machine has 64 bit version of excel so I download 64 bit version of it.

 

After download run it setup.

2016-02-18_12-07-31

Click on next

2016-02-18_12-08-21

Click on next

2016-02-18_12-22-34

 

Finally click on finished button.

 

Now open Excel and you find following new tab will be added on tab strip.

2016-02-18_12-27-38

If you did not find this tab in excel. Check the excel option and enable power query add-in. You can possibly found it at this location.

2016-02-18_12-25-12

Now its time to connect excel with Ax. For this you have to verify that you AIF services are successfully configured and deployed on AX. If not then generate incremental CIL to verify that no error in your environment and AIF services are successfully working.

Now open Ax client and go in organization administrator module. You can follow menu link as

Organization administrator =>Setup=> Document management=> Document data source

2016-02-18_15-33-04

On click on it you found following form.

2016-02-18_15-33-52

As I am going to test on out of the box Query so I decided to use “USSalesUSMF2011”. You want to use your own query then select it in above screen and also activate it.

 

Now switch back to excel and from Power Query tab select  “From Other Sources” => “From OData Feed”

2016-02-18_15-36-07

From new screen select following Ax Query service with default url

http://localhost:8101/DynamicsAX/services/OdataQueryService

Query address will be vary if you are using excel add in on client and AOS on some other location.

2016-02-18_15-37-07

Click on Ok. From next screen click on windows screen. As I am trying to connect on demo machine with default admin user so I select my current credentials. Otherwise you have to create a user in AX and he has to write Access on ODataQueryService and all tables in side Query to fetch data.

2016-02-18_15-38-08

 

Click on next  you find navigator from

2016-02-18_15-43-13

Select required query. And click on ok.

You find data against query in Excel as following

2016-02-19_10-23-49

 

Now if you expert in excel, you can make magic from here.

 

exception has been thrown by the target of an invocation Dynamics Ax 2012 R3

by

A few days ago I face again the old error “Exception has been thrown by target of an invocation.

This time this error did not let us do anything on client.

2016-02-01_11-57-33

 

 

Finally I found that AOS server Configuration utility, database server is set as Server Name for example as “DB server” instead of  server IP. When sometimes Database server name is resolved by network configuration, AX working fine and some time when it unable to resolve the server IP with its name “Target of Invocation” error appears. On opening the AOS server configuration utility i found following error

Prod

 

When I click the ok button, AOS server configuration utility did not open, it shown in windows task management. So I kill its instance. Then Stop the AOS service form windows services management. Again open AOS server utility, it opened with in a few minutes (Still takes time). Then I create a new active configuration. And replace database server name with its IP. for example Instead of Database server name “DB server” I used the “192.168.1.1”. Save the settings and start the AOS service.  AX working fine and error disappears.