RE: Multiple formula fields in Advanced Template PDF/Html

I am trying to add a search with some joined fields to an Advanced PDF/Html template.
I define the search in suitescript and I add it to the template with


If I normally define the fields by using join

columns.push(new nlobjSearchColumn("externalid", "item"));

I don’t know how to retrieve the data inside the Template (${template_row.externalid} simply doesn’t work).

As a workaround I tried to define the fields as formulatext.
It works, the value is passed to the template and I can retrieve it from the template  both with ${template_row.formulatext} and with ${template_row[1]} where 1 is the index of the column.

Unfortunately I have more than one field. In that case it seems that the last win. I define more than one field, everything seems to work but in the template I get only the last defined. For example in the following case I don’t find the color field but only the size field. And I find it at position 1 as it would have overwritten the color column.

var filters= [];

filters.push(new nlobjSearchFilter("internalid",null,"is", 40556971));

filters.push(new nlobjSearchFilter("mainline",null,"is", "F"));

filters.push(new nlobjSearchFilter("shipping",null,"is", "F"));

filters.push(new nlobjSearchFilter("taxline",null,"is", "F"));

filters.push(new nlobjSearchFilter("accounttype",null,"anyof","COGS"));

var columns=[];

columns.push(new nlobjSearchColumn("externalid", "item"));

column=new nlobjSearchColumn("formulatext");




column=new nlobjSearchColumn("formulatext");



columns.push(new nlobjSearchColumn("accounttype"));

columns.push(new nlobjSearchColumn("quantity"));

var searchresult = nlapiSearchRecord("transaction", null, filters, columns );

Could anybody help me?

Thanks in advance

manueltoniato Rookie Asked on June 8, 2020 in SuiteScript.
Add Comment
2 Answers

I believe the first one is always formulatext, then additional ones are formatted as:¬† formulatext_1, … , formulatext_n

Intermediate Answered on June 10, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.