NSC | SuiteQL Query: How to Get the Custom Form ID and Description from the Transaction Table

Scenario:

A NetSuite User aims to enhance the verification process by querying Form used in transaction Records and the corresponding form description. This would simplify the task of reviewing and confirming the correct form usage, ensuring a more accurate and streamlined approach.

Solution:

The query provided below shows how to get the Form used in a record as well as the Form’s Description.

SELECT customform, BUILTIN.DF(customform),id,tranid,trandate 
FROM transaction
WHERE type = 'SalesOrd';

—

Do you know any other useful tips related to SuiteQL Queries? Feel free to share it with the Community!