Searches cannot pull results from other searches, so you are not talking about standard behaviour. My guess is that you are using either custom suitelets or portlets that aggregate the results. In which case, you should talk to the developper that coded this functionality to see if they can add a column for the result…

Hmm, not sure I understand either. They are looking at their "lead list" and "lead search results". Don't they see the name of the search they are looking at? What screens exactly are you talking about in Netsuite? What menu navigation brings them to it?

Probably a long shot, but do you have negative value in your other locations? What is the value when you filter to only B or C? Do they make sense? Also, if you break it down by item, do you see anything funny? Does it agree with what is written on the item records?

Depends here on which report you're looking at, but in the footer filters, is there a "Column" filter? It is probably set to "Total" right now. Open that dropdown and set the value to "Subsidiary" and refresh the report. That should give you a breakdown by sub. Alternatively, you can hit the Customize button and then add…

Hi, If you have a higher-level sub in USD, you can roll the reports from there and see them in USD.

You could build a single saved search that returns all this info. You'll lose the Report's nice grouping UI and stuff.

Hm, ok. Are all your orders always eligible for commissions?

The first thing I'd check is make sure all sales transactions have sales reps on them

Actually you're right, you don't need commissions for sales by sales rep. I'm sure there is an explanation (well, not necessarely, there could be a problem) but maybe you're better off opening a case with Support.

Netsuite does not store historical On Hand values. You would need to run a transaction search on anything touching Inventory Asset and sum the quantities (plus and minuses) to recompute the quantity on hand at a given date. It's doable, having done it a couple of times, but not exactly easy.

I don't visualize what you mean. How could you have 2 columns? What would your lines be?

Hmm, looking at the System Notes is probably your best bet. That should be pretty accurate.

thanks but that won't do it. That is the line number within an invoice. I need a unique ID for the line item that distinguishes it from any and all other line items in all invoices in my account. I need a true database record key/id/foreignID field.. Netsuite does not have such a key. You'll have to build one yourself with…

Mmm, not sure you can achieve all this with Saved Search emailing. Saved Search emailing works, but it's pretty basic in the fine tuning you can do. Might need to set up a schedule script to send your emails.

If you substract 2 date fields, it gives you the difference in days.

If you really want to, you can achieve this with a search joining on System Notes. However, this becomes a very complex search, as you have to consider a transaction can have changed status a few times and other such oddities. It's possible, just a little long to get right.

Err, ah, sorry, had that backwards. 1. Create New Customer "Bob The Customer" 2. Create Other Relationship -> Partner 3. Run an ENTITY search Results: Bob The Customer appears once, as a Customer. "Bob the Customer" the PArtner version is omitted from the results. If you run a Customer or a Partner search, specifically,…

I noticed this too a little while back. If you do an ENTITY search - no problem. If you do a specific entity type search, such as Partner, Vendor, Customer, etc - records created from Other Relationships are not returned.

It cannot. You can't join on it.

You'll need to create an item search and join on Transactions. You can't make dynamic column headers, so what you'll have is more like ________Qty In_Qty________On_______________<-----Due----> Item_Stock_Allocated_Order_Balance___0-30 days__30-60 days__60+ days basically have time window slots at the end of the report,…

If I recall correctly, this should work. Are you using a formula (numeric) field?

Not easily; you'll have to join on System Notes to get status date changes. You'll need a lot of groupng and filtring to get something readable.

Ah yes, I see what you're saying now. Probably the easiest thing to do would be to run a search on Item Fulfillment or Invoices. You can filter easily on date created or just date, and then use the Created From... join to output all your SO fields.

sysdate has NEVER worked, fyi. today has always worked.

Hmm, try adding internal id - Count as a result and the swtich your summary criteria to count of internal id greater than 1. Also, you're looking at Tax Invoices rather than Invoices. Is that really what you want?

Couldn't you filter out based on Status - only showing SOs that are Billed?

Indeed, Reports do not allow you to use formulas in other formulas. For any sort of moderatly complex formula, I suggest you switch to a Saved Search. Or output your report to Excel and play with it there.

What do you mean you can't figure out how to get 1 line per item? By default Netsuite outputs 1 line per item, usually people have the problem the other way around. What are your criteria? There must be something in them filtering out too many lines. Try this to start with CRITERIA Mainline = false Type = Sales Orders…

Report or Saved Search? I'd recommend going with a Saved Search if at all possible. Much more straightforward. Although Shipping will appear as a distinct line, not a field.

Yes, this is an unfortunate blind spot in the Search. It simply cannot be done.