How to Link Customer Payments to Invoices with a Custom Field in NetSuite

The solution involves configuring a custom transaction body field and implementing a SuiteScript to automate the population of the customer field on payment records.

1. Create a Custom Transaction Body Field

   • Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
   • Set the Type to List/Record.
   • Set the List/Record to Transaction.
   • Apply this field to Customer Payment records.

2. Configure Field Filtering

   • On the custom field definition, set the Filter to include:
   • Status Invoice:Open
   • Type:Invoice
   • This ensures that only open invoices are available for selection in the custom field.

3. Implement a SuiteScript

   • Develop a SuiteScript (e.g., a User Event script or Client script) that triggers when an invoice is selected in the custom field.
   • The script should programmatically set the Customer field on the payment record based on the customer associated with the selected invoice.
   • *Note on SuiteScript Limitations*: While field manipulation on customer payment records is generally supported, direct creation of customer payment records via SuiteScript's record.create() method may have limitations according to NetSuite documentation. The scripting approach described here focuses on populating fields on an existing or manually created payment record.

4. Automatic Invoice List Update

   • Once the Customer field is populated by the script, NetSuite will automatically update the Apply subtab to display the relevant invoices for that customer, allowing for easy application of the payment.