@Hubert I would try this.

<#assign x=JSON.despositRequestAmount>
${x?string.currency}

see it that works.

@karlenigma thanks, will try it now.

@karlenigma not working.

Seems like a trivial thing but I have no idea why it's not working and it's not formatting it.

if I'm getting "an unexpected error has occurred" when generating a statement, is there an easy way to debug which line is causing the problem?

@Jon Kears That is the infamous or maybe famous error in NetSuite... there is no easy fix... but 90% of the time as @creece would say is something stupid... a very obvious code error normally (programmer side)...

Anyone have any idea why when the display type of a custom field on transactions in hidden i get an unknown error when printing the ADV PDF template. Thought I could do that?

OK fixed my issue. Dont put hidden on the custom field but do not show on the forms themselves.

How silly.

Does anyone have any idea why an integer number when used in ADV PDF puts the separator in the number? 1,234,456

@karlenigma Format, current numbering format setting...

anyone have any idea how to subtotal time and split expenses into another group to then subtotal?

Does this go into the template or is this a script that needs to run before ?

This is from a suitelet. Well, a custom module included in a suitelet. I haven't tried it using the record object.

How does this work for you?

Sorry I would say I know enough to be dangerous and this is past that

Referring to the attached object just works basically.

So you just run two tables then? One for time and one for expense if there is any?

The subtotal each list?

then*

I'm not sure about doing it without scripting. I'm more comfortable scripting than working with the template itself. I calculated subtotals and grouped, by project task, but it was all done script side. Sorry

No worries. Thanks for the help. I will see what I can come up with using what you have sent. It is a big help for sure!

Anyone have any idea why this

${JSON.depositRequestAmount?string.currency}

is not working. Shows nothing.

Is there any other way to format numbers nicely ?

is the list called JSON?

you are pulling the deposit request amount from the JSON list

that's a custom data source passed to the template

when I use

${JSON.depositRequestAmount}

it is showing the number

I do all my formatting on the script side. freemarker is hard