Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Replicating the data in a field in one table with the same field in another table

Posted on by Microsoft Employee

Morning All,

Please I'm relatively new on this. I need to add a description field to the bank reconciliation report, I discovered that on the ledgerjournaltrans table, each voucher has a txt and the same voucher on the bankreconciliationtmp table is the same in the ledgerjournaltrans table.  I want the information on the txt field to show on the report, so I added the txt field to the bankreconciliationtmp table and created a relationship between them using txt, but I still cant see all the information on the txt field. 

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Replicating the data in a field in one table with the same field in another table

    @sohaib&Jesus, thanks alot, u both saved my day. I have now added the txt field to the report, but when I deploy the report this is what I get Error 1 "An exception occurred in the query metadata execution. The exception is Buffer for call of SRSTmpTblMarshaller::deleteTmpTblData is not specified.. BankReconciliation.Report [Preview] 0 0" I've generated incremental CIL , but still no help.

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Replicating the data in a field in one table with the same field in another table

    adding relationship with any table is not the solution for bringing data for a new field in AX-SSRS reports

    you have to modify your RDP class.

    In your case open class BankReconcilationDP. Go to insertBankReconciliationTmp(method)

    add you code there as under

    BankAccountTrans bankAccountTransBal;  //declare it at top as all variable declarations are at top in x++


    select bankAccountTransBal
            order by TransDate
            where bankAccountTransBal.AccountId            == bankReconciliationPrintoutTmp.AccountId
               && bankAccountTransBal.AccountStatement     == bankReconciliationPrintoutTmp.BankAccountStatementNum
               && bankAccountTransBal.AccountStatementDate == bankReconciliationPrintoutTmp.AccountStatementDate
               && (bankAccountTransBal.Included            == true ||
                   bankAccountTransBal.Reconciled          == true);
    bankReconciliationTmp.YourTextField = bankAccountTransBal.Txt; // value assignment

    you may modify code as per your needs

  • Verified answer
    Jesus R. ABASCAL Profile Picture
    Jesus R. ABASCAL 1,450 on at
    RE: Replicating the data in a field in one table with the same field in another table

    You have to fill the DP class that fill all bankreconciliationtmp before to print the report. I think it's BankReconcilationDP and then in the insertBankReconciliationTmp method insert a new line with TXT field.

    I hope it helps you.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans