in saved search, there is a column named "amountremaining" but in suiteql, it doesn't have that column

AI generated answer (using internal Slack threads):

In NetSuite, the 'amountremaining' field is available in saved searches but not directly accessible in SuiteQL. This field represents the remaining amount to be paid on a transaction, such as an invoice or a sales order. In a saved search, you can access this field directly. For example, in a saved search for invoices, you can add a result column for 'Amount Remaining (Foreign Currency)' or 'fxamountremaining' to get the remaining amount in the transaction's currency. However, in SuiteQL, this field is not directly accessible. SuiteQL is a more flexible and powerful tool than saved searches, but it doesn't have direct access to all the same fields. To get the 'amountremaining' value in SuiteQL, you would need to calculate it manually by subtracting the total amount paid from the total amount of the transaction. Remember, the 'amountremaining' field may not always give the expected results, especially in cases where payments are involved. For example, if a payment is applied to an invoice, the 'amountremaining' field on the payment may show as blank in a saved search. This is because the 'amountremaining' field represents the remaining amount to be paid on the transaction, not the remaining amount to be applied from the payment. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******