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 ?
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
hello
you should share some more info about your customization
DAniele
Hi,
Can you please share what you have achieved so far? Including code in Txt format only.
Thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148