My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
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. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Staying Connected During the Holidays
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Comments
-
Thanks JBounds. Reason for search, is because I want to export to CSV - So I can keep track and change the images once the item goes off sale.
-
Unexpected Error is back again ...this time when I add my days left formula in the criteria : with less than or equal to 30. If I can get this working - we will have a small list which will only show items which will run out in a month, instead of items where it has 200 days left..…
-
Cheers Rushnp774, Going of Netsuite enchancements, I think it's going to be another 50 years. Current enchancements I've seen goes back to 2002! :D
-
Thanks Evan, I got it to work :D In my saved search I have a column to show me qty sold in the last 7 days (average), and one for 14 day average. I have a 3rd column which adds both averages and then divides by 2. A fouth column to show me how many days left - by dividing stock left over with average. The other issue I…
-
Evan is awesome :D he helps out alot! I was suprised at first when I googled his name - and that the founder of Netsuite helps out on the formus. I mean to say, you hardly see any CEO or founder of a company helping small fries like us :P You got snow :rolleyes: wow..
-
We've been thinking the same..Why a company so big can't handle quick fixes like these - and have to wait for votes? it's annoying... anyway hows kansas :D
-
Hi, Apart from the saved search, I am trying to display a flag or some sort on Purchase Orders or Sales Orders. I have brought in vendor name in sales orders, what I want to achieve is to check if the suppliers are different, if so then display flag. If there a way, I can add the line items together? I can see there is a…
-
erm, never mind :) I know what I was doing wrong.. I was trying to use the date ranges to look at today vs yesterday & this month vs last month..So now, I have display it separtely today, yesterday , this month, last month etc. is there a way to do it by dept? I think it would be easy as adding dept? the rest will remain…
-
Hi Shale, Thanks for your reply. I did as you advised, but am I setting up KPI as a formula? KPI Tab -> Selecting Formula Numeracy and then use formula KPI1/KPI2? If so, then it is not working.. It is showing N/A - When I click on the N/A it display the figures like this.. I tried to click on the custom tab and select…
-
Hi Shale..Thanks Pal...Thats Great :D Btw how long have you been using NS? I have 0 experience on Oracle, SQL or Formula's lol..
-
I could be wrong, but the above fomula has {custrecordevent_type_2.id} and the bottom does not have the '.id' Maybe take that out? Mayur
-
I have noticed this, if I use {today}-{transaction.trandate} between 0 and 7 then the dates I am trying to pul up will always change. I am trying to have them fixed. so I can see the sales for the whole month? So, I have created this formula but it doesnt work - Brings up invalid expression. Case when {transaction.account}…
-
I felt like I was getting annoying having to keep asking..so I apologize. I do need some help with something else, but after reading other Threads, I don't think there is a answer..
-
Update - I tried 'between 0 and 7' and it works. I have checked a few items. as there were mainly 1 or 2. More Testing!!
-
Hi Kelly, I have this as my criteria & Results : Criteria - Matrix Item - False Transaction : Date - Is Within Previous One Year Transaction : Type - Is Any of Cash Sale, Cash Refund Display on Site : True Results Name Display Name Formula...CASE WHEN {transaction.account} = '1100 Sales' and ({today} -…
-
Cheers Mate, I will look into it and replicate it. the other bit I just seen is how you got it like > 3 weeks sales, 2-3wks, 1 wk. Could I copy this and change it by month? I am still learning Netsuite, so what do you mean how did I get the inventory into the system? and I selected Description, but what do I type in the…
-
Thanks Kelly, I will have to postpone this for a while, we have other issues right now. I will get back to you once I get some time to test this. Thanks Mayur
-
Hi Mark, Yea last week was really hot and sunny. about 28 Degrees. but now these week even though there is sun, its cloudy and rainy.. apartly gonna snow on Friday. Do you get a lot of snow? back to the problem :D I wish there was just a date selector. Sales effective date and Transdate is both the same? Right? Why can't…
-
nvm, I got it working :) Thanks to you Kelly!! I was just searching for Date in the forums and found one of your formulas in '100 ways to use formula' thread. {transaction.trandate} >= to_date('01/10/2011', 'MM/DD/YYYY') and{transaction.trandate} <= to_date('31/10/2011', 'DD/MM/YYYY') Thanks Dude.
-
Hi Kelly, Hope your well :) I am trying to copy your buying_take action saved search to show me sales 3 months ago..(5th August 2011) and then generate between 2 months (05/08/11 & 04/09/11) and then 1 month ago (30/09/11) I have tried the following formula and having difficulties with it CASE WHEN {transaction.account} =…
-
Morning Mark, Hows Rosemere this morning :) Really wana see Canada. Sorry back to the problem. I have tried that, without selecting a date at the bottom it brings in 1478 items. When selecting the date at the bottom (any date) all the items disappear. I don't think 'Transaction : Date' will help, because if a Item has had…
-
anyone else? Please, could someone help? Thanks
-
Hi Mark, thanks for the reply. I used the 'within' 1/10/2010 and left the end date blank, that is why it appeared only. I have changed it now but selecting 1/10/2011 date it shows 18 items. I know we haven't sold every single item (2544) since Saturday. Maybe 100. So I want the report to show 2444, If I select Saturday…
-
How can I highlight in a (sum) Numeric Field? I have a search to show me sales by months (Jan-Nov 11), and there are loads with zeros. Is there a way to highlight the 0. just the cell not the whole row. thanks
-
Well as far as I know we didnt place a Purchase Order. We just used Inventory adjustment. The second bit, the only thing I am trying to put up are non matrix items (parents) and all the items where the date has been empty. But here is the complication. Lets say Item 1 was put live in Jan 2011 and had only 10 sales, Feb…
-
Hi, I'm in a similar problem. I got a Transcation saved search to find all unfulfilled and trying to display the item code & store display name, however Netsuite is not bringing them in?? Criteira : Status : Sales Order - Pending Fulfillment Type : Sales Order Main Line : True This shows me : 57 Results. If I change Main…
-
I have just after posting that. I tried contains : billing county contains : Aberdeen, 'AND' contains : Midlothian. but that didn't bring up anything.
-
Hi MChamma, No,I wanted to pull all the scottish counties together. If I used OR then It would ignore one of them. However I managed to do this in a Report and Filtered only Scottish Counties. So thank you all. Cloud
-
Hi Joanne, Firstly Create a New search -> Suppliers and click on Personalize. Click on Results and select Formula (text). Type your entity field ID in the Formula Field. (if you are unsure then go to Customization and Entity. you will find the ID next to the Name) E.G - {custentity_birth} Dont forgot the curly brackets.…
-
Evan's Awesome :D that was a complicated formula :D