Custom Field That Sources The Transaction Total Displays a Negative Amount

SCENARIO:

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.

RATIONALE:

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.