Hello People, I am working on customer statement pdf template and here is what I want to do. I am trying to calculate the total of charge column and total of payment column from the statement.

<#list statements as statement>

<#assign totalCharges = 0>

<#assign totalPayments = 0>

<#list statement.lines as line>

<#assign totalCharges += (line.charge?number!0)>

<#assign totalPayments += (line.payment?number!0)>

</#list>

<#assign amountDue = totalCharges - totalPayments>

It doesn't give me an error when I save the template but customer statement is not being generated. I am thinking that is because, not each line of statement has both charge and payment and some lines must be returning null for each of them. Any idea how can I tackle this? Thanks

are you just getting 0? typically I do <#assign totalCharges = totalCharges + (line.charge?number!0)> I am not sure the += will work in advancedpdf

I am getting error when I try to generate statement & the error is not very helpful. It just says: "An unexpected error has occurred. Please click here to notify support and provide your contact information."

I would try updating to what I mentioned without the += and see if its working. NetSuite isn't on the latest and greatest freemarker version so some things do not work.

Yeah, I did that. Still no luck. I just can't figure out the issue.

i'd limit to 1 addition like the charge. If you take out the ?number!0 does it work?

Access the your math via a controller which calls a module with your logic and then use the view to present the data.

have you resolved it?