50
Hi All,
I am doing a report in that I am giving the setfilter value true for only advance invoice field, but in the report it is taking the false value of the advance invoice field, In the report filters also I am setting the advance invoice field to true, but from that filter also it is taking the false value only, can anyone help me.
Thanks & Regards
Instead of SETRANGE on OnPreDataItem, you can use the below Data Item property
Illustrations/Documents:
Share
Report
All responses (
Answers (
dataitem("Purchase Header"; "Purchase Header")
{
DataItemTableView = SORTING("Document Type", "No.") WHERE("Document Type" = CONST("Blanket Order"));
}
Hi Mohana,
I tried the setrange but it is also not working, it is showing the advance invoice false values only.
Thanks & Regards,
Satish.
try
Setrange("Advance Invoice", true);
Setfilter("Remaining Amount", '<>0');
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156