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

Add column to report in dynamics AX2009

Posted on 2011-02-21
Last Modified: 2012-05-11

How can I add a column LedgerTrans.DocumntNum to Report "BankAccountStatment" in Dynamics AX 2009?
Question by:smetechit
  • 2

Accepted Solution

agusacil earned 500 total points
ID: 34950262

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.

Author Comment

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

Expert Comment

ID: 34958978

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
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…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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