Friday, November 23, 2018

Formula to Display if Remaining Amount is Paid, Unpaid or Partially Paid


1. Navigate to Customization > Lists, Records, & Fields >Transaction Body Fields > New
2. Set Label = Payment Status
3. Type = Free-Form Text
4. Store Value = False
5. Applies To = Sale
6. Display > Subtab = Main
7. Validation & Defaulting > Default Value = case When {amountremaining} = 0 Then 'Paid' When {amountremaining} = {total} Then 'Unpaid' Else 'Partially Paid' End
8. Validation & Defaulting > Formula checkbox = True
9. Click Save & Apply to Forms.

No comments:

Post a Comment