News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Invoice No. Lookup on ...

Business Central forum

Suggested answer

Invoice No. Lookup on Report Request Page

(4) Share

Report

Report

Posted on by Alina Fahim Ibrahim

120

How can I give Invoice No. field lookup on report request page?

Categories:

All responses Img

All responses (5)

Answers Img

Answers (0)

Suggested answer

soma 24,406 on at

Like (0)

Report

Invoice No. Lookup on Report Request Page

Please include the Table Relation (TableRelation = "Sales Invoice Header"."No.";) in your report request page field.
Suggested answer

YUN ZHU 68,142 Super User 2024 Season 2 on at

Like (0)

Report

Invoice No. Lookup on Report Request Page

Hi, try the following.
Alina Fahim Ibrahim 120 on at

Like (1)

Report

Invoice No. Lookup on Report Request Page

@YUN ZHU .This is a customized report and I added invoice No. in request field filter but it doesnot show me the drop down or lookup of invoice No.
Suggested answer

YUN ZHU 68,142 Super User 2024 Season 2 on at

Like (0)

Report

Invoice No. Lookup on Report Request Page

Hi, it depends on the dataitems of your report.

For example, Sales - Invoice can directly filter No. without adding additional code.

If the dataitem is not included, you need to add fields or variables, and then add filtering logic to the report code.

Hope this can give you some hints.

Thanks.

ZHU
gdrenteria 8,339 Super User 2024 Season 2 on at

Like (0)

Report

Invoice No. Lookup on Report Request Page

Hi

I hope this can help you

Solved: Lookup on field in request page (dynamics.com)

Dynamics 365 Business Central: How to create a Lookup, Drop-Down, or Option list (Single and Multi select) | Dynamics 365 Lab (yzhums.com)

BR

GR

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2

Martin Dráb 227,979 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans