This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hey! Does anybody knows how to get the Credits Applied to a Bill Payment using SuiteQL?

Next transaction link table.
Chatgpt can easily give you the query with some small errors in it.

Get all the Vendor Credits applied to a Bill Payment


```SELECT
    credit.ID AS 'Credit Id',
    credit.ForeignTotal AS 'Credit Total',
    NTLL.ForeignAmount AS 'Amount Applied',
    bill.ID AS 'Bill Id'
FROM
    NextTransactionLineLink AS NTLL
INNER JOIN
    Transaction AS credit ON credit.ID = NTLL.NextDoc
INNER JOIN
    Transaction AS bill ON NTLL.PreviousDoc = bill.ID
WHERE
    credit.type = 'VendCred'
    AND NTLL.PreviousDoc IN (
        SELECT
            related.previousDoc
        FROM
            Transaction bp
        JOIN
            NextTransactionLink related ON bp.id = related.nextDoc
        WHERE
            bp.id = 19518642
    )```