[Steamericas-Curtis]

While working on some customization to see a Sales Order subtotal on a Item Fulfillment Record, I created a Customer Transaction Body Field, type Free-Form Text and was going to subtract the shipping amount from the total amount, I discovered some very confusing results:

If I go to the enter {appliedtotransaction.totalamount} into the DEFAULT VALUE field under Validation & Defaulting, and go to an Item Fulfillment Record, it returns '0' (which isn't correct, should be '125.11')

HOWEVER, if I create a Saved Transaction Search and add a Formula (Text) field and plug {appliedtotransaction.totalamount} into the formula value, the returned search results for this particular Item Fulfillment record is correct at 125.11

Also, I'm getting very irregular results if I use a CASE in this formula ('ERROR: Invalid Expression'). I'm starting to wonder whether this is the real cause of not getting the correct results returned.
This is a cached copy. Click here to see the original post.

[torin@aminian.com]

Have you tried the formula: {createdfrom.totalamount}-{createdfrom.shippingamount}?

[Author]

Posts