My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Comments
-
For quantity, I am thinking of the ones on the item line. so a quantity pricing breaks essentially
-
@Mikko De La Fuente-Oracle With the client script post sourcing idea, how would I look up a combination of the price level and quantity for an item?
-
Hi @Elychelle Gulen-Oracle The images are for a fictitious company in a demo account. None of the data is real. (it was just the default fake data on a Suitesuccess demo account). With the billing address, the invoice records were copied using the "make copy" function from the original invoice under the actions menu from…
-
Hi @Elychelle Gulen-Oracle The PO numbers are exactly the same. I had copied one invoice record and created the others and didn't enter this on any of the invoices The billing addresses are also the same The attached images were removed.
-
Thanks @Niks Blando-Oracle I had a related question (sorry if I need to start another thread?) Is the invoice grouping functionality scriptable?
-
@Mikko De La Fuente-Oracle The record is in edit mode How would I use a saved search if the record hasn't been saved yet? What kind of script would be needed for this?
-
The record was in edit mode. It still wasn't sourcing a value and returning an error though Is this custom field supposed to work? Or can this only be scripted?
-
@Mikko De La Fuente-Oracle i have tested this as follows: The item's record:
-
Hi @Mikko De La Fuente-Oracle The price level will be from the item record. I have tried setting up a custom field that sources the price level directly However, the price level I am interested in isn't available I can only have this field auto populate with the base price In this example, the rate charged for the item is…
-
Re-tried it (I must have had a quote or comma in the wrong place) and it now works In the source view: <#--FM:BEGIN--><a href="${record.custbody_if_invoice?replace('<[^>]+>','','r')}">${transaction.tranid}</a><#--FM:END--> Thanks Jack!
-
Found how to create the saved search on here:https://suiteanswers.custhelp.com/app/answers/detail/a_id/90124/~/create-a-custom-field-that-links-an-item-fulfillment-to-an-invoice
-
Hi @Jack Daryl Espiel-Oracle Apologies for the delay in responding. I have just got around to testing this. I have ended up moving the hyperlink to an email instead of the PDF. Should the same solution work in a scriptable template seeing as that also uses freemarker? I have tried the following though am getting an…
-
Hi @Mikko De La Fuente-Oracle I can't see how to create a saved search to reference the item fulfilment from an invoice. There are "2 degrees of separation" in the sense that the IF record is connected to the sales order and not the invoice record. In that scenario, how would I query the item fulfilment transaction…
-
Thanks so much for the suggestions @Jack Daryl Espiel-Oracle I had managed to get the field to populate after moving the the workflow action to another state It was populating an unusual value however. I couldn't see where this was sourcing from on the customer record. After using your suggested formula, it is populating…
-
Thanks @Mikko De La Fuente-Oracle The suiteanswers link is referring to the companies sublist as part of the contact record I am after the contact sublist on a company/customer record though This is on the records browser However, in my example above from a demo account, I can't get any of the contact from that sublist…
-
Thanks @Kristoffer Viray-Oracle That worked. I want to mark your answer as 'accepted' though I accidentally selected "no" for "does this answer the question"
-
Hi @Jack Daryl Espiel-Oracle there is no tax total field since the pdf relates to an item fulfilment record which, from what I can tell, doesn;t have dollar values on it and only quantities. The dollar values are sourced from the sales order referenced in the {record.createdfrom} field
-
Thanks @Mikko De La Fuente-Oracle I have tried the following revised code: define(["N/record"], function (record) { /** * @param {UserEventContext.beforeLoad} context */ function beforeLoad(context) { if (context.oldRecord == null) { var recordObj = context.newRecord; } else var recordObj = context.oldRecord;…
-
Hi @Kristoffer Viray-Oracle There wouldn't be any custom field set up in the typical sense (e.g. like custbody fields) They are created within the script for the purposes of storing values temporarily when the script is triggered. They are both of the type "FLOAT" Is that what you meant?
-
Hi @Mikko De La Fuente-Oracle I don't see any options to do that with a scriptable template email: There are no fulfil/receiving transaction; applying transaction,etc fields or joins
-
Hi Example: Packing slip advanced pdf Transaction Netsuite invoice I have changed the script so that it is now rounding to 2dp. Netsuite is set to round at a "transaction level" with this "rounding up" On the advanced pdf, all of the total figures are rounded using the following: ${ttotal?string("$,##0.00;;…
-
Hi Kristoffer The fields in the template are both float type fields: There is a userevent script on an item fulfilment page. This is before load event which sets the fields using the code above. That code is sourced in the advanced pdf where the error is produced
-
Hi @Kristoffer Viray-Oracle I am currently still testing this. I will let you know the results once I have tested this properly
-
HI @Niks Blando-Oracle Thank you for looking into this. Is there a workaround in that case? For example, if the order is not released, for it to still be picked in the warehouse using scanners? Alternatively, is there a way to set up the item so that it has the same attributes as a multilevel kit mentioned in this use case…
-
Thanks @Kristoffer Viray-Oracle To clarify, is it possible to script setting the field or how the field displays? At the moment, I can't set the field value using a workflow
-
To add to this, I have tried to set this field (the native order type field) using a workflow It doesn't accept text values: but it also doesn't accept integer values: In the case of the integer value, the workflow action is referencing another field ( which is an integer field) which should be used to set the value for…
-
Hi There Are there any updates on this? Thanks
-
Thank you @Michelle Jabanes-Oracle and @Matrim Matrim's solution to test the check box worked perfectly
-
Hi @Michelle Jabanes-Oracle I tried the exact freemarker: There are two line items though only one of them has the discontinued flag checked: The output seems to treat both items as discontinued:
-
Hi @Kristoffer Viray-Oracle thanks for the speedy response! To confirm, is the limitation only on picking tickets? The advanced pdf I am trying to source this field on is for the invoice. Thanks