give me a SuiteQL command that will list all vendors with all their currencies (not only primary currency but also the additional ones)

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the SuiteQL command to list all vendors with all their currencies is not directly available. The search.create function in SuiteScript only returns the primary currency of the vendor, not the list of all available currencies. This is because the currency is a sublist of the vendor record, and the syntax for accessing sublists might be different or require a join operation. However, it's important to note that the advanced search in NetSuite might not offer the data you are looking for. The advanced search mimics saved searches and does not have access to the same data as loading individual records (basic search). Unfortunately, the exact SuiteQL command to list all vendors with all their currencies (including additional ones) is not provided in the conversations. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******