Hey team, Is there a way to get AmortizationSchedule via SuiteQL. If not, is there a way to expose it?

❌ Error: Invalid search query. Detailed unprocessed description follows. Search error occurred: Field 'TotalAmortized' for record 'AmortizationSchedule' was not found. Reason: NOT_EXPOSED - Not available for channel SEARCH

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that getting the Amortization Schedule via SuiteQL is not directly possible. The 'TotalAmortized' field for the 'AmortizationSchedule' record is not exposed for search, as indicated by the error message you received. In the threads, users have discussed workarounds such as building a search that includes the Amortization Schedule number as a searchable filter and adding it to the Dashboard. However, this does not seem to make them show in the Global Search. Another user mentioned trying to get the amortization schedule number to appear on a transaction saved search, but they found that the 'Amortization Fields' on the JE SS were all blank. It's also worth noting that the Amortization Schedule feature is part of the Advanced Financials module in NetSuite. If you don't see this option, it might be because you need to purchase this module separately. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******