How to add a new field in Sales Quotation Report in AX2012?

Latest Axapta / Dynamics AX FAQ Pages

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Not Verified) This post has 0 verified solutions | 8 Replies | 5 Followers

79 Posts
832 Points
Joined: 2012-9-25
Last Online:
2014-7-7 15:15
Balu posted on 2013-2-12 14:01

Hi,

Now I am working in Sales Quotation Report Customization in AX 2012. I am adding 2 fields(DlvMode,DlvTerm) in SalesQuotationHeaderTmp Table and assign these 2 fields in salesQuotationDP class(setSalesQuotationHeaderTmp method)

SalesQuotationHeaderTmp.DlvMode = CustQuotationJour.DlvMode;

SalesQuotationHeaderTmp.DlvTerm = CustQuotationJour.DlvTerm;

And I am placing this 2 fields in Report and deploy it.

next I run the report it gives error: SalesQuotationHeaderTmp.1.DlvMode does not exist in the report data provider Table                                                                                                                                                                                       SalesQuotationHeaderTmp.

I am trying this fields in different systems, it gives the same error.

Please give a suggestion How to rectify this.

 

Thanks,

Balu

All Replies

Male
363 Posts
8,346 Points
Joined: 2011-7-25
Last Online:
2014-9-16 10:34
Location: Hyderabad, India
Solution (Not Verified) Vishal Tiwari replied on 2013-2-12 14:10
Suggested by Vishal Tiwari

Hi Balu,

Once generate the incremental CIL and try compiling the DP class.

Probably you would get it.

Regards,

Vishal Tiwarihttp://daxtechies.blogspot.in/

 

79 Posts
832 Points
Joined: 2012-9-25
Last Online:
2014-7-7 15:15
Balu replied on 2013-2-13 6:42

Hi Vishal,

Still I am facing the same problem after generate the incremental CIL and try compiling the DP class. The Delivery mode does not exist in reoprt data provider table. I think SetSalesQuotationHeaderTmp method in SalesQuotationDP class is a protected method. Remaining standard DP classes like SalesInvoiceDP, SalesPackingSlipDP classes having the private methods (insert into Tmp table).

So once you check  it the classes.

Thanks,

Balu

 

 

 

Male
363 Posts
8,346 Points
Joined: 2011-7-25
Last Online:
2014-9-16 10:34
Location: Hyderabad, India
Vishal Tiwari replied on 2013-2-13 7:01

Hi Balu,

Yes it is protected.

Also i found that table type property of this table is regular ( it should be either InMemory or TempDB).

So overall, i could say once try to make the table type is inMemory.

 

Regards,

Vishal Tiwarihttp://daxtechies.blogspot.in/

 

79 Posts
832 Points
Joined: 2012-9-25
Last Online:
2014-7-7 15:15
Balu replied on 2013-2-13 7:25

Hi vishal,

All most all Standard Tmp Tables are Regular.

Already I had change the tmp table property to TempDB, it gives the error.

It's not a solution for this issue.

 

Thanks,

Balu

 

 

Male
311 Posts
3,922 Points
Joined: 2010-7-23
Last Online:
2014-6-25 10:45
Location: Chennai
Solution (Not Verified) Saju K replied on 2013-2-13 8:36
Suggested by Saju K

Hi,

       Try to generate full CIL.

       And restart the SSRS (Start > Sql server 2008 R2 > Configuration tools > Reporting services configuration manager (Stop and start))

2012 PO

480 Posts
4,827 Points
Joined: 2012-11-4
Last Online:
2013-7-29 23:26
Location: Hoboken New Jersey
Patrick Am replied on 2013-2-15 16:03

Hi Everyone, I am new to making any changes to this report layout (so pardon me if i ask a dumb Q). Say, if I need to change the label "Sales Quotation" to something like "Customer Sales Quotation" how could I do that? Do I still need to use VS? 

2). Is it possible to print the report in Landscape as I see most of the report print in portrait? 

3) I have some experience with business intel dev studio 2008 where I have customized the report for Dynamics CRM. Is that the same approach here?

4) I notice mentioning of classes - So does it mean, we need to make the code level changes and if so, how could I be able to figure out which class is behind each existing field or for adding new fields how could this be done?

appreciate your inputs. Many thanks  

76 Posts
704 Points
Joined: 2012-6-21
Last Online:
2014-9-9 11:18
Location: Bangalore India
Solution (Not Verified) Zahir Hussan M replied on 2014-2-19 14:53
Suggested by Zahir Hussan M

Hi,

  This is usually happened because of refresh issue.

1. Try to synchronize the table which is related to your report.

2. Compile the classes which is related to your report.

3. From VS , try to refresh the dataset and check whether the RDP class included your new field.

4. If YES, try to deploy your report from VS. (Before deploying, try to delete the user caches and web report from internet explorer)

5. Try to open from Ax client.

 

Regards,

Zahir

Male
81 Posts
1,196 Points
Joined: 2011-8-12
Last Online:
2014-9-15 9:28
Location: Chennai,India

Please restart the SQL Reporting Service.

 

Thanks & Regards,

Britto John Baskar.A

Page 1 of 1 (9 items) | Get this RSS feed | Bookmark and Share