Need to add more context to your question. When you say "increased", what are you trying to compare? Are you looking for a PO from a specific customer, an item, on a monthly basis?

Unexpected error is a generic error thrown by NetSuite and can be caused by different factors like scripts, formulas on custom fields, workflows, etc. Have you tried reporting this to Support?

I never tried converting a list to a custom record but what I'd do in your case is I'd try testing this in Sandbox first. A tip is to export a list of the records that contain the value of that line item field before the change and extract it again after the change. By then you'd be able to compare if the values are still…

Just hit on Subscribe. Excellent job as always Eric!

Hi benktesh, thank you for documenting your map/reduce experience and sharing your blog. Map/reduce is such a powerful script and your article will help promote a deeper understanding around it. As you may have already noticed, there is a scarcity of documentation in NetSuite. If we continue sharing our learnings online, I…

That could be achieved by using Freemarker. I wrote an article that might help get you started: https://leacc.cloud/2018/08/27/netsuites-scriptable-email-template-with-freemarker-for-dummies/ For invoice line items, you will need something like: <#list transaction.apply as sublistItem> ${sublistItem.refnum} </#list>

Scripting can help automate this.

JohnCCole honestly I do not think that writing a script is worth the effort for such a simple use case. You may consider creating a saved search based on the "Saved Search" record. I use this trick to get all the searches I created in the system. Yours will be a bit trickier because you have to come up with a common…

Can you share the filters and columns that you used in your search?

Up up! This is exactly what we are looking for as well. I am hoping for a solution that will not require scripting.

There's no straightforward way through point and click customization that could restrict roles from accessing or modifying fields from a certain subtab. You would need custom scripting for it.

Why not create a custom column field that would link to a custom record called "Customer List"? This gives you more flexibility as you could introduce other fields in the future on that custom record. leacc.cloud

Our form is almost similar to the standard NetSuite form, perhaps only five custom fields added. Our customer process is not that complicated so the NS basic design already supports what we needed. I guess you'd have to work on performing a health check on your customer forms. Allow me to ask these questions: Why did it…

I'm not sure if there is a way to add a column field via click and drag customization but if you're familiar with SuiteScript, you may give it a shot by writing a user event script on before load and use addField method or something like that.

Have you tried going to that problematic role and clicking on the "List" beside that field? What are the visible transactions there?

Can you provide the configuration on your custom record and roles? Are you sure that the Custom Records permission is added to that custom role? In any case, this article might help. https://system.na3.netsuite.com/app/..._n2879388.html leacc.cloud

You still need to use getValue or getText method for each search result. Example: results[i].getValue('entity'); Then save these to an object. For a sample, you may see SuiteAnswers # 34488.

You may try: if (error instanceof nlobjError) error.getStackTrace()

Your syntax looks correct but not sure about the values. Where are you getting the value of internalID variable? What is its difference between the tranid variable? Where is the email record getting saved?

Hi qpongrass, external suitelets' URL are different from that of internal suitelet. (e.g. 'forms.netsuite.com' as opposed to 'system.<dc>.netsuite.com'). Double check how you're processing the URL and adjust your code accordingly. You may utilize the nlapiResolveUrl API that returns the appropriate external URL. Just set…

As far as checking the Support Preferences, there is no way to suppress a standard email notification for case updates by context. It will trigger for all. You may further checking with Support if there is hidden preference somewhere they know of. I don't know what your scheduled script does, why it has to update the case…

Do you really need this to be a formula? You can try: Filters: Type is <Transaction Type> Main Line is False Shipping Line is False Tax Line is False Columns: Document Number, Summary Type = Group Amount, Summary Type = Maximum

If the employee record has transactions associated with it, you can no longer update the subsidiary field. There's no other way but to delete the transactions for that employee. Lea Celosa Columna Independent NetSuite Technical Consultant leacc.cloud https://www.linkedin.com/in/leacc/

Hi yokkotorro, try using the Login Audit Trail to show the Details of the error and see if it helps. https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1521211724.html

Hi suitecloudfanatic, thanks for your response. I actually figured this out just now. You're on the right track that it has to do with the Account. I knew that the SB account IDs had changed, but I didn't put 2 and 2 together that it would affect the IDE. Evidently, neither did anyone else. If you had your IDE configured…

Hi bcpvps, I am interested to know more about this. I do not have a Sandbox account in the new architecture but perhaps we can try some troubleshooting steps? In the SuiteCloud IDE, when you go to NetSuite menu > Manage Accounts > New > Production > Enter your Sandbox credentials, do you see the option to add your Sandbox…

cusenj10 since you are using a custom approval workflow, there are numerous possibilities here. To make it simple, the answer is it really depends on how the workflow is set up. There could be an action in the workflow that either 1) removes the approver when the amount is changed or 2) sources the approver from a field…

Hi edc, I remember writing an article before that details the step-by-step process of implementing SAML SSO using Microsoft ADFS. That's the guide I have used a number of times in implementing SAML SSO for customers when I was still in NetSuite and had 100% success. However, I couldn't find it anymore in SuiteAnswers. You…

It's worth checking the U-level of the defect to know if they're going to fix it anytime soon. If you're the only one in that defect most likely the defect is categorized on the lower side of the urgency spectrum. Have you also asked NetSuite Support what caused the slowness? Is it happening on the NetSuite server,…

It does sound like a rampant issue. Have you tried escalating the issue? I experienced this in one of my clients as well. NetSuite Support tagged the issue as U4 where it will be resolved in 1-4 weeks. I responded to them saying that this is an urgent issue with details explaining "WHY". They raised the urgency and it got…