Notifications
Announcements
No record found.
Hello Everyone,
I have a requirement to add fields on the report, the fields we usually get from map to the temp table.
But whatever the fields that i have to add on report is not existed on map. so how to add the fields on map.
Thanks in advance
Hi Rafia,
Is it the map a part of standard D365 F&O, or have you developed a custom map for the report?
Hello Gunjan,
Its a standard map.
Last time we tried, we were not able to creating custom fields on a map. Please let us know the report and the map you are working with. Are these custom fields that have been created that you want in the report?
Map: BankPaymAdviceTmpMap
Report: MTBankPaymAdviceVendV2
TmpTable: BankPaymAdviceVendTmp
Just now i got some suggestion from my senior that, write it on on inserting event handler that was copied from BankPaymAdviceVendTmp, then populate the necessary fields in this method. may i know how to achieve. Thanks and i fields i need from VendBankAccount table(AccountNum, location,transdate) and primary email of the vendor. Thanks
Am still waiting for the reply, if any inputs on this please let me know. Thank you
You can create a CoC on the processReport method from the DP class and populate the additional fields as well. So you have the relation/conditions based on which you want to fetch records from VendBankAccount table?
No, i don't have relations related to vendbankaccount table
I am assuming you are going to use the Third party bank field in payment journal to get the details from VendBankAccount table,
From the report name, I assume you have duplicated the BankPaymAdviceVendV2 report. You can create a CoC on processReport method and use update_Recordset statement to update the required fields.
[ExtensionOf(classStr(BankPaymAdviceVendDP))] final class BankPaymAdviceVendDP_Extension { public void processReport() { BankPaymAdviceContract contract = this.parmDataContract() as BankPaymAdviceContract; LedgerJournalTrans ledgerJournalTrans = LedgerJournalTrans::findRecId(contract.parmLedgerJournalTransRecId(), false); VendBankAccount vendBankAccount; VendBankAccountId bankAccId = ledgerJournalTrans.CustVendBankAccountId; VendAccount vendAccount = ledgerJournalTrans.accountDisplay(); BankPaymAdviceVendV2Tmp bankPaymAdviceVendTmp; next processReport(); vendBankAccount = VendBankAccount::find(vendAccount, bankAccId) ; bankPaymAdviceVendTmp = this.getBankPaymAdviceVendTmp(); update_recordset bankPaymAdviceVendTmp setting BankAccountID = vendBankAccount.AccountID //Set the other fields needed from VendBankAccount table here. ; } }
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 456 Super User 2025 Season 2
Martin Dráb 429 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
