What are NetSuite custom segment best practices? Can I have over 1000 records in the custom segment?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** NetSuite custom segments are a powerful tool for categorizing and analyzing your data. Here are some best practices for using them: 1. Ensure Custom Segments are GL Impacting: For the custom segments to be supported in budget vs actuals, they must be GL impacting. This means they should have an effect on the general ledger. 2. Avoid Overloading with Custom Records: While there is no hard limit on the number of custom records you can have in NetSuite, having a large number (millions) could potentially impact performance, especially if those records are complex or have sublists/child records. 3. Consider Data Warehousing for Large Volumes of Data: If you're dealing with a large volume of data (hundreds of thousands to millions of records per year), you might want to consider moving some of that data to a data warehouse. This can help maintain performance in NetSuite. As for your question about having over 1000 records in the custom segment, based on the conversations, it seems that NetSuite can handle a large number of custom records. There are instances of custom records reaching up to 15 million entries without significant issues, although performance may be impacted as the number of records increases. However, it's always a good idea to monitor performance and consider other options like data warehousing if necessary.