Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Determine the highest Customer balance over a time period?
We would like to run a report or saved search to determine the highest A/R balance for each customer over a given time period.
As an example, if customer ABC had a $10k balance on February 28 2020 and on no other day in the last 12 month was the balance higher, then the high balance would be $10k on Feb 28 2020. When we ran the report from 1/1/2020 through July 31 2020, the high would show as $10 occurring on Feb 28th.
Thank you in advance for any suggestions.
3