Hi everyone - I'm creating a new custom record, and several fields are sourced from a sales order. I'm having problem with the Amount field. On my custom record field, it's coming up with a negative value. On the Source & Filtering tab of the custom field, I've selected the field that is sourced by the SO and then Amount from the Source from field. I've also tried using transaction amount - but it doesn't return anything. Any ideas?

Try Total

The negative amount usually happens when you're pulling from a credit memo or return authorization instead of a regular sales order, or if NetSuite is interpreting the transaction direction wrong. Try using "Amount (Unsigned)" instead of just "Amount" in your source field; that should give you the absolute value regardless of transaction type. Also double-check that your filtering criteria is actually grabbing sales orders and not other transaction types that might have negative amounts.

Total worked - thanks! It was definitely a regular sales order - without any discounts or adjustments. Amount (Unsigned) is not in the field list. But since Total worked, as long as it pulls the correct value beyond the two SOs I've been using for testing - we're good.