Solved

Add column to report in dynamics AX2009

Posted on 2011-02-21
3
1,424 Views
Last Modified: 2012-05-11
Hello,

How can I add a column LedgerTrans.DocumntNum to Report "BankAccountStatment" in Dynamics AX 2009?
0
Comment
Question by:smetechit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
agusacil earned 500 total points
ID: 34950262
Hi,

In the BankAccountTrans table, you can create a new display method like this :

display DocumentNum documentNum()
{
    ;
    return LedgerTrans::findVoucherDate(this.Voucher,this.TransDate).DocumentNum;
}

Then add a new string control in the Body _2 in the BankAccountStatement with properties set as below :

Table : BankAccountTrans
DataField : <set to blank>
DataMethod : documentNum

Hope that helps.
0
 

Author Comment

by:smetechit
ID: 34951740
Thanks for your solution ... but how fields of BankAccountTrans are displayed in report without adding BankAccountTran as datasource?
0
 
LVL 4

Expert Comment

by:agusacil
ID: 34958978
Hi,

Thanks. If you don't want to have BankAccountTrans as datasource then you can create a display method in the report's methods section.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question