Sarah Emery
Sarah Emery
  • 42
  • 71 943
How to Add Conditional Highlighting to Saved Search Columns in NetSuite
Saved searches in Oracle NetSuite natively support conditional highlighting of results, which can easily be configured on the Highlighting tab. This is a great option for simple highlighting requirements across full result rows, but how can you configure more complex needs such as changing the text size or adding a background color in a single column? In this video, I show how to use a bit of HTML code to create dynamic saved search highlighting logic that meets even the most complicated business requirements.
#NetSuite #OracleNetSuite #NetSuiteTutorial #ThatsSuite
ABOUT ME
My name is Sarah Emery and I am a "certi-fived" Oracle NetSuite ERP consultant and four-time SuiteWorld speaker with 13 years of experience. Prior to entering the world of implementing and consulting, I spent six years as a system administrator, where I developed my passion for NetSuite. Each week, I post quick videos to share some of the tips, tricks, and helpful hints that I've discovered over the years.
Visit my channel below:
www.youtube.com/@suitesarah/
FOLLOW ME ON LINKEDIN
www.linkedin.com/in/sarahameehan
มุมมอง: 1 294

วีดีโอ

How to Add Alternating Row Colors to PDFs in NetSuite
มุมมอง 6099 หลายเดือนก่อน
One of the easiest ways to improve the readability of PDFs generated in Oracle NetSuite is to use alternating colors to create a visual separation between item lines. In this video, I show how to use a single string of code to configure alternating background colors for transaction lines on Advanced PDF/HTML Templates in NetSuite. Code Snippet: style="background-color: ${((item_index % 2) 0)?st...
How to Add a Line Counter to PDFs in NetSuite
มุมมอง 5539 หลายเดือนก่อน
For many organizations using NetSuite, dealing with transactions containing numerous items is the norm. In these cases, it can be helpful to include a counter that displays a line number for each item on the PDF. In this video, I show how to easily to add dynamic line numbers to Advanced PDF/HTML Templates in NetSuite with a simple string of code. Code Snippet: ${item?counter} #NetSuite #Oracle...
How to Password-Protect PDFs Generated in NetSuite
มุมมอง 37411 หลายเดือนก่อน
In my last video, I showed you how to improve the security of PDFs generated in Oracle NetSuite by preventing user edits. In this video, I share how to add an extra layer of security by requiring a password to open and view PDFs, including configuration for both static and dynamic passwords. Code Snippet: [angled bracket]meta name="password" value="" /[angled bracket] How to Lock PDFs Generated...
How to Lock PDFs Generated in Oracle NetSuite from Editing
มุมมอง 47911 หลายเดือนก่อน
Sending PDFs as email attachments is a common practice, but it's crucial to safeguard them from unauthorized modifications. In this tutorial, I'll share a powerful trick to make your PDFs more secure with a simple snippet of code. This tipwill allow you to boost the security of your transactional information and make it harder for anyone attempting unauthorized changes to the PDF documents that...
How to Run Financial Reports by Date Instead of Accounting Period in NetSuite
มุมมอง 2Kปีที่แล้ว
Many organizations opt to run financial reports by fiscal period instead of transaction date, which is the default configuration in NetSuite. There are some instances where it is beneficial to view financial data by date instead, such as viewing the impact of a promotion on your income statement or your trial balance as of a specific day. In this video, I show how you can easily switch from per...
How to Add External Links to the Navigation Bar in NetSuite
มุมมอง 652ปีที่แล้ว
In a previous video, I walked through the process of creating Center Categories, which allow you to add links to the header navigation bar. This approach works great for saved searches, reports, and both standard and custom record types, but there are cases when you need to add other types of links, like when you want to include a link to an external site. In this video, I show how to add links...
How to Add Highlighting to the Reminders Portlet in NetSuite
มุมมอง 404ปีที่แล้ว
Having a well-configured Reminders portlet on your home dashboard can help to provide focus and streamline your activities by drawing your attention to high-priority tasks, such as transactions requiring your approval, tasks or phone calls to complete, or memorized transactions to generate. Did you know that you can make the Reminders portlet even more powerful by adding conditional highlightin...
How to Create Memorized Transactions in NetSuite
มุมมอง 2Kปีที่แล้ว
Memorized transactions are extremely useful for an array of recurring transaction types like bills for rent, monthly sales orders for repeat customers, loan-related activity, and more. They streamline the entry process by either automating the creation of the transaction records, providing recurring reminders, or simply acting as a template to pre-populate all of the necessary information. In t...
How to Audit User Login Activity in NetSuite
มุมมอง 1.5Kปีที่แล้ว
Whether you're investigating access by a specific user or just looking to identify users or roles that are no longer in use, being able to review detailed history of login activity is an invaluable resource. In this video, I show how to create a saved search that shows the last login date for all employees for all assigned roles in Oracle NetSuite. ABOUT ME My name is Sarah Emery and I am a "ce...
How to Identify Deleted Records in NetSuite
มุมมอง 1.5Kปีที่แล้ว
System Notes in NetSuite are fantastically useful for identifying when transaction records have been created or modified, but how can you find information about records that no longer exist? The Audit Trail tool makes quick work of finding records that were deleted. In this video, I walk through how to use the Audit Trail feature to generate detailed information on records that were deleted fro...
How to Unlock a User's Access in NetSuite
มุมมอง 1.6Kปีที่แล้ว
We have all been there - you come back from a long weekend or vacation, and you struggle to log in to NetSuite. Six tries later, you've locked yourself out for 30 minutes, despite needing to get into the system right away. Did you know that your access can actually be immediately unlocked by another user in your account? In this video, I show how to unlock access for a user who has been locked ...
How to Add Links to the Navigation Bar in NetSuite
มุมมอง 1.3Kปีที่แล้ว
The navigation bar in NetSuite provides quick access to the standard records for which your role has access, but sometimes there are saved searches, custom reports, or custom records that your organization uses frequently that don't appear under any of the standard navigation paths. Luckily, NetSuite allows you to customize the navigation bar using Center Categories. In this video, I show how t...
How to Create a Custom Sublist in NetSuite
มุมมอง 4Kปีที่แล้ว
Custom sublists are a great way to highlight business-critical information within a subtab on a standard or custom record in Oracle NetSuite - and they're easy to configure! In this video, I walk through to process for using a saved search to create a custom sublist. ABOUT ME My name is Sarah Emery and I am a "certi-fived" Oracle NetSuite ERP consultant and three-time SuiteWorld speaker with 12...
How to Reset Two-Factor Authentication (2FA) in NetSuite
มุมมอง 4.3Kปีที่แล้ว
This video shows a simple way to reset 2FA in Oracle NetSuite for users who cannot log in and/or are unable to access 2FA codes through their linked device. ABOUT ME My name is Sarah Emery and I am a "certi-fived" Oracle NetSuite ERP consultant and three-time SuiteWorld speaker with 12 years of experience. Prior to entering the world of implementing and consulting, I spent six years as a system...
How to Test a Scheduled Workflow in NetSuite
มุมมอง 965ปีที่แล้ว
How to Test a Scheduled Workflow in NetSuite
How to Restore a Previous Version of an Advanced PDF Template in NetSuite
มุมมอง 2Kปีที่แล้ว
How to Restore a Previous Version of an Advanced PDF Template in NetSuite
How to Send Emails for Past-Due Invoices in NetSuite Using a Workflow
มุมมอง 4Kปีที่แล้ว
How to Send Emails for Past-Due Invoices in NetSuite Using a Workflow
How to Send Emails for Past-Due Invoices in NetSuite Using a Saved Search
มุมมอง 4.1Kปีที่แล้ว
How to Send Emails for Past-Due Invoices in NetSuite Using a Saved Search
How to Set up Units of Measure in NetSuite
มุมมอง 2.6Kปีที่แล้ว
How to Set up Units of Measure in NetSuite
How to Mass Delete Records in NetSuite Using a Scheduled Script
มุมมอง 1.8Kปีที่แล้ว
How to Mass Delete Records in NetSuite Using a Scheduled Script
How to Mass Delete Records in NetSuite Using a Saved Search
มุมมอง 4.7Kปีที่แล้ว
How to Mass Delete Records in NetSuite Using a Saved Search
How to Create a Saved Search for Sales Orders with Back Ordered Items in NetSuite
มุมมอง 3.3Kปีที่แล้ว
How to Create a Saved Search for Sales Orders with Back Ordered Items in NetSuite
How to Display the Child Customer Name in Saved Search Results in NetSuite
มุมมอง 867ปีที่แล้ว
How to Display the Child Customer Name in Saved Search Results in NetSuite
How to Embed a Link to Send Emails from Saved Searches in NetSuite
มุมมอง 1.2Kปีที่แล้ว
How to Embed a Link to Send Emails from Saved Searches in NetSuite
How to Use Summary Criteria in Saved Searches in NetSuite
มุมมอง 2.1Kปีที่แล้ว
How to Use Summary Criteria in Saved Searches in NetSuite
How to Use a Custom Font in an Advanced PDF Template in NetSuite
มุมมอง 1.1Kปีที่แล้ว
How to Use a Custom Font in an Advanced PDF Template in NetSuite
How to Set Up Early Payment Discount Terms in NetSuite
มุมมอง 867ปีที่แล้ว
How to Set Up Early Payment Discount Terms in NetSuite
How to Conditionally Display One or More Embedded PDFs in an Advanced PDF Template in NetSuite
มุมมอง 666ปีที่แล้ว
How to Conditionally Display One or More Embedded PDFs in an Advanced PDF Template in NetSuite
How to Embed a PDF in an Advanced PDF Template in NetSuite
มุมมอง 2.8Kปีที่แล้ว
How to Embed a PDF in an Advanced PDF Template in NetSuite

ความคิดเห็น

  • @tsheetseMerge
    @tsheetseMerge 2 วันที่ผ่านมา

    Thanks for the video. How do you recommend testing this? I don't want the customer to receive incorrect information.

  • @dhashinidhaya
    @dhashinidhaya 6 วันที่ผ่านมา

    In the vendor record, the Tax ID field is not visible. By any chance, do you know why it's not showing? When I customize the form, the 'Show' checkbox for the Tax ID field is checked, but the field still doesn't appear in the vendor record. Do you know why this might be?

  • @marshallstinson346
    @marshallstinson346 13 วันที่ผ่านมา

    Great video, thank you @suitesarah!

  • @danielp3433
    @danielp3433 หลายเดือนก่อน

    Super helpful Sarah, thank you. Is this possible on saved searches with grouped results?

  • @grilltears
    @grilltears หลายเดือนก่อน

    Hi, It's really helpful to embed existing pdf file. But in this way I am straggling to embed pdf file which is store in assembly item record document field. Is there any quick tips. thanks on advance. Below is my code: <#if record.assemblyitem.custitemproduct_specification_artwork?has_content> <#assign fileUrl = record.assemblyitem.custitemproduct_specification_artwork?replace("&", "&amp;") /> < src="${fileUrl}" width="100%" height="500px"> <p>Your browser does not support s.</p> </> <#else> <p>No PDF file available for this item.</p> </#if> but its through error

  • @jagdishchamat9567
    @jagdishchamat9567 2 หลายเดือนก่อน

    Hi I did get the error Analytics report. No data displayed. You cannot divide a number by 0. Review the formulas and try again. for a transaction data based analytics report. I found that there were some transactions those were causing result to ZERO amount for the column which was in denominator in a formula. So I removed those transactions by their status from the dataset, Please try if it matches with your issue.

  • @Chris-kaja
    @Chris-kaja 3 หลายเดือนก่อน

    Hi Sarah, I would like to insert or add a sign into my Invoice. Could you please to explain more detail about this. Thank you very much..🙏

  • @ctstyrerecycling6027
    @ctstyrerecycling6027 3 หลายเดือนก่อน

    Amazing content, again!!!! Thanks for sharing!

  • @ctstyrerecycling6027
    @ctstyrerecycling6027 3 หลายเดือนก่อน

    Amazing content!!!! Thanks for sharing!

  • @Robert-j8i9p
    @Robert-j8i9p 3 หลายเดือนก่อน

    @ericK_Smith do you know a way to reset this when it's multiple accounts?

  • @michelewetzel5590
    @michelewetzel5590 3 หลายเดือนก่อน

    I would have liked to see a copy of the email they're receiving. Still good videos, thank you!

  • @jdporco
    @jdporco 3 หลายเดือนก่อน

    How would you set highlighting for a Formula (Numeric) column?

  • @johncostello9579
    @johncostello9579 3 หลายเดือนก่อน

    regarding the asset account change, will this make an associated JE for moving the balances from one inventory account to the other asset account?

  • @Satrangi24
    @Satrangi24 3 หลายเดือนก่อน

    Thanks Sarah! This is an ingenious tidbit.

    • @Satrangi24
      @Satrangi24 10 วันที่ผ่านมา

      Hi Sarah. So after waiting for our Christmas office shutdown and going through and updating a whole bunch of PDFs to lock them, we have run into a snag Day one. This lock also stops you from printing. Any idea how to bypass that and still have a lock?

  • @Satrangi24
    @Satrangi24 3 หลายเดือนก่อน

    Lifesaver, Sarah! I was trying to figure this out for multiple T&Cs according to a field value. Thank you so much!

  • @Tailorhartman
    @Tailorhartman 4 หลายเดือนก่อน

    I'm curious if you know of a way to remove the Shipping/etc from the net terms calculation? I don't think it's currently possible but I figured I'd ask.

  • @cliffclairespicyreviews3502
    @cliffclairespicyreviews3502 4 หลายเดือนก่อน

    Can you make a video doing the same method with Transaction like Credit Card.

  • @shrongelber6449
    @shrongelber6449 4 หลายเดือนก่อน

    is there a way to get a P&l report showing a Jan-July 2024 months by columns?

  • @mattnichols2738
    @mattnichols2738 5 หลายเดือนก่อน

    this was a great intro.

  • @agusrobs
    @agusrobs 5 หลายเดือนก่อน

    Fixed a huge issue I had with that join! Thank you so much Sarah!

  • @nandinipushparaj3548
    @nandinipushparaj3548 5 หลายเดือนก่อน

    Thank you!! Can you share how to send recurring email for past due invoices every 10 days until the invoice is paid. Thanks!!

  • @rafaikhtiar9207
    @rafaikhtiar9207 5 หลายเดือนก่อน

    Thanks for the video. That's very helpful. Do you also have a video that I can use to send email remittance advices after a payrun? If so, that'd be so helpful.

  • @NenadMatic-o8s
    @NenadMatic-o8s 5 หลายเดือนก่อน

    Pretty cool!

  • @MG-tu4cm
    @MG-tu4cm 5 หลายเดือนก่อน

    Great stuff, but I am curious. If you wanted to utilize this approach in a Sandbox environment but then incorporate into a bundle to roll out to several NS accounts, do you know if there is a way to make that link more generic and work across multiple NS environments? With the current set up, it works great for one off installations because the URL is specific to the environment, but what if you want to build out custom searches to share across several?

  • @samanthasparks8575
    @samanthasparks8575 5 หลายเดือนก่อน

    Thank you sooo much!

  • @asdisloyalty
    @asdisloyalty 6 หลายเดือนก่อน

    Is this only for "scheduled" workflows. What if I have a workflow that is for cases and I want it to automatically send emails based on case status updates. I have my workflow set up but I am having trouble figuring out how to test it out?

  • @luckykumar638
    @luckykumar638 6 หลายเดือนก่อน

    Hii Sarah, I am creating the reversal JV by using the reversal date field available on journal entry page and use the defer entry option but on the reversal date system is not passing journal entry automatically but it is shown in memorized transactions. Can you please help me in this why this is happen??

  • @MaxAnkum-zy5hk
    @MaxAnkum-zy5hk 6 หลายเดือนก่อน

    Thank you, very informative!

  • @TimothéFeodoroff
    @TimothéFeodoroff 6 หลายเดือนก่อน

    Thank you this saved my life!

  • @jaredsmith7834
    @jaredsmith7834 7 หลายเดือนก่อน

    For custom records, when you say at 2:09 use "the ID listed on custom record definition" I don't understand. I assume this is what I find in url? rectype=239 for example. I upload, but it will give an error - Syntax error: illegal character Not sure why. I'm also wondering if you can call function name whatever you want as long as there are no spaces? If it needs to be a specific name (picked from select options) where can I find options for functions in NetSuite? Thanks!!

    • @jaredsmith7834
      @jaredsmith7834 7 หลายเดือนก่อน

      I figured out the illegal character issue. When copying the script from the linked article it pasted a back quote instead of a normal single quote. When deploying the script it failed though because the record type was invalid, so my question still stands regarding that.

  • @ThePitrock22
    @ThePitrock22 7 หลายเดือนก่อน

    What is the best way to test this before going out to a Customer?

  • @justiceyanke4938
    @justiceyanke4938 8 หลายเดือนก่อน

    Thanks for the help! Any suggestions on how you would be able to add "Additional Receipients" using that HTML formula? Thanks!~

  • @Erick_Smith
    @Erick_Smith 8 หลายเดือนก่อน

    This wont work when the user is an administrator of multiple accounts of which my own account is not an administrator in.

  • @Ashok_ON
    @Ashok_ON 8 หลายเดือนก่อน

    Hey Sarah, I've noticed something. It seems that when we use HTML formulas to highlight columns, the saved search doesn't appear to be available for dashboard view, even though the "available for dashboard" option is checked. Am I overlooking something here?

  • @MaxAnkum-zy5hk
    @MaxAnkum-zy5hk 8 หลายเดือนก่อน

    O wow... That's really useful!

  • @DanielStahl-um2zc
    @DanielStahl-um2zc 8 หลายเดือนก่อน

    Hello, I haven't read the comments on this video to see if anyone else mentioned it. I think you have to use Formula (HTML) now right?

    • @suitesarah
      @suitesarah 8 หลายเดือนก่อน

      Hi Daniel! You’re absolutely correct! There’s a note in the description that mentions the change and includes a link to another video that I did discussing the introduction of the Formula (HTML) field type. Thanks for the comment - the new field type was certainly a surprise when it was introduced. ☺️

  • @LukeChristian-hm6se
    @LukeChristian-hm6se 9 หลายเดือนก่อน

    I have been searching for exactly this solution for months! Thank you so much for this video, I'm excited to add it to so many of my saved searches and now I can't wait to watch all your other videos!

  • @daveisherwood121
    @daveisherwood121 9 หลายเดือนก่อน

    Hugely useful and very easy to do! Thank you for sharing.

  • @Mammon615
    @Mammon615 9 หลายเดือนก่อน

    Hi Sarah, I'm trying to use your tips and they work when I simply want the amount field changed. I'm having issues with a formula that uses WHEN (x field is true) THEN {amount} how do I put the color and the {amount} field past the THEN?

  • @falconaire__
    @falconaire__ 9 หลายเดือนก่อน

    .may i know if there is a way to remove blank extra lines on the saved search result? or if you already covered? thanks!

  • @AnnDumais
    @AnnDumais 9 หลายเดือนก่อน

    Do you have a video on creating custom invoices and statements?

  • @jarmand
    @jarmand 9 หลายเดือนก่อน

    Sarah, Love your videos. That music is an earworm. Keep ‘em coming. Are you going to cover how to use all this PDF goodness for HTML templates?

  • @dylinkuni
    @dylinkuni 9 หลายเดือนก่อน

    This is excellent! Today I encountered this exact scenario for a vendor select. Thank You.

  • @richarddu844
    @richarddu844 9 หลายเดือนก่อน

    this only works if the transaction lines were added sequentially without edits (remove line/ insert line) during data entry. 🙂

    • @suitesarah
      @suitesarah 9 หลายเดือนก่อน

      Hey Richard! Great callout. That is true if you’re using the Line ID field in the template, but using item?counter eliminates this issue since it simply starts at one and increases the value by one for each additional item line. For this reason, I recommend using it in place of the Line ID in PDF templates.

  • @brispence2830
    @brispence2830 9 หลายเดือนก่อน

    Hi there Sarah! HAve you utilized this function and have you had any negative impacts from adjusting the hiearaarchy. DId you have to recreate any allocations or mappings after the fact? I would love to hear from someone with experience.

    • @PKG-Controller
      @PKG-Controller 4 หลายเดือนก่อน

      good question.. Would love to hear her feedback soon!

  • @kborkholder
    @kborkholder 9 หลายเดือนก่อน

    SARAH! I was so hyped to see you at the virtual meet up today. My team already thinks I'm a nerd for how I go on about NetSuite and then i shout out while at the meet up - Oh my goodness I watch Sarah's videos!😄

  • @AmalMgaresh
    @AmalMgaresh 10 หลายเดือนก่อน

    So glad I found this - they way you just saved me !!!!

  • @valeriesteele8582
    @valeriesteele8582 10 หลายเดือนก่อน

    Your videos are awesome. Thank you

  • @DianeGuffey-h3i
    @DianeGuffey-h3i 10 หลายเดือนก่อน

    Great explanation and simple to understand.

  • @KCchamp007
    @KCchamp007 10 หลายเดือนก่อน

    Hi @Sarah Emery thanks for the videos about the many topics, could you be able to help me with fetch the Revise ship date from the SO when the user clicks on Special order and it goes to PO and update the fetched values to Expected Receipt date