NetSuite Admin Tip | Sales Orders Age Calculation Using SuiteQL

When working with NetSuite, it’s essential to track the age of transactions, especially Sales Orders. Calculating the age, in days, of Sales Orders allows businesses to monitor how long these orders have been open and take appropriate actions if necessary. Using SuiteQL, you can efficiently retrieve this data with a simple query. Below is the SQL query you can use:

SELECT
    TranDate AS Date,
    trandisplayname AS SONumber,
    TRUNC(SYSDATE) - TranDate AS Age,
    BUILTIN.DF(entity) AS Customer
FROM
    Transaction
WHERE
    type = 'SalesOrd'
ORDER BY
    TranDate;

This query calculates the age of Sales Orders based on the transaction date (