How can i reach Vendor Bill - GL Impact lines by API? or SuiteQL Query ?

AI generated answer (using internal Slack threads):

To reach Vendor Bill - GL Impact lines by API or SuiteQL Query, you can use the

TransactionAccountingLine

table. This table contains the GL Impact lines for each transaction. Here is a simple example of a SuiteQL query that you can use to get the GL Impact lines:

sql
SELECT *
FROM TransactionAccountingLine
WHERE transactionId = YOUR_TRANSACTION_ID

Replace

YOUR_TRANSACTION_ID

with the ID of the Vendor Bill you are interested in. You can also use SuiteScript to get the GL Impact lines. You would need to create a search on the

TransactionAccountingLine

record type and filter by the

transactionId

field. Here is a simple example of how you can do this in SuiteScript:

javascript
var search = require('N/search');
var transactionAccountingLineSearch = search.create({
   type: 'transactionaccountingline',
   filters: [
      ['transactionId', 'is', YOUR_TRANSACTION_ID]
   ]
});
var resultSet = transactionAccountingLineSearch.run();

Replace

YOUR_TRANSACTION_ID

with the ID of the Vendor Bill you are interested in. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******