Scenario
User needs to create a field which sets the date 7 days from the Transaction Date.
Solution
- Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
- Label: Enter Label (e.g. Return By)
- Type: Select Date
- Store Value: Remove Checkmark
- Click Validation & Defaulting tab
- Default Value: Enter TO_CHAR({trandate}+7, 'DD/MM/YYYY')
- Click Save