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

How to club Parent and child dataitem's filter to run a report in NAV 2016?

(0) Share

Report

Posted on by Beulah

114

I want to run "Suggest Vendor Payments" report such that filters from "vendor" data item (Parent Data Item) has been used. In order to apply the filters from "Vendor Ledger Entry", I have added this table as a child Data item. But the filters applied from "Vendor Ledger Entry" (Child Dataitem) has been ignored and the filters from Parent DataItem (Vendor) is only applied in the results fetched once the report runs.

Can anyone suggest how to apply the filters from both the tables while running the report ?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nitin Verma 21,784 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please share what you have achieved so far? Including code in Txt format only.

Thanks.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,407 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hello

you should share some more info about your customization

DAniele

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,939 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, This Report has only one DataItem (Vendor), so you cannot add filters directly from "Vendor Ledger Entry". Even if you add Child Dataitem, its logic is not to extract data from your Child Dataitem, so it should have no effect.

If you do some customization now, I think you can add the fields you need in "Vendor Ledger Entry" to the Request Page, and then add the filter code in report object.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No