Announcements
No record found.
Hello,
I want to get from inventtrans the max physicaldate for a itemid as user input parameter.
I create a group as the image below, but its takes a long time to execute and it never finish. I get the message The operation is taking a long time to process, click Wait to keep waiting for it to complete.
There is a better way to receive the specific field?
FILTER transforms it to query while WHERE does it on memory. You have to allays try to use FILTER, sometimes you can't because the system is not able to do so, either because some formulas like "LEFT" or because you are pointing to a transformed list (you added a calculated field).
Try First to filter everything you can from the list of records with FILTER, then you are left with a much smaller list, filter this one with WHERE.
I make the change but the result is the same.
Actually, I want to get the max transaction date from inventtrans for specific wmslocationid and item.
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 510 Most Valuable Professional
André Arnaud de Cal... 302 Super User 2026 Season 2
CU-1234529-002 197
