netsuiteprofessionals #advancedpdf

XochisSketches

11/22/2021, 11:25 PM

(Technically on the far right hand side too, but alas, I am too lazy)

rustyshackles

11/23/2021, 6:37 AM

Anybody created a template where you print the serial numbers in the same row as the item? How do you prevent the list of serials from overflowing the page if you have a large number of quantity like 100+

DATTA

11/23/2021, 7:27 AM

Hi All Is Anybody know How to add New line in the value attribute of Barcode tag for QR Code

DATTA

11/23/2021, 7:28 AM

<barcode codetype="qrcode" showtext="true" height="150" width="150" value="${result1} ${'\n'}dattatraya" > </barcode>

Don Conrad

11/23/2021, 3:18 PM

I am trying to print the legal name on a check but that doesn't seem to be a valid field? It's using ${check.entity} right now.

Ben Goligowski

11/23/2021, 6:14 PM

I'm creating an advanced pdf template for printing checks with voucher info. I've hit a road block that I could use help with please. I cannot for the life of me seem to get the table that prints applied to information to stop at a max height. I've tried max-height, height, etc. but no luck. I've created a wrapper div and set overflow to hidden and set overflow to hidden in the table too but nothing seems to work. can someone please help me make it so the table is fixed height? We have the 3 segment checks where the check is on top and the bottom two segments print voucher info. This fixed height piece is the most important piece.

Copy code

.voucher th p {
        vertical-align: center;
        padding: 2px;
      }
      .voucher-div {
        position: absolute;
        overflow: hidden;
        left: 37pt;
        top: 9pt;
        height: 220pt;
      }

<#if check.apply?has_content>
  <div class="voucher-div">
    <table class="voucher" style="border: 1px solid black; width: 420pt; height: 220pt;">
    <tr style="background-color: #000; color: #fff">
      <th style="border-right: 1px solid black; width: 14.28%;">Date</th>
      <th style="border-right: 1px solid black; width: 28.57%;">Description</th>
      <th style="border-right: 1px solid black; width: 14.28%;">Orig Amt</th>
      <th style="border-right: 1px solid black; width: 14.28%;">Amt Due</th>
      <th style="border-right: 1px solid black; width: 14.28%;">Discount</th>
      <th style="width: 14.28%;">Amount</th>
    </tr>
    <#list check.apply as apply>
      <tr>
      <td style="border-right: 1px solid black; width: 14.28%;">${apply.applydate}</td>
        <td style="border-right: 1px solid black; width: 28.57%;">${apply.refnum}</td>
        <td style="border-right: 1px solid black; width: 14.28%;">${apply.total}</td>
        <td style="border-right: 1px solid black; width: 14.28%;">${apply.due}</td>
        <td style="border-right: 1px solid black; width: 14.28%;">${apply.discount}</td>
        <td style="width: 14.28%;">${apply.amount}</td>
      </tr>
      </#list>
  </table>
      </div>
    </#if>

And in a perfect world, I'd figure out how to push overflowing voucher info to a second page with a gap at the top to account for the first 1/3 of the check stock. This user did it but I can't figure out how to apply the page count to get it to work right.

Ben Goligowski

11/23/2021, 6:16 PM

This is what the printed section looks like now.

Don Conrad

11/23/2021, 6:49 PM

Trying to replicate the default basic check/voucher form using advancedpdf. The basic form would sum up credits, what I have now is listing them all. Couple questions. 1) How do I find the object model that's available to use? 2) How can I sum credit info by the credit.refnum? Here's the code now that lists everything... <#list check.credit as credit> <tr> <td>${credit.creditdate}</td> <td>${credit.type} #${credit.refnum}</td> <td> </td> <td> </td> <td> </td> <td>-${credit.amount}</td> </tr> </#list>

Suite Deal

11/23/2021, 10:27 PM

Hello, I have an Advanced PDF template tied to Saved Search, and for some reason, the

${result.billaddress}

does NOT respect the <br> tags that are inherent in the XML. Any suggestions?

irurzo

11/24/2021, 4:14 PM

Hello, I have a barcode that has

showtext=true

but the text shown is really small compared to the size of the barcode, is there a way to only change the size of the text under the element?

reptar

11/24/2021, 7:51 PM

Can someone remind me how to prevent text from filling the width, like newspaper text. I know there's some very particular element you can add. I can't remember.

Esteban Damazio

11/25/2021, 2:50 AM

Hello everyone! I’ve just submitted a question on NetSuite professionals about getting the days late in an individual statement, I was thinking of using the .now variable but in this template type it prints empty! Any help would be highly appreciated. Thanks! https://netsuiteprofessionals.com/question/get-days-late-in-statement-advanced-pdf-html-template-individual-statement/

Alan Fitch

11/28/2021, 8:35 PM

I'm trying to script an advanced pdf template. I've added a workbook as a data source but I don't know what the column names are. How can I find the column names?

suiteExperimenter

11/29/2021, 7:17 AM

Anyone who knows how to display Aging in Adv PDF Templates. I noticed it is in Basic but it seems it is not included in Advanced PDF

DATTA

11/29/2021, 7:34 AM

Hi all How to fetch Child Record Data in Advance PDF Template?

razer456

12/02/2021, 6:42 PM

Hi, this enduser: "" key in object has no value (please refer the picture) and in advanced PDF I have "Bill to" and "end user" boxes i want to display the "end user" box if it has some value if not then just the 'bill to" box as you can see.. but its not happening, Please help i am doing this:

Copy code

<#if JSON.data.endUser?has_content>
<table style="width: 100%;">
<tr>
<th colspan="6" class="border">Bill To</th>
<th colspan="6" class="border">End User</th>
</tr>
<tr>
<td colspan="6" class="border" style="border-top:0;min-height:40px;">${JSON.data.custBillToAdd}</td>
<td colspan="6" class="border" style="border-top:0;min-height:40px;">${JSON.data.endUser}</td>
</tr>
</table>
<#else>

<table style="width: 100%;">
<tr>
<th colspan="6" class="border">Bill To</th>
<p colspan="6">&nbsp;</p>
</tr>
<tr>
<td colspan="6" class="border" style="border-top:0;min-height:40px;">${JSON.data.custBillToAdd}</td>
<p colspan="6">&nbsp;</p>
</tr>
</table></#if>

al3xicon

12/02/2021, 7:10 PM

anyone manage to output a list of Bill Credits on the payment email notification XML template that is sent with the electronic bank payments bundle?

ericbirdsall

12/03/2021, 7:04 PM

Is it possible to string together methods? I've tried

record.shipmethod?upper_case?contains("PRIORITY")

but this doesn't catch a shipping method of "Priority Overnight"

Alan Fitch

12/06/2021, 2:51 PM

If I have a text field that's really html is there a way for me to evaluate it in freemarker as such?

Alan Fitch

12/06/2021, 2:58 PM

for example if my file value is

<p><b>hello</b></p>

I want bolded text with the word hello.

Alan Fitch

12/06/2021, 8:07 PM

@anyone?

alien4u

12/06/2021, 8:27 PM

@Alan Fitch <strong>

alien4u

12/06/2021, 8:27 PM

Or <b>hello<b />

Alan Fitch

12/06/2021, 8:58 PM

My question is how to put arbitrary html in a field and have freemarker interpret it as template text. I think this what I'm looking for. But I can not get it to work.

scottvonduhn

12/06/2021, 9:09 PM

@Alan Fitch you may need to use the

?no_esc

built-in to disable auto-escaping: https://freemarker.apache.org/docs/ref_builtins_string.html#ref_builtin_no_esc

NS Admin

12/07/2021, 4:39 PM

I've been digging through SuiteAnswer articles all morning and cant seem to find the right search query for what I am looking for. How do I find the ID of the sublist? I have a custom record (Monthly Usage - customrecord_monthlyusage) that is linked to a custom transaction. I want to display the usage on the Custom Transaction's Advanced PDF Template but all I can find is:

Copy code

<#list record.item as item>

I tried:

Copy code

<#list record.customrecord_monthlyusage as item>
<#list record.customrecord_monthlyusage as usage>
<#list record.custrecord_linktotransaction as usage> (this is the field that joins the custom record to the custom transaction)

all without success.

mattb

12/07/2021, 11:18 PM

i’m using

<pdfset><#list 1..2 as x>

to print an advanced pdf template twice, however i now only want this to action when a custom body field contains a certain value. i’m struggling to get the editor to play nice with an

<#if>

statement. would anyone have any ideas?

Azi

12/08/2021, 8:43 PM

Is there any way to use

<pagenumber>

<totalpages>

as variable so I can only display something on the last page? For example I am trying to accomplish something like this

Copy code

<#if pagenumber == totalpages>
   <pagenumber/>
       of 
    <totalpages/>
  </#if>

Slackbot

12/09/2021, 2:45 PM

This message was deleted.

tuli

12/14/2021, 9:32 AM

I am trying to print an invoice, but it shows me this error. I am trying to find out what is causing this, I am using a customized pdf template for this.