Error while printing Sales Invoice

(0) Share

Report

Posted on by Community Member

I am getting following error while printing Sales Invoice in AX 2012 R3:

The query could not be processed. The field(s) SalesInvoiceHeaderFooterTmp.1.CompanyBranch_TH do not exist in the report provider table SalesInvoiceHeaderFooterTmp.

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (1)

Sort by

raelhefn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

compile this report it will give you missing field. add this field to your report.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear Ramy,

Thanks for the reply.

I have compiled all the reports and I am not getting any error.

Thanks

Birva

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

try to refresh the cache

Tools > Caches > Refresh Directory

Tools > Caches > Refresh Data

Tools > Caches > Refresh Elements

Please verify and update us if this helps you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I refreshed them all, but still facing the same error.

When i checked the SalesInvoice.rdl file, there is a field SalesInvoiceHeaderFooterTmp.1.CompanyBranch_TH but the same field is not available in the table SalesInvoiceHeaderFooterTmp when i checked the database.

Was this reply helpful? Yes No
Suggested answer

venkatesh vadlamani 3,180 on at

Like (0)

Report
Copy link

Link copied!

Do you have this field in the table mentioned in error?

Go to report datasource in VS and refresh it.Save and delete from report server and deploy again.Seems to me that report data source is not in sync with ax table its pointing to

Regard

Venkatesh

Was this reply helpful? Yes No
Suggested answer

Dhanasekar 190 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In Visual studio remove the "SalesInvoiceHeaderTmp " data set and again add the Data set with same table and same name.after adding the Data set compile and deploy the report.

regards

Dhanasekar S

Was this reply helpful? Yes No
Suggested answer

Abhimanyu Naruka 160 on at

Like (0)

Report
Copy link

Link copied!

After doing these steps. Finally i would suggest you to restart you reporting server and AOS. this will resolve your problem.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi

From the report server, i downloaded the rdl file and could open it in VS as xml.

I am not able to view the report datasource in VS.

I am new to this.

Can you please provide me a step-by-step guide.

Thanks

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report
Copy link

Link copied!

This will help:

community.dynamics.com/.../developing-a-ssrs-report-using-the-report-data-provider-in-microsoft-dynamics-ax-2012.aspx

Was this reply helpful? Yes No
Khurram 655 on at

Like (0)

Report
Copy link

Link copied!

Please let me know the solution which resolved your problem, I'm facing same problem. And applied many resolutions by adding required field in SalesInvoiceHeaderFooterTmp table but one after another issue is reported for many fields but problem not resolved. This seems standard bug from MS.

Was this reply helpful? Yes No