how to show sublist related record payment type in invoices

AI generated answer (using internal Slack threads):

To show a sublist related record payment type in invoices, you can create a custom field and a saved search. Here are the steps: 1. Create a custom field of type 'hyperlink' on the invoice record. This field will be used to link to the related payment record. 2. Create a saved search that retrieves the payment type from the related payment record. The search should be based on the 'Payment' record type and should include a criteria that links the payment to the invoice (e.g., 'Applied To Transaction' is the invoice). 3. In the results of the saved search, include the 'Payment Method' field and the internal ID of the payment record. The internal ID will be used to construct the URL for the hyperlink. 4. In the formula for the hyperlink field, use the

nlapiResolveURL

function to construct the URL for the payment record. The formula might look something like this:

'<a href="' + nlapiResolveURL('RECORD', 'customerpayment', paymentInternalId) + '">' + paymentMethod + '</a>'

. 5. On the invoice record, add the custom field to the sublist that you want to display the payment type on. You can do this by going to the 'Sublists' tab of the record type and adding the custom field to the sublist. Please note that this solution requires some knowledge of SuiteScript and the NetSuite API. If you're not familiar with these, you might need to get help from someone who is. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******