Olivier Gagnon NC Red Ribbon

CRITERIA Mainline = True Type = Sales Order Date = Today Status = Pending Fulfillment SUMMARY CRITERIA COUNT Internal ID Between 10 and 15 RESULTS Internal ID - COUNT

Mmm, yeah, had the same problem. No workaround, just that Enhancement Request.

Use to_number()

+1 point to Wizard, as usual ;) You'll have to use the Pricing... join on the Item search (or run a Pricing search with an Item... join - whatever). CRITERIA Pricing... Price Level = Dealer Formula (Numeric) {pricing.unitprice}-{costestimate} GREATER THAN 0 Might need some more stuff in there, but that should be a good…

Yes, it's not documented, but it works.

The simplest way is to run a Transaction search with Type = Invoice, Mainline = true. In Columns, add formula (numeric) {datecreated}-{createdfrom.datecreated} This is the difference in days. May require additional tweaking depending on your workflow (you may want to filter out standalone invoices and such).

You can Publish Saved Search. Check the Help on the topic, there are several steps but it should sorta allow you to do what you need.

Run Unrestricted bypasses the Department/Location/Sales Team restrictions on people's roles. It does not actually allow the search to show record types the person does not have access to see. Yes, it's a VERY badly named box. I ran into the same questions as you when I had a similar problem some time ago.

It's not a simple search, but I'd give it a go from a Transaction search base. From there you can get the "purchsed withing a timeframe" criteria, then join on the customer to get subscription level and email.

Run an Item search and grab Inventory Number - qty on hand, number, etc. In this case, it's a simply join off the item record.

Each Sales Order includes the 'Estimated Gross Profit' by line item and total transaction. You could potentially access these field when customizing a report or creating a saved search. ...if you are using the Gross Profit Netsuite functionality. That is also an estimate, not reality. But it's certainly an option.

I don't believe there is a report, but you can accomplish this with a Transaction saved search. I believe since last version there are even joins on COGS transactions. So you could pull an Invoice/Cash Sale seach and substract the value from the COGS.

Hmm, I just played around a bit with the COGS Sales... join and frankly I have no idea what the prupose of that join is. It doesn't seem to do what I would expect it to. So I'll have to play around with it a bit more, but for now I am not sure what's up with that.

Indeed. If you do a Transaction search however, you will not be able to see Customer that have 0 Sales Order. If you're interested in seeing that, you can take the customer search I listed above and use the criteria: "Transactions... type = any of Sales Order, -None-" instead. Like Jim says, depends what you want to see.

I don't understand why you need 2 searches though. Why not add a filter on the item type/name/account/whatever to only grab the ones you want, and keep Transaction Total?

Customer Search CRITERIA Transactions... type = Sales Order Transactions... meian line = true COLUMNS Name - GROUP Transactions... internal id - COUNT

Yeah all system notes are text. Try wrapping it with to_number(), I think that works.

try Main Line=false and add Amount and Item

Hi Steph, You should be able to handle this with some Mass Updating. First, create a custom item field. Call it whatever you like, I'm going to call in "Inactive marker". Run a Mass Update as such: criteria -> is inactive=true, check in Inactice Marker Next, run a a Mass Update as such: creiteria->is inactive=true, set…

Yes, check in the Help, there are several conditions your search must meet to output correctly as a graph. I don't remember them offhand, but it's well explained in the Help.

Correct, it is currently imporrible to add additionnal footer filters on a Report. You can recreate the Report as a Saved Search (which allows you to add filters), or dump to Excel and work from there, as suggested.

That's actually really hard. Netsuite's "Quantity on Hand" field is always "as of now". There is no single field that holds that information. Therefore, you would need to create a transaction search and sum all inventory changes throughout time. It's not so much a single formula as an entire well-crafted search. There are…

Mhmm. I see. Maybe I'm going to have to code that search suitelet after all.

Mhm. You're getting multiple lines per item because the search is returning 1 line per item per account being hit. So typically, every fulfilled item will appear twice because it's hitting an Inventory Asset account and a COGS account. So you can fix this putting a filter on Account (or a field of, such as Account Type).…

Ahhh... COUNT counts the different unique values it finds. As the same Line ID numbers are reused over and over again, this isn't going to work. Simplest thing, use a formula to concatenate internal id and line id. Boom, instant unique value.

Here's another one I can't figure out. Real basic Transaction search Name - GROUP Amount - SUM Formula (numeric) - GROUP - dense_rank() over (partition by {name} order by {amount} desc) How come this doesn'T work?? It works when I take off the grouping on the columns... but gives unexpected error with grouping on.…

I took a quick swing at this and couldn't get it to work either, sorry.

Yeah it's a pretty generic timeout message. It's not "Unexpected Error", it specifically mentions the search took too long to come out.

Yes and no. There's no hard set limit on these things, but you can easily hit a point where the search times out in your GUI, making it impossible to run. Why exactly a search will time out and another won't is practically voodoo. Depending on the record type, searches returning half a million lines sometimes work super…

Reports do not support OR logic, sorry. Maybe you can switch to a Saved Search?