JCirocco, thank you, I wasn't aware of this new feature. I'm studying up on it now!

T.Watz this made me see that I do need an item search (not a transaction search), and after adding some transaction type criteria to my formula, this works perfectly, mystery solved. Thank you!!

Hi, thanks! I am using this formula for revenue (no date filter), but the problem is it will not show the item if there have been zero transactions within in this formula date. For instance, my criteria returns 74 items but when I apply this filter, only 69 of them show because 5 items had no sales activity within the…

T.Watz, thanks. Good formula, I can see now how to accomplish a wildcard with a field as such! However, this didn't work for me. I suspect it has something to do with the {custbody_vgw_so_del_days} field being a list? When I run this search this is an example of a result - this record should not show because 'Friday' is in…

starlingMark - I don't think I really had my words right, what I really want to do is automate the process of receiving the items and placing them in to bins on the item receipt. Our warehouse manager spends hours doing this several days a week. It would be easy to get the items from the TO and script or import the…

Thanks for the suggestion, MChammaTX! The situation is further complicated by the fact that the divisions in question cross state lines. All 'parent' divisions are states - so that doesn't work either. I would think this would be a common scenario, but maybe not?!

Departments. Of course.

Can anyone help me out here? Possible to assign employees to more than one division, or somehow release the division restriction on the role and grant them access to any customer where they are the sales rep?

The restriction they have is 'Division - own and subordinates only'. I don't see a way to specify specific divisions?

I'm new to the company and there is a terribly big nest of reports, searches, and custom scripts that are all set up to roll things up by a person, not a location, so this is just a quick fix until I can sort all that out. I just wanted to be sure there wasn't something fundamentally wrong with doing that (I am also new to…

I'm glad it's not just me! You are right - I will submit a ticket. I've spent a stupid amount of time on this thing that should take 5 seconds. Thanks for your time!

I submitted a ticket and the solution is exactly as carl.billings suggested. Setup, remove all, then add the balance kpi back in and add customized kpi's after that.

Hi Mark, Thanks for the response! Our customer dashboard has been customized, and balance was removed (though it should not have been). Setup => Standard KPI's simply doesn't give Balance as an option, that's why I'm so mystified.

Thank you for the clarity. I can say with 100% certainty that we have no users that subscribe to saved searches. I create the searches and add them to the recipients under the email tab and that's it. I'm not sure if this matters, but none of these searches are set to send alerts when records are created/updated, they are…

FYI, I received a message from support that the defect they created, 517767 (mentioned above) was actually a duplicate of defect 511135 (oh, the delightful irony) so my particular case is attached to defect 511135, which is what I assume others should use as well.

After going round and round with a support person, I finally had to ask her to confirm that the issue is not isolated to our account. She was surprised to find it was affecting others too and said they are now in the process of filing a defect. This cannot be fixed soon enough.

I don't think we had any duplicated searches on Mon or Tues of this week but a bunch of them were duplicated today. It does not happen to the same reports every day or all the time. I noticed this morning that some of these duplications date back to at LEAST 09/03, I was unaware it had been an issue for so long, and that…

That was exactly it, thank you Mark! Seems so obvious now - of course everything seems obvious after you get the answer. :) Cheers!

Today I checked back in with the support person, to see if any progress was being made on the defect she said they were filing. Her 'solution' today was that I should go to my preferences, and change the email address for alerts., since my email is listed there and as a recipient in some of the searches. What do email…

Well - that's concerning, to say the least. These duplicated reports are all that I know of. I'm a solo admin and often people don't tell me when something isn't right. I will post here if any resolution comes from my support ticket (doubtful, if this is a system wide issue with the upgrade).

Hi, starlingMark! Thank you, you've been very helpful to me! I did try a case statement with this and it still doesn't work, but maybe I don't have the statement right. This statement returns the same result as the Decode statement. Case When {inventorylocation} = 'Indiana' then {locationquantityonorder} else 0 end Is this…

That did the trick, thank you again!

This continues to be an issue. Now the saved searches are sending 6 minutes apart, not 5. I am working with someone via support ticket, but I know this is not an issue affecting just us, one suggestion is to make a copy of one of the searches to see if the problem persists - but then what, the solution is to make copies of…

I really hope this is a priority for NS. The amount of email piling up in people's inboxes due to duplicate reports is absurd and embarrassing.

Thank you! The sales for last week are picking up perfectly, but the sales for this week are only picking up sales from today, not yesterday (there aren't any on Monday). Here's my line (which is the same as above?): CASE WHEN ({trandate} >= TRUNC({today}, 'W') and {trandate} <= NEXT_DAY({today}, 'SATURDAY')) THEN {amount}…

Normally I just use the built in NS debugger and Notepad++, but I'm having a hard time figuring out how to debug a Suitelet with that (I'm a noob with Suitelets), so I turned to Eclipse. I submitted a ticket but I don't think it will be of much help unless they discover I've done something wrong (which is entirely…

I followed this post and started from scratch with a custom SDF developer role that does not require 2FA - but Eclipse was still giving me an error about that when I tried to upload files. So I changed the authentication for the role in Eclipse to token based, I was then able to upload the files but now when I try to debug…

It says the snapshot date is today, 02/13. The import happened last Friday. Does it seem that snapshot date is incorrect, then? Thank you!

The emails don't say 'Beta'. Just 'SANDBOX'. I found that setting and checked it - but this seems unusual, this didn't happen the last time I refreshed our Sandbox. They are scheduled reports, and the emails are going to all original intended recipients. Not good!

Well, cutoff time for us is 5:30 - we are officially DOA. What a disaster. Here's to coming to work at 6am tomorrow to process everything from today - provided NS is up and running by then!