Olivier Gagnon NC Red Ribbon

Run an Item search, join on Transaction to output Date. Add a a GROUP on Item and MAX on Date. In the Summary Criteria, add a filter so that MAX Date is 12 months old

You are using a join in your columns, so you must use the same join when using getValue. var msgValue = searchresult.getValue('recipient','messages');

Hey Mike, I think a Formula field with something like sum({custitem_fixed_cost})*max({custentity_currency_field}) would work. It's a little tricky, it needs avanced formulas. I'd have to play around a bit to get it right.

Well if your search is correct, you can export the results (you only need internal id, really) and the CSV update. The only fields you'd have is internal id, mapped, and you can hard code inactive to true. There shouldn't be any danger to that.

Assuming he was using the Vendor login, that sounds about right.

Hmm... Could it be one was created with the "Other Relationship" link? That creates pretty close links between the different entity types.

I don't think so, I've never had any problem like that.

I don't understand why filtering with Inventory Location wouldn't work. Can you explain?

Create an Entity search (Reports->New Search) with the required fields and press Export to CSV.

Mike, You should be able to output items by locations. Make sure to use the columns "Inventory Location" and "Location On Hand". It's possbile your results look a little funny as location that have no on hand (blank) can play tricks on you. I usually add 2 filters - Location On Hand greater than 0 and Location On Hand not…

Are you saying you have some items that have the location coded into the item number, rather than having the item's transaction be actually set to the given location? Like, you have an item named "ItemABC-Warehouse001" on a PO, but the PO has no Location set on it? And from the item's name you should derive that ItemABC is…

You're going to have to do a string compare. You can't crack open a period to see what dates it represents. So you'll have to take the trandate, isolate the month and year, and construct a string to match your period nomenclature, then compare to the period. Lemme see... Numeric Formula…

You can make an Entity search. Then use parentheses to build an OR expression (type is lead field = value) OR (type is partner field = value)

Hi neiuly, Last time I checked, the scenario you described could not be handle with a Saved Search Email. The reason being Alerts are not able to detect the "trigger" of x amount of time have passed. I mean, you can certainly make the search appear with exactly the correct results, beased on elapsed time, but it will…

I think this means: Only show lines where either the program, year or semester is textually equal to "CONTED2009Summer". The "MAX" on it'll only return a single line - i.e., you just want to know if anywhere at all in your result set a single line is true.

try adding a criteria text formula decode({tranid},{applyingtransaction.tranid},'true','false') and then filtering on "is true". Note that I'm not sure if {tranid} and {applyingtransaction.tranid} are exactly valid, but you get the idea. Edit: come to think of it, just removing Applying Transaction: Applied to Transaction…

Check out the Help under SuiteAnalytics (Dashboards, Searches, & Reports) : Search : Running Searches : Using Formulas in Search : Search Formula Examples and Tips. YTD vs LYTD is given as an example, hopefully it should get you started.

My pleasure

IIRC there is none. Shipping comes out as a line item. So you have to filter on the memo or the account to grab just the shipping.

Nope, sorry...

Hi Malin, I'd go with #3. I'll pretty much always want it to be on, because I often get calls from clients asking me to look at this search or that, and the searches are often private. So it'd save time to just global search them. But I can forsee times when having it off would be better, so the option to do so would be…

Go to Home->Set Preferences, on the General tab, on the right side under Defaults, tick in "Show Internal IDs"

{parent.custitem99}

Hi Marcus, You can try to add a Date Create filter, such as "date created is after 1 minute ago". That's a confusing piece of sentence, but basically you're saying to only show items that are less that 1 minute old. Item updates will not meet this criteria and thus will not appear on the search.

IIRC campaigns auto filter out duplicates. But you might want to test that real quick, I'm not 100% sure of that.

Right. Add the "Member Item" field to your search, and keep the "Item" field. You can also add the "Member Quantity" field. This will leave you with: MEMBER PARENT_KIT MEMBER_QTY_IN_KIT Note that adding other fields like Qty on Hand or Price or any other field will NOT pull info for members, just the Parent Kit Items.

If I understand correctly, what you want to do is add a column for 'item' along with your 'member item' column

Does nothing? Hmm, I just tested out and it worked fine. Placing the Member Item from the Item join should work fine. There is something stopping it from working... no idea what.

That is not possible. There is probably an enhancement request for more customization possbility for the Global Search though, it is a frequent request. Your best bet right now would probably be something like setting up a Saved Search in your dashboard with some footer filters for the fields you most frequently want to…

These is no standard means to achieve this: you will need to get a developer to build something custom for you.