Jack Daryl Espiel-Oracle Gold Crown

Thank you for providing our requested information, Gustavo. One more thing we'd like to confirm. Is the Category Attribute field a Custom Field of either List/Record or Multiple Select Type? List/Record fields are dropdown fields where only a single value can be selected while Multiple Select fields allow selection of…

Upon checking, the behavior you're observing is expected after enabling the Advanced Item Location Configuration feature. To get around this, you need to Save the item first then Edit it to show the Locations sublist. If you have further concerns, please let us know. -Jack @"Jack Daryl Espiel-Oracle"

You're welcome @"4283453". Glad to help you! -Jack @"Jack Daryl Espiel-Oracle"

Hi @"Sophie Sk", Please be informed that we will look into your inquiry and the respective Gurus who are expert in the subject will get back to you with an update. -Jack Jack Daryl Espiel-Oracle Ask A Guru

Yes, you are correct. You would need to add the missing Column Fields under the Results subtab when customizing the sublist. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"NS_YB", Thanks for sharing your solution. Glad that you have made it work on your end! It will be also helpful for other users with a similar requirement. Cheers! -Jack @"Jack Daryl Espiel-Oracle"

Welcome to NetSuite Meherin! Interesting question you have there. To customize the Locations sublist of Item Records, you need to enable first the Advanced Item Location Configuration feature in Setup > Company > Enable Features > Items & Inventory subtab. See screenshot below: After enabling the feature, the Customize…

Hi @"4184888", Please be informed that we will look into your inquiry and the respective Gurus who are expert in the subject will get back to you with an update. -Jack @"Jack Daryl Espiel-Oracle"

That is an interesting question @"4195241". To help you better, may we ask the following additional information: 1. What Type of Saved Search are you setting up (Transaction, Customer, Employee, etc.)? 2. Is the Seller in your scenario refers to Employee Records or Vendor Records? -Jack @"Jack Daryl Espiel-Oracle"

Great question @"Ivar_42618"! Here is an approach in handling division by zero/null in freemarker: <tr> <#if !(item.custcol_list_rate??) || item.custcol_list_rate!=0> <#-- Check if divisor/denominator is not NULL or not equal to zero (0) --> <#assign varA = item.amount/item.custcol_list_rate> <#-- Proceed with the…

Apologies for not so soon reply @"RafaelM". I have branched your follow-up question in a new thread by the way. To display the result of a Summary Saved Search in a Custom Record with Date as a filter, make sure that the Show in Filter Region option is enabled in the Saved Search then set up a Custom Sublist based on the…

Hi @"jmohr", I have branched your follow-up inquiry into a separate thread. To create a filtered Custom List/Record Field based on the value of the Entity Status Field, you need to first set up a Custom Record Type where its entries serve as the dropdown options, with a Multiple Select Field for the Entity Status Filter…

Hi @"ehaynes", Can you try selecting the Workflow : State : Approve Action option from the Action dropdown field on both Approve Bill Page and Approve Journal Entries Page if the sublist would show the records for Pending Approval? See sample screenshots below: Hope this helps. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"4180980", Upon looking into your follow up inquiry, I found out that printing Transaction Fields in the Item Label Template is currently a limitation since its scope is narrowed down for printing Item Labels only and limited only to fields listed in SuiteAnswers 73909: Standard Item Label PDF/HTML Template. However,…

Hi @"Martin Randall", Since Dashboard Tiles is a Bundle/SuiteApp that is not natively available in NetSuite and was developed separately, you may have to coordinate with your Account Manager for requesting support for the SuiteApp's Functionality Concerns. They will in turn get in touch with the owner of the SuiteApp and…

Hi @"PaulFleetwood", Upon checking, showing the information of the Bill Payment's Credits Applied Sublist in a Saved Search is currently a limitation of NetSuite and the following related Enhancement Request has been filed for this: Enhancement 213645: Saved Transaction Search > Type is Bill Payment > Ability to Pull Up…

Hi @"NS_YB", Can you try using ${transaction.salesorder} to reference the Sales Order Number from the Customer Deposit in the Email Template? Hope this helps. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"4180980", Here are some useful resources that can help you construct the Advanced PDF/HTML Template Code for your requirement: SuiteAnswers 73900: SuiteBuilder Advanced Templates Reference SuiteAnswers 73909: Standard Item Label PDF/HTML Template SuiteAnswers 26500: Syntax for Advanced Template Fields Apache…

Here are some additional things to verify to make the Saved Search Email Alerts work: 1. In the Saved Search, make sure that you copy the Employee Name exactly as shown in the header part of the Employee Record to the Updated Fields subtab > When New Value is... field without any additional characters such as white spaces.…

Hi @"veronicap", Based on the results of my testing, the Email Template code you provided lacks the condition that prints only the line item(s) with zero quantity. See screenshot below for the code that should be added: As for the rest of my setup, I created a Scheduled Workflow that sends out the Zero Item Quantity…

Hi @"NS_YB", Please be informed that we will look into your inquiry and perform some testing. We will get back to your once we have an update. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"E St. Angel", Upon checking on your inquiry, adding Transaction-level Fields such as the Invoice's Subsidiary in the Customer Statement is currently a limitation of NetSuite and the following related Enhancement Request has been filed for this: Enhancement 166706: Customer Statement > Ability to source and add custom…

Thanks for the feedback @"paula.courtemanche"! We really appreciate it -Jack @"Jack Daryl Espiel-Oracle"

Hi @"4188728", Upon checking, the other Project Manager field (without the Custom keyword) that can be selected in the Criteria and Results subtabs is the Standard Project Manager field built into NetSuite. In the Updated Fields subtab, the field is referenced differently by the name of Job Manager. See screenshot below:…

Hi @"4188728", Apologies for not so soon reply. To answer your first follow-up question, you would need to create separate Saved Searches for each Project Managers with values on Specific Recipients subtab > Recipient, and Updated Fields subtab > Field & When New Value is... fields set accordingly depending on the Project…

Hi @"Karen Hottle", Upon checking, there is no separate Close Purchase Order permission available yet and currently, it is a part of the Edit level of Purchase Order permission. However, there is a workaround via Basic Customization using Custom Forms and Role Form Restrictions but it has limitations where some fields are…

Hi @"veronicap", Please be informed that we are looking into your inquiry and will conduct some testing. We will get back to you once we have an update. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"b2deaec2-a785-4bf4-90a4-12d9a9514a22", Can you try replacing the Parentheses () in your formula with Curly Braces {} if it would make the formula work? -Jack @"Jack Daryl Espiel-Oracle"

Hi @"JCronin", Upon checking, the reason why the Convert to Custom Record option becomes disabled when making the Custom List as Matrix Option List is that NetSuite does not support Custom Records as Matrix Item Options yet and the following Enhancement Request has been filed for this: Enhancement 64012: the ability to…

Hi Shannon, It seems that you have provided a screenshot but it does not show up on the page. Can you try reuploading it again? -Jack @"Jack Daryl Espiel-Oracle"