megaphone
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Stay in the know of how NetSuite can help grow your business with our guides, webinars, and events. Subscribe Here
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
What if your ERP could help surface the next step before you go looking for it? Watch here to learn more!

My Stuff

Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
SuiteWorld 2026: Watch keynotes, sessions, and product demos on demand with On Air through November 30. Register for free

3952707 Green Ribbon

Comments

  • List all customers with all invoices with such item Can you help me on the "criteria"? How would you go about it? Thanks in advance.
  • ok... Items Ordered: Add the item(s) you are referring to. Hi Wizard, Thanks for your answer. I created a new customer search, and I see that there is an "Items Ordered" field in the criteria tab, however, there is no "Item" in the results tab. Is it possible to bring that extra piece of info? Thanks again for all your…
  • You need to make a saved search for the criteria you are after. You can then create a group based on that saved search. Hi Wizard, The saved search I am looking for is based on Invoices: "List all invoices with such item and get the customer on it". However, when creating a group, I do not have an option to search…
  • I have a set of Saved Searches created by an accountant for us. Rather than having them on the Menu we did it through a naming convention so that typing it into the Global Search produces the menu selection ie SALES_[report name] so a Global Search for "Sales_" shows up as search:SALES_Monthly report search:SALES_Itemised…
  • Help anyone? Thanks.
  • Thanks Kathy, Yeah our situation is different in that we get lots of foreign transactions every day and editing them all at the end of the month isn't really feasible. But I think you've hit on how best to do this, what I'm going to try to do is update the exchange rate for a currency once a day via webservices. I'm not…
  • Hello, Is your list of manufacturers a simple Custom List, or is it a Custom Record Type? If its a custom list, you would want to solve this with a Field Change script that examines the text values and sets the other two fields base off of that. But if your Manufacturers are a custom record type, you could solve it with…
  • Hi Corey, As far as I am Concerned, the one that your are referring to has not been deployed yet. Not even sure it will be deployed in the next release.
  • Yes, here is the article with a code snippet. It has been working reliably. http://blog.prolecto.com/2013/05/30/updating-netsuites-currency-rates-programmatically/ Thank you so much. I will look into it! Since we are in the topic of exchange rates, have you found a practical way of bringing today's exchange rate for a…
  • Our experience shows that we can keep updating the exchange rate on the same date and it will use the last value. We built a Bitcoin currency integration and we update exchange rates every 15 minutes. All works clean. Hi Marty, Would you be so kind and share how you manage to script this updating process? Thanks.
  • Hello LAM, For client side scripts as you describe, yes, you can use a javascript alert() for simple debugging purposes. A commonly used FireFox Add-on called FireBug can also be used which has the ability to set break points. To debug your NetSuite client side script in Firebug. -Open the Firebug add-on -Load the record…
  • I am currently working on inbound SSO where there is also a timestamp involved. Personally I am not getting any errors but I am not being able to login either. So I guess you are in a better position since you are getting an actual error and have something to work on. Anyways, I believe NS asks us milliseconds simply to…
  • Did you solve this? How? Please share. Thanks.
  • Hi LAM, In the meantime, the 'vendorpayment' record is scriptable. Thus, if you have to implement this functionality before end of 2013, you can script it. The idea will be to create a record type 'bill payment number'. On save the payment, the script looks at the current value in custom records, increase it by one, set…
  • If you are in "EDIT" mode for a Case, you've got that data entry field "Outgoing from Support Rep" on the right hand side. I know of no way to add a signature there automatically. What SDurante says is correct -- get out of EDIT mode (i.e. save), click on the Communications tab, Messages sub-tab, and click on the 'Email'…
  • Hi All, Our marketing department is asking us to give them the possibility to create "tasks" from the Marketing Campaign Form. [LIST=1] [*]Is this possible? [*]How can we go about enabling that? [/LIST] Almost all transaction forms have the ability to generate (and auto link to them) new tasks. Why not the Marketing…
  • I have never voted for an enhancement. Where should I do it? Thanks.
  • Nope, not possible. How can I enforce they do it then? Thanks
  • You can share a personalized dashboard with other users in a specific center by publishing it. A published dashboard can consist of one tabbed page, or of multiple pages. When you publish a dashboard, you define the roles for users who will see the published dashboard, and what change users will be able to make to the…
  • Hello, Yes, it can be done. Publishing Dashboard means the Role will automatically get the 'new dashboard' when it has been published to them. This means they will get it (even if they dont like it). The Role publishing the dashboard has the overall control of what portlets will be shown and thare are 3 different modes:…
  • Thanks so much for the reply! Will you be willing to share the .Net SSO Implementation Source code? Just the URL generation part. Here is mine on a test page: using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.IO; using System.Text; using…
  • Were you able to do the SSO integration? What platform does your shopping cart runs on? I am currently trying to do SSO implementation on our website as well. Thanks
  • For multiple level joins I usually end up using a scripted solution, to collect the values and use them between searches to input to the next search. Could you please be more specific? Maybe give an example? I ran into another scenario that I need multi-level join. In this case, I am also listing invoices (everybody wants…
  • Sorry for leaving you waiting there! I don't know NetSuite's standard records terribly well, so I can't offer you any elegantly simple solutions, but I can suggest that if you need to join past more than one "level" of joining, you will probably have to use a script, so that you can run several searches one after the…
  • Since the sales order is the pivot, why not use a sales order search instead? As what was mentioned above, you can use Applied To Transaction or Applying Transaction fields for the PO linked, and then Billing Transaction fields for the invoice. Currently I do not see an ability for multi-level linking as saved searches…
  • You could try an invoice search and then use the "Applied To" transaction fields. Applied To Transaction is the SO, Applied To Transaction: Applying Transaction can get you the PO, or Applied To transaction: Purchase Order could get you the PO. Thanks for your response. I tried what you suggested, but "Applied To" brings…
  • Nope, not possible. Hi T, thanks for your response. I was working with reports and searches all day, and I saw that sometimes I have some fields available for a report but I do not have them for a search. I already checked that I am starting from the correct kind of search. Could you explain to me why this behavior? Thanks…
  • A simpler solution (similar to your "masking" solution) would be to deploy a user event script which does the following: 1. sets the standard Department field to "hidden" (use nlapiGetField to get the field, then use setDisplayType to hide it) 2. creates a new field that will replace the standard Department field (using…
  • Not sure I understand your question. If you filter on SubDepartment of <> null you will get only lower level department. As for how to show the name, I don't know where it is displayed in your case. On transaction search for instance you can display Department (which will be in the format of Parent : Child) or you can…