BM136 Red Ribbon

Hi Jack, Thanks for your response, but in this case, we will not get needed information in the same page (Which is the saved search results), we have to open each item to check if "option B" selected for one of its POs. Seems that what we are trying is not doable, and the solution you provide is the best thing we can…

It is an Item Search the following are screenshots for the saved search criteria and results

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