using suiteql how can i get landed cost

AI generated answer (using internal Slack threads):

To get landed cost using SuiteQL, you would need to query the

transaction

table where

type

is 'Landed Cost'. However, please note that SuiteQL does not support direct querying of landed cost. You would need to join the

transaction

table with the

item

table and possibly other tables depending on the specific details you need. Here is a basic example of how you might structure the query:

sql
SELECT t.id, t.tranid, t.type, t.amount, i.itemid
FROM transaction t
JOIN item i ON t.item = i.id
WHERE t.type = 'Landed Cost'

This query will return the transaction ID, transaction number, type, amount, and item ID for all landed cost transactions. Please note that this is a simplified example and you may need to adjust it to fit your specific needs. Also, keep in mind that the actual field names may vary depending on your NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******