Hi Alan When you test with a regular saved search, does it provide the same behaviour? How many contact records are in your customer record? It sounds like there is two and that's why you're getting two responses. It would compare the custom field to the first contact, provide a result and then compare the custom field to…

Hi David The 'external' value for the displayMode parameter refers to the link when the script deployment is available without login. It really depends how you are using your sURL string. If you're using it in a link on a form, netsuite will automatically determine the correct domain to prefix. If you really need to see…

Hi Kentroylance For any field references, you can refer to Netsuite's record browser (https://system.na2.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_1/script/record/partner.html) In the filters field list, you'll notice that companyname does not exist as a filter so you will need to use a different field to…

Hi Shinichi Technically there could be many reasons why your script is failing. On face value it looks like your script is ok asides from the spaces between the values record.setCurrentLineItemValue('item','item',itemI D); & record.setCurrentLineItemValue('item','quantity',1 0000); What you want to check is the user event…

Hi Gerson Coming from a Netsuite partner background, I could see supporting both SS 1.0 & SS 2.0 being a pain point. Given the large number of scripts already developed in SS 1.0, generally clients wouldn't absorb the cost of updating all the scripts to SS 2.0 without proper justification. A large number of staff are used…

Hi I would suggest doing an advanced search to narrow down the fields that are returned. A basic search tends to take longer because of the amount of data it needs to return. Suiteanswers: 10726 Hope that helps Cheers

Hi Masood You could possibly take a different approach and do a transaction search (cash sale/invoice) and then return records based on the filter "transactions created or modified since the last check" and that should return the customers you need to identify. Cheers

Hi Msid I'm assuming you're pressing the "Bill" button from the Item Fulfillment record. In which case, when you create an invoice from the IF, the URL will contain the internal ID of the IF under the itemship parameter. For example:…

Hi Vkwanengage Your post was pretty long ago so hopefully you've worked it out but just in case, are you loading the record in dynamic mode (SuiteAnswers: 73792)? When a SuiteScript 2.0 script creates, copies, loads, or transforms a record in dynamic mode, the record’s body fields and sublist line items are sourced,…

A long time ago, using the SuiteScript 1.0 API, I appended the job ID that is returned by nlapiSubmitCSVImport at the end of the CSV response URL (/app/setup/upload/csv/uploadlogcsv.nl?wqid=) and downloaded that file using an NL auth header with a username and password to log in. Then I parsed the CSV file for all the…

Hi Karenn There's an enhancement in the works (no idea how long it's been there) which is mentioned in Suiteanswers 35953. The alternative workaround to your formula is to create a saved search with your date criteria and use it as a saved search condition in your workflow. Cheers Patrick

Hi Karenn It is definitely Before User Edit that you should be utilising to achieve this. If the form doesn't stop loading, there could be a recurring loop elsewhere that is causing it. Try turning off all other scripts/workflows related to Cash Sales and see if you still have the loading issue. You can source the…