My Stuff

Uncover the power of data with the Analytics Hub —your ultimate guide to mastering NetSuite Saved Searches and Reports. Simplify the complex and unlock your organization's true potential. Dive into the Analytics Hub now and soar to new heights!
Hello Community! Josh Maxwell, a User Experience Researcher for NetSuite Foundation has fun a question for you. Imagine for a moment that NetSuite had an assistant like Alexa or Siri. What would you ask of your NetSuite assistant? Use this survey link to share your top questions to the assistant.

Here are some examples to get your creative juices flowing.

"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"

Ayyappan Newbie

Comments

  • Hi @Richard James Uri-Oracle Thank you for your Response..Yes, we are using SuiteCommerce Advanced, version SC_21.1.5.1. Thank you
  • Hi @Elychelle Gulen-Oracle Thank you for your response. I created the searches based on your referred SuiteAnswers, but they are not what I expected. I need to get all user aging values. Thank you Ayyappan
  • Hi Guys, 1.case when trunc({today})-nvl({transaction.duedate},{transaction.trandate}) between 1 and 30 then case when {transaction.debitamount}>0 then {transaction.fxamountremaining} else -{transaction.fxamountremaining} end end 2.case when trunc({today})-nvl({transaction.duedate},{transaction.trandate}) between 30 and 60…
  • Hi @User_HWW8S I facing the same issue. How did you solve this problem? Please share your solution; it would be very helpful. Error : "Permission Violation: You need the 'Lists -> Customers' permission to access this page. Please contact your account administrator." Thank you, Ayyappan S
  • Hi @Vajrala Madhu Reddy I created ExtensionDevelopmentTools-23.1.3 and ran the SS2 to get the saved search into the code, but I am getting an error. I allowed public access in the saved search settings, but I am still getting this error. Please help us fix this issue. Code: /** @NApiVersion 2.x @NScriptType Restlet…
  • Hi @Vajrala Madhu Reddy Thank you for your response. No, I am still working on it to create an extension to get these details.
  • Hi @Vajrala Madhu Reddy We used the NetSuite Saved Search Export Extension to obtain the code, which was then deployed and now getting response in NetSuite. How can we now retrieve this response on the website? Thankyou, Ayyappan S
  • Hi @Vajrala Madhu Reddy Thank you for your response. This error is displayed on the website as "Error 403: ERR_INSUFFICIENT_PERMISSIONS." No one on the website has admin access. In NetSuite, I have the Administrator role. Specifically need to integrate the saved search fields into the Profile Model in SC_21.1.5.1. Thank…
  • Hi @Vajrala Madhu Reddy Thank you for your response. After adding the chrome extension and obtaining the code, we encountered an Error 403: ERR_INSUFFICIENT_PERMISSIONS. How can we resolve this error? We specifically need to integrate the saved search fields into the Profile Model within SC_21.1.5.1. Could you please share…
  • Hi @Venice Jane Lejos-Oracle Thank you for your response. We need to display the values in the "My Account" section on our website. These values are aging field values for customer outstanding payments categorized by period (1-30 days, 30-60 days, over 90 days). I can get these values in a saved search, but I can't display…
  • Hi @Venice Jane Lejos-Oracle Thank you for your response. I need to this field on PofileModel. Version : SCA -21.1.5.1. getCustomFieldValue: function (fieldName) { var customfields = ModelsInit.customer.getCustomFieldValues(); for(var a = 0; a < customfields.length; a++) { var customfield = customfields[a];…
  • Hi @Theo Cruz-Oracle ' I created the custom entity field using the formula, as I mentioned in the screenshots above. After creating these fields, they are exposed in the customer form with expected values in NetSuite. Afterwards, I get the field on the website using this code: getCustomFieldValue: function (fieldName) {…
  • Hi @Theo Cruz-Oracle Thank you for your response.I created custom entity fields in NetSuite using formulas such as {aging}, {aging1}, and {aging2}. While these fields display the correct values in NetSuite customer form, they're not showing the values on our website; instead, they're displaying the formulas themselves.If i…
  • Hi @Theo Cruz-Oracle Thank you for the response. If customizations are required, could you please specify what type of customizations need to be done? Additionally, how can we obtain the internal ID for the aging fields to achieve this functionality? Thank you, Ayyappan
  • Hi @Richard James Uri-Oracle No, we can't find any solution. I need to display this field on my account page. In other tasks, I've created many item and entity custom fields in NetSuite, and I can retrieve them in SCA, but I can't get this "Aging" field,I checked for this Aging field in NetSuite Customization > Lists,…
  • HI @Theo Cruz-Oracle Thank you for your Response.I need to show this field on My Account Page.
  • Hi @Donna Balmes-Oracle Thank you for your response. I checked the Suite Answers article you mentioned. Actually, we've already reviewed it. Upon checking the logs, user event and workflow scripts are executed in less than 2 seconds. However, the API submit method takes 30 seconds. Can you please help me improve the…
  • Hi @Theo Cruz-Oracle Thank you for your response.This is not a NetSuite bundle. It's NetSuite's default functionality. We've already invoked this field in the Print Statement PDF, but we need to display this field on the website. The link is about the A/R Aging.