Introduction
On this page we navigate the users how to setup these additional fields. Please note that it is possible to setup multiple additional fields in your account.
Additional field to populate custom field to the transaction
1) Credit Card Statement Additional Field
The next step is creating a custom field on the credit card statement transaction line.
To do this navigate to Customization > List, Records & Fields and locate here the record type named “Credit Card Transaction CR” and open it.
On the left side, there is a grey button labeled “New Field”. Press this button to start entering the newly needed field.
On the page that opens set the following values:
- Label: Provide a descriptive name for the field (this will be visible on the bank statement)
- Description: Optional, may be entered if required
- Type: This should be the type “List/Record”
- List/Record: Select here the list from which the user can select values
- Store Value: Must be checked
- Show In List: Must be checked
- Help: Optional, but recommended to guide the user
By default, the new field will be visible at the end of the statement. If you want a specific location then select the location under “Insert Before”. You can’t change this later on.
2) Copy Data to the Transaction
To actually copy the data to a transaction we do need to link the data to the transaction with a configuration.
Navigate to Setup > Credit Card Import Setup > Credit Card Configuration. Open on this page the credit card configuration that should use this data while creating transactions.
On the Credit Card account configuration page scroll to the bottom and click on the subsection “Additional Fields”. Click here the grey button on the left-hand side labeled “New Credit Card Additional Fields”.
On the page that opens set the following values:
- Name: Provide a descriptive name for the configuration
- Credit card transaction field id: Copy here the internal id from the created field
- Transaction field: Select here the field where the data must be copied to
- Transaction field id: This will be automatically populated after selecting the “Transaction field”. When working with a custom segment change the value to the actual internal id from the custom segment.
- Body or line level: Select here if the value should be stored on the body or line level
When all the mandatory fields are set press save. The next reconciliation should now store the selected value on the created transactions.