Finance | Project Operations, Human Resources, ...

Vendor account statement report

(0) Share

Report

Posted on by Community member

Hi everyone,
I want to add new fields and customize the system's default vendor account statement report.
So, I first extended the TMP table to my project, duplicated the default SSRS report to make a new design and add my new fields, created extension class of DP to map my new fields. But now I don't know how to make a new Output menu item to show my new report knowing that the default menu item uses the controller class object not a report object.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Hi,

You can refer to this official document: Extend report menu items to redirect user navigation - Finance & Operations | Dynamics 365 | Microsoft Learn. This article shows how to extend existing application menu items so that, after only minimal code changes, navigations are redirected to a custom reporting solution. This article focuses on the process of extending existing application menu items so that, after only minimal code changes, navigations are redirected to a custom reporting solution. By using this technique, you will avoid the inconvenience of tracking down and replacing all references to an existing application report. Just extend an existing application menu item to redirect application navigations to reports that are defined in an extension model. The following illustration shows a typical application customization.

Or you can also refer to this blog: dynamics365musings.com. In this article I will show you how to create menu items in D365. As well as explain many of the other useful things you can do using the menu item properties.

Best regards,

Kevin

Was this reply helpful? Yes No
Community member 12 on at

Like (0)

Report
@Kevin, thank you for your reply I managed to extend the report controller and let it use my new report and design, but when I used the processReport method and used a post event handler a strange behaviour happens.
while select forUpdate tmp { ttsbegin; select firstonly generalJournalEntry where generalJournalEntry.recid == tmp.GeneralJournalEntry join fiscalCalendarPeriod where fiscalCalendarPeriod.RecId == generalJournalEntry.FiscalCalendarPeriod; select firstonly vendInvoiceJour where tmp.Voucher == vendInvoiceJour.LedgerVoucher && vendInvoiceJour.InvoiceAccount == tmp.AccountNum && vendInvoiceJour.InvoiceDate == tmp.TransDate; tmp.PeriodName = fiscalCalendarPeriod.Name; tmp.PurchId = vendInvoiceJour.PurchId; tmp.update(); ttscommit; }

in the code snippet shown, the field Name is assigned to the field PeriodName which I added to the TMP table, while the purchId is shown as blank, even though when trying debugging, the vendInvoiceJour has a recordID, and I made sure that the blank value appearing on my report has a value from querying SQL.
Any idea?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Vendor account statement report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Vendor account statement report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates