How can I link a journal entry with a payment record in a suitescript?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To link a journal entry with a payment record in SuiteScript, you would typically create a customer payment transaction to apply the journal entry to the invoice. This can be done by using the

record.transform

function to mimic the effect of the

Accept Payment

button in the UI. Here is a general outline of the steps you would follow: 1. Use

record.transform

to transform the invoice into a customer payment. This is similar to clicking the

Accept Payment

button on the invoice in the UI. 2. Use

Record.setSublistValue

to apply the journal entry to the customer payment. This is similar to marking the checkboxes in the UI. 3. You may need to use

Record.findSublistLineWithValue

or

Record.getSublistValue

to find the line of the journal entry you want to apply. Please note that this process will create a new customer payment record. If you want to apply the journal entry without creating a new payment record, you may need to consider a different approach, as NetSuite typically requires the creation of a customer payment to properly record the application of credits. Here is a sample code snippet:

javascript
var paymentRecord = record.transform({
    fromType: record.Type.INVOICE,
    fromId: invoiceId,
    toType: record.Type.CUSTOMER_PAYMENT,
});

paymentRecord.setValue({
    fieldId: 'paymentmethod',
    value: paymentMethodId,
});

var lineCount = paymentRecord.getLineCount({sublistId: 'apply'});
for (var i = 0; i < lineCount; i++) {
    var apply = paymentRecord.getSublistValue({
        sublistId: 'apply',
        fieldId: 'apply',
        line: i
    });
    if (apply) {
        paymentRecord.setSublistValue({
            sublistId: 'apply',
            fieldId: 'apply',
            line: i,
            value: true
        });
    }
}

paymentRecord.save();

Please replace

invoiceId

and

paymentMethodId

with your actual invoice ID and payment method ID. This code will apply all credits to the invoice. If you want to apply specific credits, you need to add additional logic to the loop. Remember to test this in a sandbox environment before deploying to production.