News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... [SOLVED] Autofill filt...

Small and medium business | Business Central, N...

Suggested answer

[SOLVED] Autofill filter on Journal Lines when the report request page is opened

(1) Share

Report

Report

Posted on by kayc529

53

Hi community! I trying to prevent user typos when generating reports by autofilling the filter fields in the report request page.

SelectedLine is a journal line record.

I want to autofill the Document No. and Posting Date fields also but only the Journal Template Name , Journal Batch Name and Line No. are filled.

I know that with the Line No. filtered, that the user will be able to generate the correct report. However, I was curious if autofilling other fields would be possible.

Thanks in advance.

All responses Img

All responses (3)

Answers Img

Answers (0)

kayc529 53 on at

Like (0)

Report

Autofill filter on Journal Lines when the report request page is opened

Thanks for the responses! My issue has been solved.
Suggested answer

gdrenteria 12,181 Most Valuable Professional on at

Like (2)

Report

Autofill filter on Journal Lines when the report request page is opened

Hi

I hope this can help you and give you some hints: Dynamics 365 Business Central: Can we change default options/filters on the request page of Report??? | Dynamics 365 Lab (yzhums.com)

Solved: How to pass filter values to a Report Request (dynamics.com)

Solved: How to preset filter values in report request page? (dynamics.com)

Best

GR
Suggested answer

Ramiz 333 on at

Like (1)

Report

Autofill filter on Journal Lines when the report request page is opened

Hi,

Try applying a filter on the SelectedLine before running the report like

SelectedLine.Setfilter("Document No.", YourValue);

SelectedLine.Setfilter("Posting Date", YourValue);

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans