Cloud Red Ribbon

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