3949798

You can, though, simulate a child record setup on the competitor form with the help of scripting. 1. Create the custom field as you would on the custom record based on Competitor Record. 2. Create an user event on the competitor record. On BeforeLoad event, search the custom records where the custom_field_value ==…

in Competitor as Parent Comment by 3949798 Apr 22, 2016 4:57AM

To add on to that, instead of resorting to onClick JS, target=_blank on <a> should open the link in a new window without too much fuss.

in Adding Fulfill button/URL to search results Comment by 3949798 Jun 11, 2014 7:29AM

You could have a setup of search + mass update on items. 1. Saved Search: Type -> Transaction Filters : Main Line is False AND Account Type is Other Current Asset AND [ Quantity > 0 OR Transaction Serial/Lot Number Quantity > 0 ] Columns: Column 1: Formula (Numeric), Group by "Maximum", Formula: MAX(CASE WHEN…

in Custom Price List updated with Currency fluctuations Comment by 3949798 Jul 7, 2015 11:21AM

To piggy back on the previous comment, if not using nlapiYieldScript [LIST=1] [*]Create a checkbox field "IS PROCESSED" on the record type, store value and default value unchecked. [*]In the scheduled script criteria, include the IS_PROCESSED field as filter, with value as "F" or unchecked. [*]After processing done for…

in Scheduled script woes Comment by 3949798 Jun 17, 2015 9:11AM

Georg, target="_blank" attribute on <a> will open a new window.

in Open Popup from link (not from button) Comment by 3949798 Jul 7, 2014 12:30PM

Found it (weird how it always happens after asking a question). OthCurrAsset is the value.

in Filter expression for Account Type? Comment by 3949798 Jun 26, 2014 2:39AM

2) Generate an array of customers based on a Search for all customers that are past 60 days due. 3) Loop - For each customer, run a search to acquire their open invoices (#, PO, amount, etc.) Or, you don't loop for every customer, and just search for all customers in one go. By your current logic, if you have 100 customers…

in Need Help with script Governance work around Comment by 3949798 Feb 12, 2014 2:30PM

Might be silly but does "is" work instead of "contains"? Wondering if the data type of the field is set properly. Just tried on data type "Free Form Text" and it works properly at my end. var f=[]; f[0] = new nlobjSearchFilter('custitem_xxx',null,'contains','mesh'); var searchItem = nlapiSearchRecord('item',null,f);…

in Simple Search Failing Invalid Search Filter Comment by 3949798 Jan 14, 2014 9:08PM

If you are going to be logged in into NS during your operation, RESTlets aren't required. I needed a similar thing, and this is how I implemented it. Loaded required initial data using NS api, created a form, put an inline html field and set up initial parameters using hidden fields. Created backend suitelets (i like to…

in Single Page Apps Comment by 3949798 Aug 10, 2013 11:35AM

So, Opportunity -> Quote, status on opportunity to "Proposed" Quote -> Sales Order, status on opportunity to "Closed" ? Does chaining of subscription works? That is, if quote is created and subscribed by Opportunity and if, Sales order is created and subscribed by Quote, then probably have a custom workflow field, or…

in Better Approach to Customization... Comment by 3949798 Jul 17, 2013 5:44PM

Aaron, I use a similar suitelet that I made to be available without login. And I pass custom parameters too and it works. For now, I created a test script to pass a custom parameter and it works too. I am assuming that you have made available the script to all employees and roles (by clicking select all) in the audience…

in how do i embed a link behind text in JS? Comment by 3949798 Aug 3, 2013 11:47AM

If you do that, you will be able to do .... var customer_id = request.getParameter('custparam_customerId'); ... in the suitelet. And yes, you can pass multiple parameters like that.

in Invoke a suitelet from a button in the Customer Form? Comment by 3949798 Jul 7, 2015 11:33AM

Without hardcoding the authorization headers in the suitelet, is it possible to call the restlet ?(which is at rest....i.e. internal request)

in RESTlet how do I pass and read header information? Comment by 3949798 Feb 6, 2012 8:12AM

Ialan, It is the same problem I was trying to figure out about a couple of days back. But I figured an alternate way for my problem, may be that is irrelevant for this post. I can show what I did, and that may prove useful to you. Inside after submit user event function var newId = nlapiGetRecordId(); -- to get the…

in How to redirect to a Suitelet with parameters from a Checkout page/User event Script? Comment by 3949798 Oct 6, 2009 10:51PM

"COOKIE" changed to "Cookie"? NS Started throwing error with COOKIE. Cookie did the trick.

in Call a Suitelet from another Suitelet Comment by 3949798 Jul 9, 2013 8:31AM

This is my use case. There is a certain record which has 1+ child records, each in different subtabs. This parent record has a field called "locked." If this field is checked, only those who are in a specific group "entitygroup" can edit/delete the record and child records. Others are prevented from any edits. All worked…

in Any way to hide the 'attach' and 'remove' from parent-child lists? Comment by 3949798 Jan 14, 2014 3:44PM

A small update, Seems like the search on unique id needs to be done without the prefix, and parsed into integer. (searched on 'name') Amazing what sleep does to the mind!

in nlobjSearchFilter join and custom records Comment by 3949798 Jan 8, 2010 1:12AM

Still Unable to crack this code!! This is my scenario parent record:custrecord_parent parent record unique id: uniq_id child record:custrecord_child child record field referencing parent record: custrecord_link_parent Thus, there is a one-many relationship between uniq_id and custrecord_link_parent. Now, for a given…

in nlobjSearchFilter join and custom records Comment by 3949798 Jan 7, 2010 3:01PM

Thanks for the Tip, the transaction was using base price as rate for some reason. Any field on item that does a default to "base price." I am asking because some items don't have the column greyed out (not base price by default)

in Why would "Rate" column on an item line be disabled or greyed out? Comment by 3949798 Jun 19, 2015 8:37AM

With regard to viewing a file (View API), if I use cURL, I am able to get the location URL of the file that's on Box. However, when I try to pass the same parameters to nlapiRequestURL, I am getting the actual file and not the location. Is this a known issue and is there anyway around it? Any help is greatly appreciated.

in Box.com Comment by 3949798 Oct 10, 2013 9:53AM

Had a similar use case. Didn't work out with NS bundled graphs. Ended up using a free 3rd party js library on a custom HTML portlet. I'd also be interested to know if the aforementioned feature is supported natively.

in Multiple Lines on Trend Graph Comment by 3949798 Jul 9, 2013 7:08PM

Would putting the search URL in an iframe work for you?

in Embed Global Search Results in Information Item Comment by 3949798 Jun 17, 2015 9:00AM

Is it a client script? You can try ... var now = new Date();//date object var nowFormatted = nlapiDateToString(now);// String formatted as per user/company preferences based on context ... If the field is a date field, you can directly do nlapiSetFieldValue('date_field',now);

in Client Workflow Date/Time Comment by 3949798 Sep 3, 2014 5:04AM

A few things you can check in addition. See whether "custrecord_wip_team_15" field has any validation or sourcing constraints (search etc). Also, try setting an empty array first (no selection), and if it works, an array with one hardcoded value and then check with 2+ hardcoded values. If you have an associated client…

in nlapiSetFieldValues - Unknown Error Comment by 3949798 Apr 7, 2014 3:34AM

in Margin Field Comment by 3949798 Mar 18, 2014 1:53AM

Same here, had to resort to a custom record. Would appreciate if anyone knows a way to do this without a custom record.

in Forecast (budget) to Actual Trend? Comment by 3949798 Mar 18, 2014 1:25AM

Hi Everyone, Good day. I have a custom "Print Voucher" button in the "Bill Payments" module on Netsuite. I would like to show a pop-up screen when the "print voucher" button is pressed. The pop-up screen will ask the user if he / she would like to proceed with printing the Voucher. How can I do this in NS? Any help will be…

in confirmation pop-up in suitescripts Comment by 3949798 Mar 18, 2014 1:23AM

Any help with nlapirequesturl?

in Download file from FTP location Comment by 3949798 Mar 18, 2014 7:03AM

lauram, Just tried what you posted, it's working for me. Replace 'unitprice' with 'rate'. unitprice is item field whereas rate is transaction column field. 1. created a custom transaction column (type free form text) 2. Validation and Default tab: Checked formula & set default value to (({rate} - {averagecost})/{rate})*100…

in Margin Field Comment by 3949798 Mar 18, 2014 1:47AM

Have you tried saved search, it would be easy to pull that way. Lists -> Searches -> Saved Search -> New -> Project Task And in "Results->Columns", choose "Project Task Assignment Fields.." and then look for "Resource Name" field. Save and run the search, and check whether the results are coming as per your expectations.…

in nlapiSearchRecord Project tasks resource/assignee sublist Comment by 3949798 Feb 28, 2014 9:16AM

3949798 Green Ribbon

Comments