how to use suitescript query GL impact ?

AI generated answer (using internal Slack threads):

To use SuiteScript to query GL impact, you can use the

N/query

module in SuiteScript 2.x to run a SuiteQL query. SuiteQL is a powerful tool that allows you to perform complex queries on your NetSuite data, including GL impact lines. Here is a basic example of how you can use SuiteQL within SuiteScript:

javascript
var suiteQL = 'SELECT * FROM transaction WHERE customgl = "T"';
var suiteQLResult = query.runSuiteQL({query: suiteQL});

In the above example, the SuiteQL query is looking for transactions where the

customgl

field is set to

T

. You can replace the query with your own to get the GL impact lines you need. Please note that you need to have the necessary permissions to run SuiteQL queries and access the data you are querying. Also, it's important to note that while you can add lines to existing GL impact using custom GL plugins, you cannot remove existing ones. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

customgl field is not exists in transaction table

Thank you for your feedback