User creates two custom fields for a custom record type. The first field pulls up the list of transactions and the second sources from the Total of the selected transaction:
- Transaction (custom)
- Type = List/Record
- List/Record = Transaction
- Store Value = T
- Amount (custom)
- Type = Currency
- Source List = Transaction
- Source From = Total
- Store Value = F
When a user selects a purchase order from the Transaction field, the Amount shows a negative value.
Solution
The sign (negative or positive) of the custom Amount field in this scenario is based on the type of transaction this amount is sourced from.
The following transaction types will render a negative amount:
- Bill
- Item Receipt
- Purchase Order
The following transaction types will render a positive amount:
- Bill Credit
- Estimate
- Invoice
- Sales Order
Note: If the custom Amount field is to source the transaction Total Amount (instead of Total), the sign of the amounts for the above transaction types will be reversed.