Dynamics 365 CommunityForums Business Central forum Filtering Customer in ...

Business Central forum

Suggested answer

Filtering Customer in Posted sales invoice report.

(1) Share

Report

Report

Posted on by CU29041037-0

95

Hello all,

Could someone please help me in writing the code as per my requirement and explain the code....

My requirement : I have a Report created on 'posted sales invoices' and now my requirement is to create an action on customer card and when clicked on action

the report should be showing only that particular customers posted sales invoice details

Please help me

Thanks,

Nitish.

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 60,818 Super User on at

Like (0)

Report

Filtering Customer in Posted sales invoice report.

Hi, generally, there are two ways to transfer variables to the report. Hope the following can give you some hints.

Thanks.

ZHU
Suggested answer

Saurav.Dhyani 10,155 User Group Leader on at

Like (0)

Report
Filtering Customer in Posted sales invoice report.

Hi,

In report add a parent data item - Customer which have relation to Posted Sales Invoices with Sell-to-Customer No. or Bill-to-Customer No.

Once Relation is set you can create an action and run it like this -

Customer.SetRange("No.", CustomerNumber); REPORT.RunModal(ReportNumber, true, true, Customer);

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Helpful resources

Quick Links

Leaderboard

Andre Arnaud de Cal... 283,375 Super User

Martin Dráb 223,308 Super User

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans