That's perfect @Sakshi_Garg! Thank you!

Any best practice advice on naming External IDs? Our import teams basically come up with their own rules for what to make it during import. The hardest are invoices, because we may not have an idea what INV# NetSuite will assign to that invoice at import, so making the external ID correspond to an assumed inv# doesn't feel…

Love this! Something I can copy/paste & send out to my users. Super helpful! Thank you!🤩

Very timely example! Thanks for posting! Me and my team were just discussing doing something similar to this, but for opportunities. Since our opps are partially connected to commissions, we don't want people changing an opportunity after close. May try giving this solution a try, but instead for opps that have been closed…

Thank you for the confirmation @markbell10 ! I did see someone mention about doing it via a script through my vigorous google searches lol. I'll see if my developer can come up with something. If not I'll throw it on over to ACS to do. Thank you!

This article actually helped me with an even simpler request; Knowing what a field's dependencies are (before trying to deactivate it to see that dependency screen pop up 😅). Never knew this was a thing! This is super helpful! Thanks! On the Transaction Body Field page, hover onto the Action field and select either Check…

Merging is one of my favorite NetSuite features. I do enjoy being able to select what fields are important for me to review to see if they really are a dupe, or if they should remain separate. A simple but very helpful tool and less clunky than others I've used.

@MTL_MIA not that i have seen. If it did, my numbers would definitely be skewed, so I'd def notice haha. If you want to generate that type of view, a saved search would probably work better for you so that you can include estimate revenue. That out-of-the-box pipeline saved report just seems to do opps, even though that…

@MTL_MIA - correct, pipeline is only opportunities. I personally wouldn't forecast on Estimates/Quotes as they are just a counterpart of an opp. 1 opportunity can have many estimates, so that's why I dont think it's good to forecast off of. How we handle it is, Estimate/Quotes are there to allow the rep to provide…

@User_RLV0D - OOoooo NICE FIND! We DO use HubSpot! A+ to the support rep you received! Be sure to leave them a good review because they may have helped us out too! Thanks for the update!

Yep. This is happening to us. After the record loads, try double clicking on the NetSuite Logo at the top left of your screen. That popup can help identify where the issue may be coming from, whether the server, scripts, workflows, etc. For ours, it confirmed that the server was the culprit, so we submitted a support…

@User_52G6L are you running an item saved search? This is the full text I'm using that works best for me: case when {parent} is NOT NULL then SUBSTR( {name}, INSTR( {name}, ': ', 1) + 2) else '' end

I noticed that sometimes our accounts don't get an External ID auto-assigned to them. I've never really researched it or looked into it, just noticed that it happens sometimes. Is there any rhyme or reason why one account will get it automatically and another may not? Does it only happen on accounts that have billable…

What a cool idea! I'm a visual person, so I enjoy the idea of having a color coded option. I'm mad I didn't think of it haha. I'll definitely be saving this one!

Yea - we just went through the same thing recently. Some trainings that were previously available are now behind the company pass offering. We had to upgrade from a "single admin pass" to a company pass.

I personally love the in-line editing feature. I love using it for bulk editing via saved searches. I actually didn't know that the 'Show in List' option on custom fields is what turns that on. They should definitely mention that on the little help pop-up, because I had no idea all these years hahaha. I always just…

This is definitely one of those… why haven't I noticed this before moments. 😅 Thank you for this! Creating a saved search alone for this definitely saves me time from clicking that little "history" button on each line of the transaction.🤩

Nice! This was actually quite helpful. Never thought to generate a report to see how many opportunities don't have an Estimate/Quote generated for them. Tried it and it worked. Thanks!

I did something similar, but I didn't go the workflow route. I just did a saved search based off of the system notes of the Project Total field. We're only worry about changes after the transaction is approved, so it'll send me an email alert if the amount changes after an opp is already closed for example. Criteria…

Strange. I tried it in my sandbox & it worked ok for me. I marked the employee as inactive. Went back to transaction & they were no longer available to select as an option from the Sales Team dropdown box. Correct, you won't be able to delete them since they're tied to records, but deactivating should definitely have…

I would also caution to be careful with deactivating the employee record. We noticed that a basic payroll import wouldn't assign payroll records to the deactivated employee, so we usually set their Termination date immediately, but mark them as inactive only when their last payroll has been imported.

I use the Sales Rep field. Group by that one as the main rep. For Sales Team Member, I choose Minimum. That seems to work for me if there are multiple people on one transaction.

Hi Jareb! You can do that a few ways. 1: If you add "main line = true" to your criteria tab, that would show you 1 line for each transaction, but it would only show you header information, no line items. 2: To see one line for each item, you'd do "main line = false" in your criteria. That should get you 2 lines 3: We don't…

You could start with some audit saved searches. 1) If an Estimate is created w/o being attached to an Opportunity (opportunity field = blank), send an email alert out to the person who created the Estimate that an opp needs to be created. 2) When an Opp is created for an account that is tagged with a Lead Source & the opp…

I hope I understood your question! I believe for what you described we use campaign codes to keep track of that information. When we have a new campaign/ABM project, we create a new descriptive campaign code. Then when the rep gets interest, we create a $1 opportunity as a placeholder until they fully flush out the deal.…

I would say, enter Company XYZ as a Lead Account in NetSuite. Then, create 1 opportunity for them to buy product#1. That would turn their Account into a Prospect. Then, create opportunity#2 for them to buy product#2. That way, both initiatives/products could be tracked separately. Once they decide to buy opp#1, you'd…

Hi @Michelle Jabanes-Oracle ! Figured it out. I had a GLOBAL permission on my employee record set as VENDOR Create. So that was overriding the VENDOR Full permission that was on my Full Access role. ^_^ I'm all fixed now.

Thanks @Michelle Jabanes-Oracle !!

Apologies @Michelle Jabanes-Oracle ! I truly do appreciate your help. I thought this would be just a quick fix or quick idea, but the back & forth on this one may be ore than I'm willing to commit to since this is just a nice to have ^_^. I'm going to go ahead & open up a support ticket so I can do a screenshare &…

thanks @Emil T. - trying it on my personal device doesn't allow editing either.