suiteql query on transactions select only open sales orders (not partially of fully billed)

AI generated answer (using internal Slack threads):

To select only open sales orders (not partially or fully billed) using SuiteQL, you can use the

Status

field in your query. The

Status

field represents the current status of the transaction. For open sales orders, the status should be 'Pending Fulfillment' or 'Partially Fulfilled'. Here is a basic example of how you might structure your SuiteQL query:

sql
SELECT 
    Transaction.ID,
    Transaction.TranID AS SalesOrderID,
    Transaction.TranDate AS OrderDate,
    Transaction.Entity AS CustomerID,
    BUILTIN.DF( Transaction.Entity ) AS CustomerName,
    Transaction.Status AS OrderStatus
FROM
    Transaction
WHERE
    ( Transaction.Type = 'SalesOrd' )
    AND ( Transaction.Status IN ('SalesOrd:A', 'SalesOrd:B') )
    AND ( Transaction.MainLine = 'T' )

In this query, 'SalesOrd:A' represents 'Pending Fulfillment' and 'SalesOrd:B' represents 'Partially Fulfilled'. Please replace these status codes with the ones that are applicable in your NetSuite account as they can vary. Please note that this is a simplified example and you may need to adjust it based on your specific requirements. For example, you might need to join with other tables if you need more information about the sales orders, or add more conditions to the WHERE clause to further filter the results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******