For a given "Bill Payment" transaction, give me a SuiteScript, a SuiteQL, or a saved search that can list the lines under "Credits Applied" sublist for this "Bill Payment"

AI generated answer (using internal Slack threads):

To list the lines under "Credits Applied" sublist for a "Bill Payment" transaction, you can use SuiteScript, SuiteQL, or a saved search. Here is a sample SuiteScript:

javascript
var billPaymentId = '123'; // replace with your Bill Payment internal id
var billPaymentRecord = record.load({
    type: record.Type.VENDOR_PAYMENT,
    id: billPaymentId
});
var lineCount = billPaymentRecord.getLineCount({sublistId: 'apply'});
for (var i = 0; i < lineCount; i++) {
    var apply = billPaymentRecord.getSublistValue({sublistId: 'apply', fieldId: 'apply', line: i});
    if (apply) {
        var doc = billPaymentRecord.getSublistValue({sublistId: 'apply', fieldId: 'doc', line: i});
        var amount = billPaymentRecord.getSublistValue({sublistId: 'apply', fieldId: 'amount', line: i});
        log.debug('doc: ' + doc + ', amount: ' + amount);
    }
}

For SuiteQL, you can use the

nextlinks

and

previouslinks

columns on

transaction

to traverse the links. Here is a sample SuiteQL:

sql
SELECT 
    T.ID, T.TRANID, T.TYPE, T.AMOUNT, T.APPLIEDTO 
FROM 
    TRANSACTION T 
WHERE 
    T.TYPE = 'Bill Payment' AND T.ID = '123' -- replace with your Bill Payment internal id

For a saved search, you can use the "Applied To Transaction" field to list the Bill Credits for a Bill Payment. However, please note that Bill Payments and Bill Credits are not directly linked in saved searches. You might want to use Type = Bill instead so you can capture both. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******