News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Autofill filter on Jou...

Business Central forum

Suggested answer

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

(1) Share

Report

Report

Posted on by IT-04102138-0

12

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.

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Ramiz 180 on at

Like (0)

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... 290,537 Super User 2024 Season 2

#2

Martin Dráb 228,520 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans