I have a "super-tech" at NetSuite claiming this is possible. I've skeptically tried various scenarios using his guidance, but nothing seems to be working. His base suggestion is to import to invoice and have a BeforeSubmit script that sets the "createdfrom" field to the desired sales order. In my experience, "createdfrom"…

After seeing some of the nuances of these other solutions, I think I prefer one of of my own offerings. :D ...snip... If you want to multi-thread still or just have something more robust, insert a column that lists the total number of records on each row. This is kind of dirty because you'd have to run a script on each…

I like khultquist's idea. Another idea, perhaps a bit hacky, is to modify your files so that you have 1 column indicating a batch number (some type of ID) and another column that indicates a row as being the last. The script doesn't run until it gets a record with the "last row" flag, then it targets all records with the…

Related to this? - https://usergroup.netsuite.com/users/showthread.php?t=33064 Trying to solve our problem where lookups are essentially failing, so forgive me while I fish for something neither we or NS Support can find.

Corey, didn't I tell you about that case sensitivity deal with SF imports and Excel at SuiteWorld? It was that 80k records that I got lucky on by catching it. SF should have a long identifier that makes case-sensitive matching a non-issue. Can't invest the time in helping further... er at all, now. :)

I use Notepad++ which has the capability to change the character encoding. UTF-8 is usually a safe bet for encoding but you need to select it in the character encoding drop down when importing your CSV file in NetSuite. Notepad++ is also a good tool for searching and replacing text strings so if there are still characters…

Great suggestion! My initial tests in sandbox are promising. The only emails going out are notifications to the assigned rep: 1 - assignment notification and 1 - case update notification. Good thing, too, because my VP's initial response was to nix the whole project because we are a 24x7, worldwide operation and…

Thanks, Sheryl. Still, that it's an enhancement request is maddening. Half baked features are often worse than no feature at all. The support case import functionality is likely used 99% of the time for bringing in HISTORICAL cases, and I can't think of a reason why they'd want to notify customers on old cases. Why this…

I should have elaborated. Once SuiteBilling is provisioned to your account, you simply have new options available in the Enable Features page. I don't recall all of them (or if it's just one), but definitely Advanced Subscription Billing. As I recall, when you select that, you are forced to enable some of the other Billing…

It is. I did.

Strangely, minutes after I posted, I received a case/defect update that I'd forgotten. Short version: NS pukes on date formats other than MM/DD/YYYY. My users have had M/D/YYYY. The workaround they offered is to change the format. Worked, but with a lot of back-and-forth because they didn't want to call it a defect, they…

I vaguely recall this happened in our environment. It indeed seemed browser-related, as I recall. I had the user first try a different browser (worked) then switch back to the normal browswer, Shift-Refresh and it worked again without issue.

How random are the dates? Are they off by a day? Or many days to months or years? Your post triggered a recent memory for me wherein time zones were problematic. I don't recall specifics, but there were processes that failed because my time zone (Central) doesn't align with the base system time zone, which is apparently…

It kinda sounds like you already have the answer. Perhaps I got lost in your post, but I'm not clear why you and Support think it cannot be done or, rather, what the current design is that some aspect of it cannot be accomplished. One part I think you should consider is having a separate "Original Total" field that locks…

My opinion is that's not possible. Are you trying to prevent users from approving their own JEs?

There is a SuiteAnswers article that outlines how to prevent users approving their own JEs. I challenged them on this, saying that the Workflow they advertise doesn't seem to control bulk approval page. The response was strange, kinda "I see what you're saying. Have you tried what we said in that article?" The 2016.2…

I may have gotten a little lost in your description. What order are you choosing the values? I find if I have a list like... 1 2 3 4 5 it displays in the field in edit mode in that order. However, if I hold Ctrl and click specific options and save, they are in the order in which I chose them. Example: I click 3 then 1 and…

Try this: CASE WHEN ({systemnotes.newvalue} = 'Pending Credit') THEN WHEN (to_number (to_date(2/13/2012) – to_date({systemnotes.date}) )) > 45 THEN 1 ELSE 0 END I see what you did there. The parentheses in his was converting his date to number first and trying to subtract a date from that. That's why I was confused (though…

Not sure I understand the "THEN WHEN" part. Are you just trying to have two conditions? I think the proper syntax is the following. CASE WHEN ({systemnotes.newvalue} = 'Pending Credit') AND (to_number (to_date(2/13/2012)) – (to_date({systemnotes.date}) ))>45 THEN 1 ELSE 0 END Without testing, I'm also wondering about your…

Relevant - https://usergroup.netsuite.com/users/showthread.php?t=27431

Well, you're screwed.

No one has even clarifying questions/comments?

For reference, here's what it generates (more pretty in the actual email than copy-pasted here) Issue Number 13300Assigned To Product our productReviewer Product Team NONEType ProblemSeverity S5 - MinorPriority 4 - LowStatus Targeted for releaseTarget 2016.1 EP and release date:Fixed In 2013EP (2013.01.03EP)Link

I may not understand the entirety of the problem. My first thought is to create a field on an invoice that is the URL with two parameters for invoice internal id and customer internal id (2-factor authentication in case someone feels like messing with the parameters). Obviously, the URL will be a link to your online survey…

It wouldn't put it in the PDF. I read your first post as NOT wanting it in the PDF. I had more to write, but when I did a test just now, I realized which part you're talking about. They really did hamstring us there. I couldn't even get the Customer Message to be included in the email, and I'm low on time to mess around…

Looks like you could use a workflow pretty easily. Set your conditions for each action (ie which customer and which template) and you're good to go.

You can turn off the automatic notifications then use your own with scripting. You'd obviously need some way to identify groups that should get certain templates.

I'm not sure I see the connection between "attrition" and "require reporting module." Maybe I'm just having trouble visualizing the request. Perhaps formulas (simple, maybe complex) with smart use of Grouping in a saved search will satisfy. Maybe requires something heavier, like a 2+ saved searches and a Suitelet. Having…

Someone with business process sense is important. Very often, I get requests from my users to do something and I have to think about the request a bit and offer a different solution that 1.) satisfies them, 2.) can be relatively easily implemented, 3.) makes sense, and 4.) SCALES with company growth and process changes (ie…

Consider turning off the automated options and building your own. Lot easier than you think, and it will scale later on as you need it.