Maybe I need more information but you can change the item to last purchase price or item defined cost (if you want to include the landed cost). You will need to change it on each item record however to have it cost out correctly on your income statement. You are thinking of the "Cost Estimate Type" field (used by the…

I <3 you Thanks :)

Are you really doing a Report, or a Saved Search? You probably want to use a Saved Search.

Aren't your Activites attached to the Customer? If so, you could do a Customer search and join on Opportunities and join on Activies, that would be 1 level deep each, no problem. If your activites are attached to Opportunities, then place yourself as the Opportunity level, and then join on Customer and join on Activies,…

I think there is a filter "Component Of", so you can say Component Of is none. I think that should work.

By "another form" do you mean "another record"? Can you be more specific as to your FROM and TO record/objects/forms? Are we talking about body fields or line item fields?

Yeah those are more obscur in what exactly is going on behind the scenes. Can you do this in a saved search? It'll be easier to predict the behaviour

Hmm, are we talking about a Report or a Saved Search? I think you've mentionned both.

Would there be a difference if you changed your filter from Item.Location = XYZ to just Location = XYZ? Try running that and see if it changes anything?

If you alternatively remove one or the other filter (so that you only have the date range filter, or you only have the location filter) can you see your order?

Hi Ryan, Can't exactly log into your account... Can you spell out the details of your saved search and your order to see what the problem might be?

I'm not sure about your "item on any line" condition. Let's do this, try taking off both Item On Any Line filters, add the rest of th stuff I'll tell you, and we'll see how that goes, we can tweak from there. Start with the following columns (you could change these based on what you want to see) Number (put summary type…

Those are columns

The "Memo" field in saved searches corresponds to the Description fieldon transactions. You can give that field a shot, see if it works.

Item fulfillment main lines are also line items, so if you have some extra filtering on there, you might accidentally exclude the main line.

Not yet. I suppose I could ask my question another way: what is the difference between a saved search and a report: i.e. what does one do that the other cannot? One would have to ask which report versus what search...

As your findings suggests, NS is not consistant in it's handling of currencies in regards to One World mechanics. I suggest you take your post and file a Case with Netsuite regarding these findings. My understanding is OW is a priority product for NS so if you can report these discrepancies NS can start fixing them.

In the case of a Report, you would need to stick a bit of scripting on ever transaction to capture into a custom field the user making the change. You should then be able to output this field in many (not necessarely all) report. If you were using a Saved Search, the bove method would still work, but alternatively you…

Hmm... The only place where you'd get a change of seeing that is a Transaction search pulling the Assembly Build record. I didn't test this in a demo so not sure how well it would end up working. But that's the only thing I can think of. Maybe also Work Orders if you use those, not sure if S/Ns appear on those though.

You want to know which Serialized numbers went into the build?

That's an interesting situation. My only concern at this point would be double-checking the search pulls commitment data the same way as the NS engine does. Just an example, does your search pull SOs that are not approved? These do not commit inventory - then again, I am not sure if a search would output qty commited 0 or…

Sales Orders are non-posting and, in any case, do not impact COGS. To see the actual COGS impact, run a search on the Item Fulfillment. You can output Account and you'll see your COGS impact.

Wow good one. I can't see a way to do this purely with a saved search. Two (complex) solutions I see - A) Using scripting, for every sale, create custom records recording what was sold with what. You might need to go cross-product on this to record very possibility - maybe not, I'd have to think a bit more about that. But…

I can see this information being very useful to many people. You got my vote of "good idea" on this one!

Before we try the hard way, there is a field on Saved Searches that allow you restrict the number of results entered. If you sort by whatever column and then restrict to 10, would that work for you?

You're correct about that. Well, I've been poking around dense_rank this morning and you can't use it in criteria, apparently. So... this isn't looking too good.

Really? I have never seen a sales to affect Last Modified. Are you sure there wasn't another reason your item was being updated before?

Do you have Grouping on your search? If so, dense_rank/rank won't work, as I recently discovered. If you don't have grouping, shouldn't be a problem

Out of curiosity I took a quick look at this tool. I am not impressed. Buried in the avalanche of meaningless buzzzwords ("The only BI tool that delivers Google-Like BI Search" literally made me laugh out loud for a second there) came the realization that this thing *doesn't have a web services interface*. The only way to…

There is no native way to categorize reports, but one way that might work could be to create Custom Records. If you have mostly Public searches, you can add a dropdown of type List/Record and Saved Search to hold the actual search, and then add other fields to the record like department, a memo field, etc to help classify.…