Hi team, While running a query to fetch TotalAmortized using suiteql on the AmortizationSchedule table, I’m getting this error.

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 seems that the 'TotalAmortized' field is not exposed for search in the 'AmortizationSchedule' record. This is why you're getting the error message. In NetSuite, not all fields are exposed for search or available for SuiteQL queries. The error message you're seeing indicates that the 'TotalAmortized' field is one of those fields that are not exposed for search. Unfortunately, there's no workaround for this within SuiteQL. You might need to find an alternative way to get the data you need, perhaps by using a different field or by using a different method to retrieve the data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

what other methods can I use?