CODEWITHSUNDEEP
pdffreemarkernetsuite
Travis Christianson
Travis Christianson

Reputation: 150

Freemarker Scripting with NetSuite Advanced PDF and Saved Searches

New to Freemarker. I am trying to create an Advanced PDF off a Saved Search. One column in the Saved Search is using the following calculation:

ROUND((SUM((case when {today}-{transaction.trandate} BETWEEN 1 AND 85 and {transaction.type} IN ('Item Fulfillment') then {transaction.quantity}else 0 end) / 6) -Max({custitem_dp_prepackqtyonhand})), -1)

How can I recreate this calculation in my Advanced PDF template?

Upvotes: 0

Views: 2150

Answers (1)

Jouhar N
Jouhar N

Reputation: 311

You don't need to recreate the formula in Advanced PDF template. You can give a name to the custom formula field you created by using 'custom label' and this field will be available in the Advanced PDF template.

Upvotes: 1

Related Questions