3955097 Green Ribbon

Dear Mondray, I have followed the way you suggested. This message was shown: No results found No Search Results Match Your Criteria. Actually, what I have is, in the Sales Order I have a Kit Item, which is not a drop ship item. But the components in the Kit Item were three drop ship inventory item. When I approved the…

Hi All, How about to get a link of the Return Authorization in the Invoice or Sales Order. I can get the Invoice link in the Return Authorization, but cannot get the Return Authorization Link in the Invoice. And in the Invoice i cannot get any information for that have been returned. Kingson

Thanks Richi I may need to put the button in the More Actions drop down list because I may have many functions to add here in the same page. But seems the User Event Script cannot add the button to the More Actions drop down list. Do you know any script to add the button to the More Actions list?

Answered by the netsuite support that the Custom Actions can only appear in the edit mode but not in the view mode.

Dear Jasvir, Thank you for your answer. I have followed your way to set my saved search. but I even cannot get the custom record value from in the saved search. I can now get select the transaction fields, Royalty fields. but none of the royalty field have value display on it. I have already set the two royalty names and…

I have posted the same to NetSuite Support. They replied that it is an Enhancement # 189852 View existing Opportunity record > General > Estimates > New Estimates: Custom record types tabs are not available while if we go to Transactions > Sales > Prepare Estimates custom record types tabs are showing. Hope it will come…

Hi Guillaume, Thanks for your answer. Actually how can you find this id? I cannot get this id anyway in help or record browser. BTW, there are some field inside this item vendor sublist, purchase price, prefered, subsidiary. What is the id for those field? and how to get these? Thanks again.

Hi George, What is the way to do it? I have looked into the Record Browser for the two record types. I cannot find any useful details for me to work out the recognize the gift certification. Can you give me any more information?

Maybe I can give out more about my situation. Our clients will provide some service and they will issue invoice and settle the invoice by gift certificate immediately after the the services date is confirmed. Now we are using a custom record to store the service booking. in the custom record we will store the cert code and…

Dear Olivier, Thanks for your answer. After searched in Google, I found a useful link and script that may help my situation. http://www.codeproject.com/Articles/58728/JavaScript-code-to-determine-when-DayLight-Savings Hope this can help the others when they face this problem.

Hi Ben, I have faced the same problem with you before. I have used a workaround to deal with this. I get the variables by script and replace it in the script. This work around is taught by Olivier. You can look at this Post. https://usergroup.netsuite.com/users/showthread.php?t=32762

Hi Ben, I have tried and i can put the nlapiMergeRecord Object as the attachment. var mailRec = nlapiMergeRecord(3, 'purchaseorder', recId); var newAttachment = new Array(); newAttachment[0] = mailRec; var newEmail = nlapiSendEmail(sender, receiver, title, body, senderEmail, null, records, newAttachment); Here is my tested…

Hi Ben, Nice to know you can solve the problem. The .getValue() is used for get the main body of the mail merged. Without the .getValue(), it will return a nlobject. Only the object can be sent as attachment.

I have tried to use the nlapiSendEmail together with the nlapiMergeRecord. That's work for me. I just followed the NetSuite Help. Thanks Olivier!!! function afterSubmit(type) { var newRec = nlapiGetNewRecord(); var senderInfo = nlapiGetContext(); var mailRec = nlapiMergeRecord(1, 'customer', newRec.getId()); var records =…

Thanks Olivier, That's really a good suggestion that I have never thinking of. Will try soon. Thanks so much.

Hi, It is one part of the SuiteScript. The Find and Replace is used in Suite Script.

Hi Olivier, Thank for you help, i can now link the message back to the Transaction. Now I have got another question. Can I use the Email Template which is set in the the UI?:confused: Thank again:D

I have done some similar things before. Did your item are Lot item/Serial item? If it is a Lot item, you have to assign the Lot number to the line item before you can really save the record. I think if it is a Serial Item, which will be similar to what i have done for lot item.

[PHP] var itemDetail = ''; itemDetails += 'Item: '; itemDetails += recSO.getLineItemText('item','item',1); itemDetails += '<br/>'; itemDetails += 'Unit Price: '; itemDetails += recSO.getLineItemValue('item','rate',1); var body = mailRec.getValue(); body = body.replace('$$$itemDetail$$$', itemDetail); [/PHP] Here is my…

Dear Olivier, Thank for your suggestion. How if my email will be compose of the line item information? Or if the email will be compose with some cross transaction information (such as send email in the PO with the information of the related SO)? Regards,

I have faced this issue before, but I still have no idea. What I have done is to set a custom field in the transfer order which will bring a default value to the item fulfillment. This custom field is hidden from user. Then check this field to see if it is transfer order. This is what I have done to check.

Hi tbuffington, Thanks for your advise. var custbodyremarks = recEST.getFieldValue('custbodyremarks'); custbodyremarks = custbodyremarks.replace(/n/g, '&lt;br /&gt;'); var remarks = ''; if (custbodyremarks != null) { for (var y = 0; y &lt;= custbodyremarks.length; y++) { var w=custbodyremarks.substring(y,y+1); if (w ==…

Hi tbuffington, Currently I have this code. And I am textbox field is input like this: 1. XXXXXXX^ 2. YYYYYYY^ 3. ZZZZZZZ^ var custbodyremarks= nlapiEscapeXML(recEST.getFieldValue('custbodyremarks')); var remarks = ''; if (custbodyremarks != null) { for (var y = 0; y &lt;= custbodyremarks.length; y++) { var…

That's fine then. I just want to find some easy way to get the item type to us in nlapLoadRecord.

Hi Shrinivas, The belows the help center I have refered to and tried. The code i did tried is work to write the date to a date field. nlapiStringToDate(str, format) Converts a String to a Date object using the current user's NetSuite date format, or to one of the formats passed in the format parameter. Be aware that…

Which type of script you are using? I would use the user event to do so. function onClick(type) { if ((type == 'create') ||( type == 'edit')) { var recId = nlapiGetRecordId(); var recEst = nlapiLoadRecord('estimate',recId); recEst.setFieldValue('custbodyquointernalid',recId); var id = nlapiSubmitRecord(recEst, true); } }…

I have done some similar codes before, hope this can help. var recId = nlapiGetRecordId(); var recEst = nlapiLoadRecord('estimate',recId); var today = new Date(); var year = today.getFullYear(); var month = today.getMonth()+1; var date = today.getDate(); var ddmmyyyy = month; ddmmyyyy += '/'; ddmmyyyy += date; ddmmyyyy +=…

Thanks Lorne, I have tried that before. What i have got is, if the item is an inventory item, it will show up an "InvtPart", which cannot be used in the script to load the item record ( nlapiLoadRecord('InvtPart', itemId)).

Thanks Lorne, Just because I cannot get the answer there, I start a new post and hope to detail out my case here. Do you have any idea for this?

Thanks Vsantos, I have tried this just now. I have updated my bundle in the base account. And I need to update the client account in order to make it update in the active. That is very useful for us to do the setting and testing our testing account and push it to the client's production account with locking the script.…