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!
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. Discover what's next at SuiteConnect Tour 2026.
Try Intelligent Payment Automation – Fee Free For Your First Month For more information, visit this thread.
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.
Don't miss out on our Question of the Week! You only have until tomorrow, April 2, 2026, 2:00PM ET to comment your answers.

My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

3950821 Newbie

Comments

  • I managed to get the data in the result set by using the formula column fields below. However, I really don't want to see two rows for every item, I just want one row. Any ideas? Column Field 1"Name" Column FIeld 2 Formula Field = CASE WHEN ({pricing.currency} = 'CAN') THEN {pricing.unitprice} ELSE LAG…
    in Saved Search - Compare rows Comment by 3950821 Mar 2, 2015 3:32PM
  • I think I found the answer here: https://usergroup.netsuite.com/users...nvoice-amounts
    in Saved Search - Compare rows Comment by 3950821 Mar 2, 2015 12:55PM
  • I had a look as well. These fields are related to the Payroll Module and the Accrued Time sublist doesn't seem to be supported yet in SuiteScript. I couldn't even find a way to search those sublist fields in the UI. All I can suggest is that you write some test code to load the employee record and then inspect the object…
    in Internal ID's of Employee Records Comment by 3950821 Sep 8, 2011 8:30AM
  • Those tags follow the custom code id's and I don't see a way to access the company information via custom code. So, I don't think that is supported (perhaps others can chime in). However, seeing as that data is fairly static, a work around would be to put custom fields on the transaction record and set their values as…
    in Custom Elements Comment by 3950821 Sep 9, 2011 9:21AM
  • https://usergroup.netsuite.com/users/showthread.php?t=16855&highlight=nlapiRemoveLineItem -- Tim Gale Lead Consultant and Founder Plat4m Development Inc. SKYPE: plat4mdevelopment WEB: www.plat4mdevelopment.com EMAIL: tim.gale@plat4mdevelopment.com CELL: 1 416 500 1486
    in Cannot Remove Line Item - not working at all (nlapiRemoveLineItem) Comment by 3950821 Feb 16, 2012 5:45PM
  • I'm not quite getting your use-case (to be honest) but the way to get the latest transaction would be to use a "Max" summary (perhaps on the internal id or something). But the concept of showing a summary count and then drilling down and just getting the latest transaction doesn't seem like a good practice to me. And I…
    in Group Drill Down Fields Comment by 3950821 Sep 8, 2011 9:12AM
  • Try modifying the inventory status report to put the preferred vendor (grouped) at the beginning.
    in It's so simplistic- so why can I manage to do it Comment by 3950821 Sep 8, 2011 9:27AM
  • Okay, after further testing here is what I've found. For a given order, let's say it has 3 line items as follows: Item 1, Qty=10, Qty Committed = 0 Item 2, Qty = 10, Qty Committed = 10 Item 3, Qty = 10, Qty Committed = 0 I create a saved transaction search as follows: Detail Filters: Type = Sales Order Status = Pending…
    in Searching for orders pending fulfillment with all items commited Comment by 3950821 Nov 30, 2011 1:47PM
  • Just updating my thread here. Figured it out. Make sure you set "Tax Line" and "Shipping Line" to false/no. Otherwise you get additional lines that throw things off.
    in Searching for orders pending fulfillment with all items commited Comment by 3950821 Nov 30, 2011 5:31PM
  • Old thread I know, but I thought I would pick this up because I have the same requirement. I tested this and there is a problem. If the quantity committed in the UI shows 0, it actually is blank/null if you run the saved search with out grouping. Therefore the line seems to get "skipped" and the order shows in the saved…
    in Searching for orders pending fulfillment with all items commited Comment by 3950821 Nov 30, 2011 11:47AM
  • Hi everyone, we're looking at implementing a barcode scanning system for our warehouse staff, but before we do I'd like to get a handle on how it will actually work. If memory serves, barcode scanners act exactly like glorified keyboards. They simply take a number from a barcode and send it as text input to wherever the…
    in How exactly do barcode scanners interact with fulfillment? Comment by 3950821 Oct 25, 2010 11:50PM
  • I think what you are asking is if it is possible to modify the form (not sublist) fields dynamically based on sublist data. If that is what you are asking, yes, you can do this with a client script. Have a look at the documentation for nlobj.setScript. The client script event model is supported in this manner.
    in How to get form object in clinet side Comment by 3950821 Sep 7, 2011 3:24AM
  • I have a scheduled script that reschedules itself upon completion (i.e. it is always running). This is the only way to handle my use-case. How do I handle situations where the script fails because NS goes down for maintenance or some other "glitch"? I want to ensure the script keeps going. Thanks, Tim
    in schedule scripts more often than once per hour Comment by 3950821 Sep 16, 2011 4:47PM
  • I have the following requirement and I don't think it's feasible but I saw this thread and I thought I'd run it by everyone. I need to produce a KPI Scorecard that shows Profit for month to date, qtr to date and year to date columns. Easy. However, I need to filter the Profit KPI on Class. I would like to have a row for…
    in 100 Ways to Use Formula Fields Comment by 3950821 Sep 6, 2011 6:16PM
  • The benefits I can see by using NS Inventory is that you will get notification to reorder when you need to, you will get the visibility you want to track things, and, by keeping the items in a different warehouse location and by using a custom search to drive your sales forms you can hide these items to keep things clean…
    in Track Consumables Comment by 3950821 Sep 8, 2011 9:03AM
  • The best practice would be to generate a quote in NS from the opportunity in SF. Then convert the quote to a sales order. Or just generate a sales order from SF into NS. This requires a very tight integration between the two applications. There are Partner offerings listed at www.netsuite.com that you should look at as…
    in SFDC Netsuite integration best practice Comment by 3950821 Sep 7, 2011 2:44AM