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

&lt;#assign x = 0&gt;
        &lt;#assign aDateTime = .now&gt;
        &lt;#assign aDate = aDateTime?string["MM/dd/yyyy"]&gt;
        &lt;!--assign overdue = line.duedate?string["MM/dd/yyyy"]--&gt;
        &lt;!--#assign daysoverdue = aDate - overdue--&gt;
        &lt;thead&gt;
		&lt;tr&gt;
			&lt;th colspan="30"&gt;Invoice Number&lt;/th&gt;
			&lt;th colspan="40"&gt;Opportunity ID&lt;/th&gt;
			&lt;th colspan="30"&gt;Invoice Date&lt;/th&gt;
			&lt;th colspan="20"&gt;Due Date&lt;/th&gt;
			&lt;th colspan="16"&gt;Days Overdue&lt;/th&gt;
    		&lt;th colspan="18"&gt;Invoiced Currency&lt;/th&gt;
			&lt;th colspan="40" align="right"&gt;Remaining Amount Due&lt;/th&gt;
    		&lt;th colspan="30"&gt;Invoiced Amount&lt;/th&gt;
    		&lt;/tr&gt;
	&lt;/thead&gt;

	 &lt;#list statement.lines as line&gt;
     &lt;!--#assign dueDate = line.duedate?string["MM/dd/yyyy"]--&gt;
		&lt;#if line_index==0&gt;
		&lt;!-- remove balance forward --&gt;
		&lt;#elseif line.description?contains("Invoice")&gt;
       	&lt;!--#if line.description?contains("Invoice")--&gt;
  		&lt;tr&gt;
 			&lt;td colspan="30"&gt;${line.description?replace("Invoice #" , "")}&lt;/td&gt;
			&lt;td colspan="40"&gt;${line.custbody_spotify_campaign}&lt;/td&gt;
			&lt;td colspan="30"&gt;${line.datecol}&lt;/td&gt;
			&lt;td colspan="20"&gt;${line.duedate}&lt;/td&gt;
          	&lt;td colspan="16" align="center"&gt;${aDate-dueDate}&lt;/td&gt;