no report data table with name exists in report schema for data provider

I was getting the following error message when I move my already running report from Test Server to the Live Server.

After running the report on live server the error message was:

"No report data table with name MZK_ProductPriceHeaderTmp exists in report schema for data provider MZK_ProductPriceDP."

The Solution to this issue is that restart the reporting services running on this server and than clear cache and the usage data and than try to run the report again.

Thanks

Muhammad Zahid.

Changes in InventTrans Data Model in Microsoft Dynamics AX 2012 Version

After the upgrade from AX 2009 to AX 2012.My client has raised an issue that he was not able to select the delivery note and physical date from Stock Transactions table in selection criteria on the SalesEditLines Form.

After some research I found out that there is same change in InventTransData Model and thats why query associated to the SalesEditLines Form is also modified that's why user was not able to see the two fields as they were in AX 2009.

Below is the Screen Shot taken from AX 2009 of the form SalesEditLines Form:

Above form can be access through the below navigation path:

Account Receivable -> Periodic -> Sales update -> invoice

As you can see in the above image Stock Transactions table was available in selection criteria in AX 2009 but in AX 2012 it is change in the query associated to this form due to change in the data model of InventTrans.

Below is the link that contains the description of change in InventTrans Data model in AX 2012.

http://www.axpulse.com/changes-in-microsoft-dynamics-ax-2012-inventtrans-data-model/

Dynamics AX 2012 SSRS Report Parameter Label Truncate Issue

I was having an issue on SSRS report that label of my parameter was truncating.

The issue was that I was not using any Label Id for the parameter text.

Below are the steps to resolve this issue.

1. Creating a label with label id
2. Prefixing "literalstr()" around the label - e.g. SysOperationLabelAttribute(literalstr("@lbl001"))

Below is the link for more detail on this issue:

https://community.dynamics.com/ax/f/33/t/119603.aspx

Thanks

Muhammad Zahid.

Getting name of the Query Associated to the Form

There are many forms  in which user have the rights to modify the selection criteria on the form.

The forms that shows the selection criteria are basically associated with query.

Below is the navigation path of the form,I have took this as an example.

Go Account Receivable / Periodic / Sales Update / Invoice/

A form will open as you can see this in the below image.

 Now click on the select button.A new form will open this is basically the form where you can specify the selection criteria.

This form is basically based on the query i,e is associated to the form.

You can see the screen shot of this selection criteria form in the below image.

Now to find the query i,e bind to this form just right click it and and than select the personalize tab and than click advance tab and than see the field in the caller field.

The caller field contains the name of the query i,e  associated to this form.

You can see this in the below image.

Below is the query i.e salesupdatepackingslip associated to above form.

Thanks

Muhammad Zahid.

Progress Bar Indicators in Microsoft Dynamics AX 2012

To perform some data processing that takes large amount of time for example uploading data from Excel or exporting data to excel.We can show the progress bars to the users that data processing is under progress and remaining time etc.

Below is the link which shows the examples on how can we use the progress bars in Microsoft Dynamics Ax 2012:

http://msdn.microsoft.com/en-us/library/aa841990.aspx 

Thanks

Muhammad Zahid.

Installing Microsoft Dynamics AX 2012

Below is the link containing all the description related to the installation of Microsoft Dynamics AX 2012:

http://www.dynamicsaxtraining.com/dynamicsax-installation-configuration/installation


Thanks

Muhammad Zahid.

Create First Custom Service In Microsoft Dynamics AX 2012

There is very good blog available for creating the Custom Services in Microsoft Dynamics 2012.

http://sumitsaxfactor.wordpress.com/2012/05/19/create-your-first-custom-service-ax-2012/


One thing I just wanted to mention here that is not given in this blog is:

While consuming your newly created service outside AX in your C# or any other code you need to specify the company name in which your x++ service code will execute.

if just pass the code as mention in above blog post i.e

string[] custIds = servClient.retrieveCustomerNames(new SamCustomAXService.CallContext(), strItem);  

than your code will run in dat company which by default set in AX and it contains no data therefore it will not return any data which you want.

To run your x++ service code in your specified company than you have to create the object of call context and in that object specify your company. You can see the below code for reference.

In my case I have specified the ceu company.

 mzkCustomerService.CallContext context = new mzkCustomerService.CallContext { Company = "ceu" }; 

and than pass this context object in your code as below:

string[] custIds = servClient.retrieveCustomerNames(context, strItem);  
 

This was all related to the Custom Services.

Thanks

Muhammad Zahid.