Is it possible to get the currency sublist values from a customer using a query?

AI generated answer (using internal Slack threads):

Yes, it is possible to get the currency sublist values from a customer using a query. You can use the query module in SuiteScript to achieve this. The query would look something like this:

SELECT ID, Name FROM Currency

. This will return a list of all the currencies. However, please note that the

getSelectOptions

method does not work on native sublist fields, as indicated in the conversations. For the custom pricing for a customer by Currency, it seems like this information might not be directly available through a saved search. An alternative suggestion from the conversations is to try using an analytics workbook, which might offer more flexibility. For getting a sublist of contacts that are under a customer on a transaction, you can create a saved search for contacts, set customer as one of the filter (don't show), select available for sublist. Then, create a custom sublist for transaction, applied to transactions type you want, select the previously created search, name the tab and label. Now sublist should be available in the transaction record. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******