pcutler Newbie

Where in the vendor center is your URL used? If its used in a location where you have control of the HTML, you can set the target attribute of the HTML anchor element. For example: <a href="https://google.com" target="_self">Click Here</a> or <a href="https://google.com" target="_top">Click Here</a>

I haven't run into this issue, but have you tried revoking access and immediately reinstating access with a new password?

I've run into this problem before too, and I don't have any great answers. It sounds like you're looking to implement a custom submit button. I tried using nlobjForm.addSubmitButton in the before load user event, and that just introduced JavaScript errors to the web page. So, instead, how about re-purposing one of…

You're on the right track - as you noted, the client script on your online custom record form will lack the necessary permissions to access most data in your NetSuite account. This is a good thing :-) That said, you can write a Restlet to run your search and create a custom role with the specific permissions that the…

I haven't seen this error before, but I have some suggestions about how you might tackle it. First, identify a process that consistently reproduces the error in sandbox. Then, check the scripted records page to see if any scripts are deployed to employee records and whether one of them is causing the error by undeploying…

I'm aware of the Sandbox email restriction. I was testing this in a developer account, which to my understanding, should work like a production account? I guess the question is: Can I send an email from an external Suitelet with Suitescript 2.0? The email "To" is pulling an employee email address, if that matters.…

This feature has been available upon request since 2017.2, you just had to file a support case requesting that the multi-subsidiary customer feature be enabled.

Are the emails HTML or text? If they're HTML, your problem could be something like <a href="wrong url">right url</a>

Off-topic, but just a heads up - instead of nested CONCAT statements consider using the double pipe operator. For instance, the following concatenates to 'abcdef': 'abc' || 'def'

Have you considered using customer dashboards? They start out with an activities portlet and you can add a search portlet with the customer's messages right next to it. Or a developer could write a script to combine the sublists exactly as you requested.

Got it, that would require a script, not a workflow.

The workflow solution worked for me: 1. Create workflow that runs on create for all item types and set the trigger type to BEFORE LOAD 2. Add a Set Field Value action to the state, setting the Location field to the desired location. While workflow does the job, if you have trouble with the workflow scripting is also an…

As khultquist said, you can't filter the item list by selected vendor without customization. However, you can filter the item list by custom form with a saved search if that helps out in your use case - just create an item saved search and select that saved search in the ITEM FILTER field on the Screen Fields > Columns tab…

On the criteria section, there are two tabs. You want to look at the summary tab. There you can set up criteria for the MAX expiration date being before today. To use the summary criteria, you need to use grouping in the results. I assume you want to group by customer for this purpose.

Have you reviewed SuiteAnswer 8431, permissions for searches: https://netsuite.custhelp.com/app/answers/detail/a_id/8431

Sounds like you want to create a saved search with summary criteria. The summary criteria would be that the count of internal ID is less than 100. On the results tab, group by the columns you want. Then on the email tab, specify that emails should only be sent when there are results.

Depends on exactly how your data is structured, but this is likely doable using the sourcing & filtering tab of the vendor custom field. If your data model doesn't support that, it's also possible to dynamically create a drop-down with the desired vendor options via script.

My guess is that your issue is probably in the summarization column on the results tab. If you can't figure it out, try posting screenshots of both the critieria and results tabs.

eleran Thanks for the suggestion. It significantly reduced my results but I still get the customers having sales orders amount greater than 0. This search would give you all customers having $0 sales orders, who may also have non-zero sales orders. To search for customers with only $0 sales orders, you will have to use…

Did you try adding criteria for MAIN LINE = YES?

If you are searching for a list of document numbers, create a forumla numeric search filter, use the following formula, and select equal to 0. The Oracle INSTR function returns 0 when the criteria does not appear in the block of text. INSTR('PUT LIST OF DOCUMENT NUMBERS HERE', {transactionnumber}) For example:…

On the criteria tab and standard subtab, add a filter for mainline=false. Optionally, add filters such as taxline=false, etc. to exclude other line types that you might not be interested in. On the criteria tab and the summary subtab, add a filter where the COUNT of Line ID is the desired number.

Glad you figured it out! If you want to consolidate into a single saved search, you can check the USE EXPRESSIONS checkbox and use the OR operator. You still have to break your list up into parts that fit in NetSuite's character limitation, but you can use a single saved search if you'd like.

This didn't work by the way. Ug. I wish NS just had a field called "Count of Lines" that worked and only counted the number of line items on any transaction record. While the grouped search did work, another option would be to create a custom field called "Count of Lines" and set it with a script.

If you are using recipients from the results, try adding yourself as a specific recipient so you can see if the issue is with the search result data.

I'm not aware of a way to accomplish this as a single saved search. But you do have some options: 1. Have two separate columns for amount (max) and applying transaction amount (sum). Then export and do the subtraction in Excel. 2. Have a developer create a Suitelet script that does the subtraction and presents the results…

Are the discount fields numeric fields or are they links to discount items? If they're links to discount items, then just add the following four results columns: Customer ID> summary type = GROUPED Customer Name > summary type = GROUPED Discount Fields...Internal ID > summary type = GROUPED Discount Fields...Base Price >…

You can create a saved search of transactions. In the result columns: 1. Group by location 2. Max the created date column Create another saved search for departments and classes.

By the way, the two other options not mentioned yet are: 1. Suitescript 2. SuiteConnect and writing the query via SQL

are you looking for CASE WHEN {shipaddress1} LIKE 'Attn:%' THEN...