lynale Red Ribbon

How do I apply this exp on a Custom column field for Inventory Location at item's level? I can't seem to find the right internalid for the field. On the form, I have "WH Location" colulmn displaying "Greater Location : Location 1 : Warehouse 1". On the PDF printout, I would like to display "Warehouse 1" only. WHEN using…

Thanks for your replies. I am still researching and will find out what route we will go with.

Update: it is not incrementing in Edit mode. Once saved, and in View mode, it is incremented. It's working now. I have to disable the Line# field. On PO, I tried with {linenumber} as {line} does not work. And it does not increment on 2nd or next line, it is always 1.

On PO, I tried with {linenumber} as {line} does not work. And it does not increment on 2nd or next line, it is always 1.

How do I apply this push() function to push the summary value from its column on a Saved search on to a custom field of customer record? e.g. var sum_value=0; // initialize value of custom field sum_value.push(searchResult.getValue(columns[3])); nlapiSetFieldValue... To do this that is exactly what we had used. (Thank you…

How do I do this? Can you give me some steps... Load a custom CSS stylesheet in your browser preferences (if you can), and use the following CSS style; #devpgloadtime { display: none; } Not fully tested this on all pages, etc - but seems to work OK. Mark.

I am trying to do the same, adding Internal ID on customer form. I am not sure on this part: Is it {id} or {entityid} or {customer} ? And this is what I should have for the formula? What type should I use for this custom entity field, integer or Free-Form Text? Thanks all. Evan, as always - Thank You.

Should this custom entity field be of Integer or Free-Form Text type? The formula I had for Default Value is {id}. And it does not seem to display the internal id of the customer record. Am I having the field set up correctly? Is it {id} or {internalid}? Thanks.

I got it working. Thanks, Mr Goldberg. With the Global Search box is greyed out, how do I get this ID search-able or available for (Global) Search?

I have a scheduled script that executes a saved search of invoice count per customer, and then for each customerid loops through its open invoices utilizing a scripted saved search. There are always over 100 customers for every run, multiplied by their # of open invoices. The scheduled script stops every now and then,…

Thanks Ivan. nlapiYieldScript helps with my nested 'for' loops. Try nlapiYieldScript BEFORE your run out of governance.

With the same idea for searching invoice, How do I add another filter for account type = Account Receivable? Tried different ways, with single quote or double quote or AccountReceivable, I got the error "An nlobjSearchFilter contains invalid search criteria: accttype." filters[2] = new nlobjSearchFilter('accttype', null,…

Ahhh... var filters = x.getFilterExpression(); is My survival tool. This will save me my time of manually figuring out each filter object in the console. Now, Thanks for the great tip and the 3-line snippet. Hi guys, The idea is to 1st create the search in Netsuite, putting all criteria I need. Then open a console and run…

My scheduled script never fired as of 2am today.

My scheduled script when "save and execute" completes within 1min, but has done nothing. NetSuite support closed my case, but if you would like to help them to help themselves, you can give them info: Case #1768628 Defect 261555 What may have helped (though I can't really tell) is that they had me modify a scheduled script…

Then mine was not an exception. My scheduled script never got executed at scheduled times, for a few days. NS Support found it was a defect in my test drive account. Haven't tried that out in my actual account yet.

Sean, Thanks for checking in with my thread. It is a scheduled script. customerID is retrieved from the savedsearch and iterated through the subset of data (count of invoice per customer)... With some logging lines in debugger, I found the script stopped at either length=null or after first subset of data or…

It maybe the same issue I have with the scheduled script pulling subset of saved search. Please advise, on my mental block: [SIZE="2"]var searchRecords = nlapiSearchRecord(null, 'savedsearch1', null, null); for ( var i = 0; (searchRecords != null && i < searchRecords.length); i++ ) { var searchResult = searchRecords[i];…

Any idea on how to suppress this message "Please choose an item to add" in my client script (onFldChgd function) ? My sublist on opp record has no items before edit, but users prefer to add items based on the alerts and bypass this message. And I am using nlapiSetCurrentLineItemValue or nlapiGetCurrentLineItemValue. Thansk…

How can you retrieve item's baseprice on transaction s client script? I have: //var basePrice = nlapiLookupField('item', nlapiGetLineItemValue('item', 'price'), 'baseprice'); //or var basePrice = nlapiGetLineItemMatrixValue('price', 'price', -1, 1); alert('Base Price: '+ basePrice); var pricelevel =…

I tried the same idea for credit balance and am not sure if the nlapiSubmitField is behaving as what it's supposed to. If I tried to update the customfield more than once with the same value (debug or execute several times with nlapiSubmitField line), the System Notes does not record the attempts after the first update at…

This is very helpful for my pulling the cost onto the TO form. :) On the important note: why can't NetSuite have the CSV Import capability for Transfer Orders yet? Who would want to enter over 1000 item lines for a truckload transfer? :eek: Here's an update - I changed the code to the following: function postSourcing(type,…

Does the nlapsiSubmitField work for second update, if the value is the same as exiting field's value? Hello, The following information is from the NetSuite Help at SuiteFlex (Customization, Scripting, and Web Services) : SuiteScript : Scripting Records, Fields, Forms, and Sublists : Direct List Editing and SuiteScript :…

I tried both. The button now fired. Thanks, Olivier and Lorne.

Hi Olivier, It is defined in 2 lines above: var script = 'suiteletButton_Form(\''+ suiteletURL +'\');'; // define client-side script or suitelet Should it be in separate function as in your quote? What does script in form.addButton('custpage_gotoSuitelet', 'Go to FA Worksheet', script); refer to? The code for that funciton…

thanks for the insight, Olivier. Am i havigncorrect format for adding Field that sources from a custom list? var fa_category = form.addField('custpage_fa_category', 'select','Financial Aid Category',sourcelist ID or internalID (the #)?);

it'll hurt your feelings but it'll make you a better coder. :) Thanks both for your responses.

Never mind my question earlier, I got it to work.

Yep, I missed the important 4th parameter, the "boolean". :p So I was enlightened quite a bit ... However, the three fields that I want to retrieve from the custom saved search (main fields from PO: Customer Name, Location, Number, Created From, Amount, Vendor) really gave me a hard time. With the true boolean, it helped…

I have tried to get my Alert to work in View Mode using beforeLoad function, but your post sounds like a better route for me. I can't find where in the sample code you applied the new field (Inline HTML type). The more I look, the more I tend to get lost as to why the custom field is needed ... Is it possible to apply this…