Posting Date Filter

(0) Share

Report

Posted on by Community Member

I am creating a report using the post date filter with the job and job ledger entry tables. I have the posting date filter as a filter in the properties for the request page. When I run the report it is not using the posting date filter but grabbing all records. I know I am missing something small as I have done this before and corrected it, but for the life of me I can't remember what it was. Can someone give me some help?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

mmv 11,471 on at

Like (1)

Report

Hi,

Is the "Posting Date Filter" field coming from "Job" table? If that's the case, you need to map it in the "DataItemLink" of the "Job Ledger Entry" or you need to write a code in the "Job Ledger Entry" -> OnPreDataItem trigger "Job Ledger Entry".SETFILTER("Posting Date",Job.GETFILTER("Posting Date Filter"));

Best Regards,

MMV

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

As per MMV post, you should use code or map it there. Your problem would be resolved.

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

If the posting date filter is a variable then you need to write the code as mmv mentioned to filter the posting date on job ledger entries, if it is not a variable then you can add the posting date filter on the Job Ledger Entry dataitem directly by going to properties setting reqFilterFields and when you run the report apply the filter on Job Ledger Entry DataItem

"Job Ledger Entry".SETFILTER("Posting Date",Job.PostingDate);

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

please have a look of below post.

www.mibuso.com/.../viewtopic.php

community.dynamics.com/.../112419.aspx

Gud Luck.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

If it's fixed, please verify the answer.....

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I didn't forget guys will verify sometime this afternoon got thrown onto something else. Thanks again.

Was this reply helpful? Yes No