You’re offline. This is a read only version of the page.
3,027
Hi
How to get a list of items which have purchased before 30/06/2017 and Sale or Transfer after 30/06/2017.
Thanks
*This post is locked for comments
I think that to solve this case the best way to do is to handle the requirements via C/AL code.
You can:
1) Write a codeunit that loops through Item and checks if they are purchased (Purchase Line), on sale (Sales Line) and transferred (Transfer Line). Here you have to apply the filters you want.
2) If an item is ok with all your requierements, you can place it on a Temporay Item Table (you can declare a variable of Type = Record, Subtype = Item and set the Temporay property to YES).
3) At the end, you can run a page (Item List) with SourceTableView your temporary table.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (