Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
AE:MIN and MAX Date on Expected Receipt Dates
Hi all
Me again happy Friday!
Quick question. I have added some custom item fields to show the nearest Expected Receipt Date and Expected Quantity and Furthest Expected Receipt date and Quantity.
I then show these on a Saved Search, screenshot below:
With the Closest Receipt Date I am pulling the data from a summary saved search, the formula for this is below:
I thought that if I reversed the functions and changed them to MIN then it would show the furthest away quantities and dates, but it hasn't:
Does anyone know how I would amend this formula to show the furthest away expected receipt date?