how to get first and the last posting date for an item by code in my custom fields. I have two custom fields, want to show first and last posting date on it through item ledger entry. Please suggest. Thank you!
*This post is locked for comments
how to get first and the last posting date for an item by code in my custom fields. I have two custom fields, want to show first and last posting date on it through item ledger entry. Please suggest. Thank you!
*This post is locked for comments
Hi!
Create 2 flowfields for Item table(27) as below (Use max method for last posting date):
Take item record.
Repeat item
Set filter on item ledger entry with item code
Sort item ledger entry by posting date
Get first record and last record.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156