web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Add Text field in Bank Statement Report from BankAccountTrans Table

(0) ShareShare
ReportReport
Posted on by

I want to add the Text field in the Bank Statement Report. I have tried to add that by inserting in the CreateBankAccountStatementTmp method, But in Vain

Need Urgent Help.Where to write the code for that Text field !!

Regards

ANK0409

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Hakim Profile Picture
    17,887 on at

    you need to fetch this field in your DP class also

  • Community Member Profile Picture
    on at

    Hi Mahmoud

    I have written that in The BankAccountStatementDP Class in the CreateBankAccountStatementTmp method where all the other fields are getting inserted

    but text field data is coming as blank

    Regards

    Ank0409

  • Suggested answer
    Mahmoud Hakim Profile Picture
    17,887 on at

    can you clear caches from tools crashes and  preview  this report  in visual studio

  • Suggested answer
    Faqruddin Profile Picture
    1,883 on at

    Bank Statement Report data source is query based report. You will not found DP class for Bank statement Report. If you wants to customize the report here is screenshot of the query.

    8255.bank.jpg

  • Community Member Profile Picture
    on at

    I have tried to add the text field in the BankStmtISOAccountStatement as specifeid by you in the query.still Not getting the data

    Regards

    Ank0409

  • Community Member Profile Picture
    on at

    Yes I have cleared all the cache from AOT and also reset the Usage data but still getting text as blank.

    Regards

    Ank0409

  • Suggested answer
    Faqruddin Profile Picture
    1,883 on at

    Please confirm your report name. Bankstatementreport or Bank Account Statement Report ? or Confirm report location in the system ?

  • Community Member Profile Picture
    on at

    Sorry, The Menu Item Name is Bank Statement under Cash & Bank Management--> Reports-->Transactions-->BankStatement

    Name of Report is "Bank Account Statement Report"

    Regards

    Ank0409

  • Suggested answer
    Faqruddin Profile Picture
    1,883 on at

    Check my screenshot. And add Txt field as I shown then add to your design. Txt field read the data from BankAccountTrans table. 

    banks.jpg

  • Rafael Araujo Profile Picture
    183 on at

    I have the same issue... how do you solved it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans