Hi Guys on a Purchase Order Form i have fields on transaction line called Rate , Amount and Quantity . When i go to Customization => List Records => Transaction Line fields i find all the fields except the Amount field. Might this be located elsewhere coz i want to put a formula on it thanks.
Neat Unity
10/16/2019, 3:14 PM
message has been deleted
s
scottvonduhn
10/16/2019, 3:23 PM
Customization => List Records => Transaction Line fields only shows you the custom line fields that have been added, not the standard (built-in) fields. You can't change the definition of the Amount field. However, you can make a new custom Formula field that references amount or any other values.
n
Neat Unity
10/16/2019, 3:35 PM
Thanks very much . PS how do you make it reference the amount.
s
scottvonduhn
10/16/2019, 3:36 PM
{amount}
👍 1
n
Neat Unity
10/17/2019, 8:20 PM
HI @scottvonduhn as depicted on the picture I have a sublist called Expense and another called Items. Both contain fields called Amount. I’m trying to implement another field and insert a formula referencing Amount from the Expense sublist because when I do {amount} / {quantity} it does not work at all so I believe due to conflict. How do I reference the one from Expense side thanks
s
scottvonduhn
10/17/2019, 8:55 PM
Are you trying to create a custom Transaction Body formula field, or a Transaction Line formula field? Only a Transaction Line field can reference amount.