This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm using accounting period field in a custom record. Is there any way to get the dropdown list of periods sorted by date instead of alphabetic sorting at is is now?

gonna point you in an awful direction of trying custom transaction which are non posting

or possibly a using the souring and filtering, filtering away the year and quarter records in the accounting periods on the custom field

if neither works, possibly have to use the N/ui/serverWidget module

yeh, I use enddate sorting the list of these custom records, it works fine. However I'm talking about entering the information in this record. I can filter out closed periods using Sourcing and Filtering (that's good) but nothing with regards to sort order.

case closed, it appears that the sort order depends whether it show full list or list with search capability (preference ssettings Enrries in dropdowns). So the list without search field is sorted correctly.