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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Reorder Months when Using "Rolling" Date Criteria
I am working with a client who would like to see a rolling 12 month Trial Balance. The Last Rolling Year Alternate Date Range works nearly perfectly for this.
I say "nearly" because the ordering seems backwards. The default puts the oldest month first. For instance when I run it as of today, May 2014 is first, then June 2014, then July 2014...and finally April 2015. Is there a way to reverse the ordering so that April 2015 is first, then March 2015...finally May 2014?
This seems to be the case anywhere a "rolling" date range is used. Is there any way around this? Most users I've dealt with want the most recent month first. Thanks.
0