Additional field to populate custom field to the transaction
On this page we explain how to add a custom field to the bank statement and populate the value to the transaction.
Introduction
User may want to populate specific values on a bank statement line and then automatically copy this to a resulting payment transaction.
Please note that user may decide what type of information will be copied to the transaction. The field can be Freeform-Text, sourced List/Record such as custom segment or even a document.
Create new field - Bank Statement Transaction field - where the values will be entered
Using Administration or other Full Access role, navigate to the Customization > Lists, Records, & Fields > Record types. Filter on the Bank Reconciliation bundle and locate the Bank Statement Transaction.
Click on the New field button:
And create the new field based on the screenshot, the label is the name how this field will be displayed on the statement:
After saving the field and the record, proceed to step 2.
Create new field - NetSuite field - where the values will be stored
Next step is to create a transaction body field, where the value will be stored. Here we follow standard steps how to create the custom field and we decide to which transactions we want this to be applied (Journal, Custom Payment, Vendor Payment …).
Navigate to Customization > Lists, Records, & Fields > Transaction Body fields > New.
Create a field with following setup - you may choose again the label, and the transaction type on which you will be storing the values from the bank statement. Good practice is to also use certain naming convention both for the label & ID.
Please note, that copying a value to Vendor Payments is currently a limitation of our tool.
Set the additional field logic
Now we have to open the bank account configuration and add the logic for this additional field.
Navigate to Setup>Bank Reconciliation Setup>Bank Account Configurations and click View on any of the configuration that this setup applies to.
Then navigate to the new Additional fields:
Fill in the form - First set the custom form to the Default for better visibility, then in the Source settings section populate the Bank Statement Transaction field created in step 1, which will auto-populate the ID of this field, then in the Copy settings section select the Netsuite field from the step 2.
Save the record and you can now edit the bank statement and add values (in this case comments) for the transactions to be created (not available for reconciliation of closed transactions).
When you process a bank statement line, the transaction contains the values selected (or in this case typed) on the bank statement line:
Please note that by default the new field is under the Custom tab. Contact the administrator or our Support, as we can move the field on the “Main” subtab of the transaction form.