While not completely the same as your example I have had success storing JSON in a LongText field and parsing it using eval. While it shouldn't really make a difference the only thing that stands out to me from your instance and mine is that my JSON string is an object with an array in it. Maybe trying something like this…

In the advance PDF if you want to pull data from the line items you pull from the item sublist so your if might look something like this. The code assumes the invoice has line items and that all line item operating unit values will be the same so only checks the first line item. <#if record.subsidiary == "X" &&…

The line item(s) on the invoice should have the taxrate at the time of the transaction. Assuming there's only one tax rate on the line you could just grab the tax rate from the line item. [CODE] <#assign taxRate = ''> <!-- in the template block where you iterate the item sublist --> <#if !taxRate?has_content> <#assign…

For the blank check I would used the function ?has_content so would look something like [CODE] <#if item.purchasecontract?has_content && ! item.purchasecontract?starts_with(“VQD”)> ${item.purchasecontract} </#if> [/CODE]

If it's as simple as looking for contract number that starts with VQD, the FreeMarker function starts_with could be used [CODE] <#if ! record.contractnumberfield?starts_with("VQD")> <!-- Not starting with VQD so print --> ${record.contractnumberfield} </#if> [/CODE]

Based on my understanding of what you've asked sounds like if else block would work so something like this in the template &lt;#if record.custbody_summaryinvoice&gt; &lt;!-- template code summary portion--&gt; &lt;#else&gt; &lt;!-- template code for line detail --&gt; &lt;/#if&gt;

If I change my sample to the below I think it takes care of the one line item that might be 0 tax. The reason I'm not a big a fan of the tax date is your template could get messy if a particular region or regions starts frequently changing their tax rates. However if you want the date logic I include an example for that…

It sounds like you have a custom column field on the PO that is a custom record, and you want to pull information from the custom record. Based on my understanding there's a couple of things I think you could do 1. You could mirror the fields you want from the custom record into their own custom column fields. 2. Create a…

The background-image attribute set to a valid NetSuite URL of an image in the file cabinet on the body element of the template works. I'm not sure if you're trying to only put a background-image on a certain element but on the body element it works in my testing from awhile ago. If you want text to show on top of the image…

In the context of one template you can use a pdfset tag which allows you to have multiple PDF tags which would fix the headers and page count issue

Could you just put it in the same template as the packing slip and use a <pbr/> tag to force a page break and put your conformance content after the pbr tag? If you want a separate template for the conformance certificate you would have to rely on a customization to bring the two templates together. I have long thought the…

JCaudle I can confirm that on version 2018.2 in your Advanced PDF template if you had three fomulacurrency fields referencing them as indicated by michoel ${result.formulacurrency} for the first field, {result.formulacurrency_1} for the second field, ${result.formulacurrency_2} does work. I hadn't revisited the issue in…

I think in both instances the template render API provides methods that make this a lot easier but would mean having a suitelet generating the print content instead of the normal invoice print button. In VerdeOS case I think you could do this in an invoice template without needing a suitelet to generate the print. Provided…

I don't think the CustomerDeposit advanced PDF out of the box passes a reference to the sales order the deposit was created from. It can be done with scripting customization for sure. Do the customers who complain provide PO's or other reference numbers. If so and your staff records this info on the sales order you could…

Have you tried putting content in the body. Your example is putting together a header with no content in the body, I think this could be the cause for the expected error. Try xml += '&lt;body header="nlheader" header-height="90%"&gt;Testing PDF&lt;/body&gt;'

Would you not have to know the url format of each carrier you use and how they track shipments. Then you would have a block of code in your template that is if the shipping method is UPS do the URL this way, DHL that way, FEDEX this way

Clearly something has changed on NetSuites end. I have not touched my templates in over a month. I did however find the solution and I don't think there's any harm in using in the production environment (where there is no problem). Any field in the Advanced PDF template that you want a dollar sign, use FreeMarker functions…

You could do one search to get the invoice id's and then a second search to get the invoice details and pass that to the template which would saved 10 units over load record but regardless at that volume a schedule script will likely never complete in one run. You would have to write to a temp file so you can append to…

Just putting my vote in for Farapp. My company's been with them for a couple of years now. Implementation went great and support even with the east west coast time difference is excellent.

I don't think we have control over further filtering that dropdown, but hope to be proven wrong. Just a thought... maybe you could do your own custom sales rep field which I think would given you the filter control you want. Then when the custom sales rep field changes you could move the value to the actual NetSuite…

It's been awhile since spending some time in the workflow interface, but I know for sure you could create a workflow action script on the transaction workflow to update the customer record. I would have thought a scheduled customer workflow on a saved search running say every hour or so would eventually update your…

brucemaclennan If HR was setting a termination date could you run a scheduled script that would remove the sales rep checkbox on the employee record when the termination date arrives? Then after the script runs the employee would be removed from the NetSuite salesrep dropdown. Actually that won't work probably if you still…

I'm not in finance and these are just my thoughts having used inventory worksheets in the past. Isn't it a closed financial period? Isn't the only option do a new inventory adjustment or worksheet against the 266 items in the wrong location bringing the counts and values to zero. Re-Count the items, and then create a new…

I would think I have too but I really don't know for sure. Here's some of my thoughts but I'm open to any thoughts you have. 1. Setup an inventory location for the vendor to show the movement of inventory to that location with an inventory transfer 2. Was thinking the item where the vendor is doing something to our…

I think I've got the general idea, but I do have questions relating to purchase orders, in what locations the final assembly is built etc. We transfer the items built that are components to the final assembly the vendor with an inventory transfer to a vendor location, accounting happy because they have eyes on the product…