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

(0) Share

Report

Posted on by Community Member 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

All responses (3)

Answers (2)

Community Member Microsoft Employee on at

Like (0)

Report

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 46,610 User Group Leader on at

Like (0)

Report

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 1,450 on at

Like (1)

Report

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.