This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

${item.netamount?string?replace('[^\\.,0-9]','','r')?number / item.quantity}

Error details :left-hand operand: Expected a hash, but this has evaluated to a string (wrapper: f.t.SimpleScalar):
==&gt; item.netamount?string [in template "template" at line 190, column 25]

----
FTL stack trace ("~" means nesting-related):
- Failed at: #assign val = item.netamount?string.n... [in template "template" at line 190, column 10]

have you just tried `${item.netamount / item.quantity}` ?  Usually Freemarker will convert the currency value to a number automatically, though there are some situations where it cannot.

If that does not work, you could make a Transaction Line currency formula field that does this calculation, then use that custom line field directly in the template.

I tried this <@U9CS7LVCN> `${item.netamount / item.quantity} whcih failed then i tried different methods`

<@U9CS7LVCN> for transaction currency formula field,  do i need to use the same formula {item.netamount / item.quantity}

It might be either `{item.netamount} / {item.quantity}` or `{netamount} / {quantity}`, I can't remember which

You can also just do the math in netsuite and pull the field over and avoid having the PDF do business logic and calculations.

Hi <@U9CS7LVCN>, <@U2C4P9YR3> this one worked, but curious to know from where the netamount is being fetched.

 few records this worked well, But few records netamount displays wrong value