netsuiteprofessionals #advancedpdf

NetSweat

05/03/2019, 5:09 PM

I've tried the code but nothing was showing

suitemike

05/03/2019, 5:19 PM

@NetSweat did you add the marco to the body background?

suitemike

05/03/2019, 5:19 PM

<body background-marco=“nlWatermark”

JMS

05/08/2019, 2:46 AM

We change the printer that was used in printing an invoice. But when we print the document from netsuite the text becomes blurry/dotted somelike broken characters. But when we print a document from any software like microsoft office or open office it seems fine. Does Anyone knows how fix it

fsandi

05/08/2019, 3:11 PM

Hi guys....i wonder if anyone had issues centering in header and footer in ADV PDF?

markderrick

05/08/2019, 3:27 PM

@fsandi Nope, works fine for me with regular HTML centering. Want to share your code?

scottvonduhn

05/08/2019, 3:32 PM

@fsandi one thing to be aware of is that BFO inserts paragraph tags <p></p> around the contents of all table data cells. Sometimes you have to apply the styling to the p tag in your CSS to get it to work correctly:

scottvonduhn

05/08/2019, 3:32 PM

td p { text-align: center; }

fsandi

05/08/2019, 3:32 PM

good tip, let me test that

scottvonduhn

05/08/2019, 3:34 PM

The documentation for that behavior is here, in their FAQs: https://bfo.com/support/faq/#31

fsandi

05/08/2019, 3:42 PM

that was the issue..no matter what CSS inline i used, it was overwriten by the td p. thanks a lot

👍 1

pinny frieder

05/09/2019, 1:07 PM

How do I make a case statement, case when this is null add this else add this?

michoel

05/09/2019, 1:15 PM

@pinny frieder syntax for case directive is here

michoel

05/09/2019, 1:15 PM

https://freemarker.apache.org/docs/ref_directive_switch.html

michoel

05/09/2019, 1:16 PM

But for your case a simple

<#if>

<#else>

would be easier

pinny frieder

05/09/2019, 1:17 PM

<#if ${item.vendorname} !"null"> ${item.vendorname} <#else> ${item.item} </#else> </#if>

pinny frieder

05/09/2019, 1:17 PM

@michoel whats wrong with this?

michoel

05/09/2019, 1:19 PM

Copy code

<#if item.vendorname?has_content>
    ${item.vendorname}
<#else>
    ${item.item}
</#if>

Michael Mascitto

05/09/2019, 2:52 PM

Does anyone know if it’s possible to customize an integrated label natively within NetSuite (e.g. put a custom reference number on a FedEx label)?

Don Conrad

05/09/2019, 6:03 PM

Anyone know how to determine what form is being used to print a Bill of Materials from a Work Order?

walkjones

05/09/2019, 6:04 PM

Anyone dealt with an advanced PDF that uses a fair amount of IF/Else statements that doesn’t seem to calculate them in time when emailing out a record? The form uses the same Print/Email advanced template. When I print it out it abides by the logic built it, but when email it doesnt

Katy

05/09/2019, 7:44 PM

I’m trying to set the item sublist sort order on an advanced pdf picking ticket and I can’t figure out how to get it to work. I read SuiteAnswer 77756, but apparently I suck at this. This is what it looks like as is, without the sorting. Help!!

-.txt

nikkodave

05/09/2019, 8:47 PM

Anyone familiar on how to list down a child record in a custom record? I tried this:

Copy code

<#if record.rechmachcustrecord_test?has_content><#list record.rechmachcustrecord_test as line>
TEST
</#list></#if>

Kunal

05/10/2019, 5:34 PM

Hi all, does anyone know if it's possible to add Sales Order lines to a customer statement template?

Katy

05/13/2019, 9:34 PM

How do I stop the columns from overlapping the header?

Thai

05/13/2019, 11:34 PM

Does anyone know how to bypass the max character for PDF password? After testing rendering a pdf with a password, it seem 32 character is max. I was wondering if there was a way to bypass this. <meta name="password" value="${customer.email}" /> <meta name="security-password" value="g3b5x" /> my meta data in my xml template

alien4u

05/14/2019, 4:51 AM

@Katy You should be using macros to handle your page header and footer and then on the main table declaration you use that to set the height on each one as on line 9 of this snippet.

-.xml

markderrick

05/14/2019, 12:46 PM

Anyone done anything to allow a field to handle multiple character sets? Need to get a custom field to support English and Japanese characters - NetSuite stores them fine, but Freemarker not displaying Japanese characters.

scottvonduhn

05/14/2019, 3:00 PM

@markderrick The problem could be the font(s) used by Freemarker just don't have a glyph for the Japanese characters, so they aren't able to be rendered. NetSuite now offers Google's Noto Fonts for the advanced pdf templates which cover a much wider range of unicode characters than most fonts. You can put the following in the head element:

Copy code

<link name="NotoSans" type="font" subtype="truetype" src="${nsfont.NotoSans_Regular}" src-bold="${nsfont.NotoSans_Bold}" src-italic="${nsfont.NotoSans_Italic}" src-bolditalic="${nsfont.NotoSans_BoldItalic}" bytes="2" />
<link name="NotoSansCJKjp" type="font" subtype="opentype" src="${nsfont.NotoSansCJKjp_Regular}" src-bold="${nsfont.NotoSansCJKjp_Bold}" bytes="2" />

Then, in your CSS styles:

font-family: NotoSans, NotoSansCJKjp, sans-serif;

Obviously, the downside is that you are changing fonts, and it will change both the look and format of your templates. You could use a mix of other fonts, along with the NotoSansCJKjp, though, or alternatively upload a preferred font with Japanese character support to the filing cabinet, and reference that font instead. I think SuiteAnswers has an article for how to do that.

💯 1

scottvonduhn

05/14/2019, 3:05 PM

Related question: does anyone know if there is a list of all of the font and font variants available through the

nsfont

variable? I haven't been able to find any documentation of it. I only know of these because NetSuite's default templates reference them.