srussell Red Ribbon

It's been a while but I recall having a similar issue. The problem was that one of the customers in my results also had a Partner relationship, so the category join was duplicating their results. Check for something like that.

Hi Erick, Tenfold is one of the others that we looked at. My customer support manager had a call with them and ruled it out. I don't recall exactly what they were missing. Hoping for some other suggestions from the community. Thanks

Further on this, is there any linkage between the Charge record and the rev rec Journal that's tied to the Revenue Recognition Plan line in ARM?

Is there any functional difference between the two or is it just a different label on the button?

Gotcha, thanks.

Thanks for the responses. I had a feeling it would require scripting. I tried to use Workflow to set the custom form field but it didn't work. Fortunately, this is merely one of those nice-to-have things - not worth the scripting effort. k_dunc, it sounds you were solving for a more complex issue than what I was looking…

Wow, I just noticed that the OP is two years old. There really ought to be a simpler way to do it by now.

I had the same problem. There might be a more elegant solution, but here's how I solved it: First, I'm assuming that the contact you want to select is somewhere within the customer hierarchy. If not on the transaction customer, then on a parent, child, or sibling entity. -Create a contact field to source the ID of the top…

I'm new as the Admin, but I'm not a developer. Is there a simple way to discover which fields are used in scripts? This would include Roles. There's a role that was created with a simple misspelling that I'd like to fix.

pcutler I'm trying to set or update externalid using SuiteScript 2.0. I'm creating a unique string from fields in the record and setting that to newExternalId. The first line below works fine, it sets the desired string into a notes field, but the second line that should set it into the externalid does not.…

I did, thanks. This is critical defect for users who import leads. I wish it had been noted in SuiteAnswers Answer Id: 31849 https://netsuite.custhelp.com/app/answers/detail/a_id/31849/kw/prevent%20duplicate. Even if it's not called out as a defect in there, it would've been helpful to have known that dupes are only…

Try LAST_DAY({hiredate}+60)+1

Would it be required to specify the types of transactions to be extracted or should the technology simply be able to access transactions as a whole?

All technologies allow a broad "transaction" type search without needing to specify the exact transaction type. Does this require SuiteAnalytics Connect?

The answer back from our in-house database team is, "With our customer install of NS, we do not have the transaction table." Is this even possible?

Is there a way to suppress that behavior on specific searches?

I started adding summary type Group to the results. It looks like I'll need to add a summary type to every field that I want in the output. Is this correct or is there a simpler/better way? There are over 50 fields on the report. Thanks.

That worked. Thank you.

Does anyone have an update on this issue? I have a search that sends emails when the sales rep field is changed. It sends two emails every time. I've even seen cases in troubleshooting where 3 emails get sent.

Fantastic. I'm glad I was able to find this.

NetSuite is working it as an S1 defect, Defect #- 332189. They recommend that users temporarily uninstall it or disable the add-in through Outlook options. Contact support to add yourself to the defect for notification when it's fixed.

That worked. Thanks.

I'm having the same issue. I create a search, check the right options and don't receive any emails. When someone else copies my search and sets the same options, I do get the emails. I have Full Access, the other user is an Administrator. I don't think that should matter, as my Full Access role should be enabled for this…

I wouldn't expect marking them inactive to cause searches to disappear either. I have public searches owned by inactive employees that are still accessible.

Thanks. I created a workflow that sets the field to Inline for Roles <> Accounting. What is best practice for where to set the condition? I have the condition set at the top level in Event Definition. Intuitively, this seems right, but is there a reason to drop the Condition lower down into the Workflow State? Also, I'd…

Thank you.

This may not quite be best practice either, I do an advanced search for the record type and internal ID. Our implementation has custom record types where the ID and Internal ID are the same. ID is visible in global search. It's quite simple and useful.

Old thread. No enhancement. Does anyone have a solid workaround?

Makes sense. Thanks.

After. For some reason I couldn't get the scripted externalid to save on a before submit trigger.