Thanks Jack, but this will also add extra rows for each item If the item is in 2 POs, one with A in the dropdown list and one with B, then 2 rows will be displayed (displaying B and -None- in results for the formula)

Got it, Thank you :)

Hi, Thanksfor your reply, but we are not using matrix item. For inventory part items, it is lkogical to have a validation on UPC (as the current situation), where an error message is displaying when we try to save item with a used UPC for another item. But, I've found 2 items on the systemwith the same UPC and I'm trying…

Hi, Sorry for late reply, I'm trying to create an item saved search. I got the enhancement number and will vote. Thanks

Hi Mikko, I got the answer and already shared the code worked with me. Thank you :)

Hi, Thanks all for help The following code that initially works for client scripts: var ship_att = nlapiGetFieldValue('shipattention'); var ship_addressee = nlapiGetFieldValue('shipaddressee'); var ship_add1 = nlapiGetFieldValue('shipaddr1'); var ship_add2 = nlapiGetFieldValue('shipaddr2'); var ship_city =…

Hi, Thanks all for your time to help. No errors returned, but the field is not changed. The phone number I want to changes is the one in shipping address (as the following screenshot) -- ship to address under address tab in sales order page: I run the following code for testing purposes (comments for the Execution Log…

It works, Thanks :)

Thanks a lot :)

Hi, The summary type will not work because I want the sum in the formula, not for the result of the formula. What I want to display is the discount percentage applied on group members in case members have an online price example: Item A Base price: 10, Online price: 7.5 Item A, Base Price: 20, Online Price: 15 Group item…

Works perfect, Thank you :) How can I display the following formula in saved search results? ({memberitem.price}*100)/SUM({memberitem.onlineprice}) I couldn't find the sum in functions, it is only displaying in summary, but it will not work for us. The above formula should be in results for a saved search to display groups

Hi, Thanks for your reply. Once I added the following line in my script, the script returned an error var csvFile = file.create({ name: 'data.csv', contents: codesList, folder: 123, fileType: 'CSV' }); //codesList is the string I want to include in the csv file,

Hello, This is the script I use to get the internal id and detailed description for items as a csv file. function GetDetaileddescription(){var columns = new Array();columns[0] = new nlobjSearchColumn( 'internalid' );columns[1] = new nlobjSearchColumn( 'storedetaileddescription' );var searchresults =…

Thanks Avej Shaikh. Why NS make it complicated, it was an easy way with one line of code and no need for search