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
@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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156