Nevermind - it won’t let me set it as a summary criteria either.

huh, that's strange

It allows me to choose it as a summary criteria, but when I run the search it gives an error. For the results summary the field is greyed out and can’t even be selected.

which field?

i just mocked it up

messages : message

They want the actual message in the results.

@jokell try adding {messages.message} to a formula (text)?

I feel like an idiot. Of course that works. Thank you!

ah, there we go

nice

Not sure if this is the best channel, but looking to create a saved search to show actual GP per transaction. Looks like we can only report on estimated GP or overall GP by customer.

I assume best option would be a search on sales order transactions with costs from linked fulfilments/po’s, but my testing hasnt quite worked.

I would have thought this would be a standard requirement.

anyone know a date formula for 'last week'? I have an item search where I am wanting to show transactions from the previous week.

I think you can just select the date filter and it has a pre-set

@Amanda Flynn what if you scroll down to where you choose the join fields, find transaction fields, and choose date from that list? that should allow you to choose "last week"

@Vtor, thanks - I will play around with that more, but the problem I run in to is if the item has no transactions it won't show up, which is why I'm writing the formula to say 'if trandate is this and trantype is this then amount else 0' - it will still show all items just zero for ones that have no sales. I've used this approach a few times, just never for prior week and for some reason i just can't find the right thing. But I might be making it too hard, I do that sometimes...

found that date formula i was looking for: CASE WHEN ({transaction.trandate} >= TRUNC({today} - 7 ,'IW') and {transaction.trandate} <= NEXT_DAY({today} - 7 ,'SUNDAY'))

Looking for someone with experience using the VIP Supplier Reporting System, and/or creating SRS files in NetSuite? One of our suppliers is requesting that we participate, and they sent me a 74 page document on file specs - but I don't know how to create SRS files or even what the process is of delivering said files.

A question on best practice for calculating Inventory Turns and GMROI (per Item, not class/location/account). - For both of these metrics, it's necessary to calculate the average inventory on hand over a period ( stocking units or $). I cannot find a record or ODBC view that will show me units on hand by date. Is that not something that Netsuite stores?

Anyone have an idea why users would get an "ERROR: field is restricted" message on saved search columns when the search has the "run unrestricted" checkbox checked

What would by the syntax of a Formula(text) to return the internal ID of an employee's supervisor?

@tim.nestlerode employee.supervisor?

Yes, how can I get that supervisor's internal ID returned in an employee saved search. Thanks

ah it just pulls up the name

lemme check

{supervisor.id}

I'll try is out. Thanks