Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Custom Transaction Body Field using DEFAULT VALUE formula {appliedtotransaction.totalamount} pulls '
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