Announcements
No record found.
When viewing trade agreements (Purchase or Sales), we would like to limit visibility to active only (hide expired). Is there a way to do this out-of-the-box, without code?
Thank you,
Lori
Hi Lori,
There is an option to use filtering using the advanced query and sort form. You can use methods available in the SysQueryRangeUtil class which can be used for intellectual date ranges.
docs.microsoft.com/.../advanced-filtering-query-options
For the trade agreements you can filter it in this way:
I'm preparing a blog with some more information about this use case. When I try to save it as Saved View, it will not keep the second range on the "empty date" with value 01-01-1900. My blog will be ready within a few days.
I published the blog today. You might read the whole story now: No-code: View only active trade agreements in Dynamics 365 Finance and Operations - Dynamicspedia
Isn't there a standard view for this? go to workspace Pricing and discount management. In Links, you can find a link to Active trade agreements, for Sales and Purchase Prices as well as Sales and Purchase Discounts.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 475 Most Valuable Professional
André Arnaud de Cal... 399 Super User 2026 Season 2
CU10121822-0 374
