Hi Evan - I just want to show average sales for any given product! Forget about the supplier bit. Average sales! The only thing it has to do with suppliers is I will use this "Average Sales" column in the results under the "Financial" tab to assist with creating purchase orders. I thought this would be a very simple thing…

Thanks for trying Evan - this is just too hard and it shouldn't be. An accounting system that can't show you sales for a period... Enhancement Request# 753843

You mean to tell me that this wonderful beast called Netsuite cannot so a simple sales calculation? My oh my what a wonderful day... I don't think this should be an enhancement request. This should be a given. I am yet to have one enhancement request passed in the 2½ years we have been using NS - I don't see the point in…

I wouldn't know where to start. I think this is going straight to the too hard basket. Seems like it would have been a really simple thing to do.

Thanks Evan I've survived this long without it. A couple of months won't hurt.

CSV import for stock adjustments sounds interesting. Anyone be able to enlighten me? Export a saved search of your inventory. Using the internal id fields to import again with another field for Quantity on hand. Go to Setup>Import/Export and use the import wizard. The Quantity on hand field (when mapping - 2nd last step)…

what about a csv import?

What year is it?

Imperial measurement are so accurately named...

I just love the word retroactively!

Has anyone got this working? I'm following the suite answers article and I get ERROR: Field Not Found

Our schedules are sending, but not on update! Somethings awry here...

Well the display name field has a field id of displayname. So maybe {shipmethod.displayname} ? Or the ship name field has itemid, so {ship method.itemid} might be what you're after?

Yay. More Netsuite awesomeness!

But I like fire.

Shouldn't it be "=" and not "IS" ?

Ahh! I read the = as not being part of the statement, rather an indicator that you were about to start your statement!

What if you grouped your results by internal id? That should give only 1 listing.

Works for me, although I did formula Currency, not numeric.

Actually... it was a jquery function. getUrlVar('var') so... to get the text in bold, you should just be able to script something like this, assuming you have the jquery library installed: var result=getUrlVar('IdUid')

It would have to be a summary search and then you would do a count of item I'm yet to understand exactly how Summary Searches work.

I've done this recently but can't recall exactly how. something to do with a command called getparam I think.

Hello, As of Version 2012 Release 2, you can set the time of day when scheduled reports are run and saved search email messages are sent. You can read more regarding this in SuiteAnswers 'Version 2012 Release 2 Release Notes' Answer ID: 23715 Thank you. Fantastic news! No more shall we have people complaining that we…

Perhaps a workflow rather than a saved search might do it?

Do you have "Main Line = True" as a search criteria?

ok. good luck!

So does it not do what you want if you have main line = T?

I think it will be easier in picture format... https://docs.google.com/leaf?id=0B0alVLnTBcClYTkyMzA0ODUtODRhMi00YmU2LTkxNzAtZjRlMDYyOGMxNDNh&sort=name&layout=list&num=50

Or try something like this: ( nvl({quantityonhand},'0') + nvl({quantityonorder},'0') - nvl({quantitybackordered},'0') ) / nullif(nvl({preferredstocklevel},0),0) LEGEND! Thanks heaps!

Hey I tried your method and at least it didn't throw the above error... I've got :ERROR: Field Not Found: - but it's an improvement!