Create a saved search and add the necessary filters. Then in the summary of criteria add the following code. Here we have checked the last committed date as 12 days ago for the Item Statua as A, B, C or O. If the status is S then last committed date is 43 days ago. …. … Continue reading How to get the date includes the committed and today n saved search
Author: Shanmugapriya Ganesh
How to connect SFTP server using script
First, you have to copy the code for generating Password GUID and Host key. It is suite let code for generating the GUIDs. Just copy that code and deploy the script and execute the script foe one time. While executing you have to mention the script which is going to use for SFTP connection. You… Continue reading How to connect SFTP server using script
How to create a task with dependent script using map/reduce script.
The scheduled or map/reduce script only used as a dependent script. Here we used the saved search to convert the search result as a csv file and stored in the file cabinet. // Specify a file for the search results let asyncSearchResultItemFile = ‘file path need to give… Continue reading How to create a task with dependent script using map/reduce script.
How to get access token of Third-Party APIs(DocuSign) using POSTMAN
First, login to the DocuSign Account or any account. Then Create an APP and Integration key. It depends on the API you have used. We can directly get the access token. Otherwise, here we showed the steps to create an access token for DocuSign Integration. Using the API and integration key, get the access permissions.… Continue reading How to get access token of Third-Party APIs(DocuSign) using POSTMAN
How to Use multiple conditions in search filters
Here, we have used the search criteria’s summary function to meet the requirements. The requirement is “send email to customer if “Appliance only” product is not scheduled for delivery with status A, B, C or O is committed to an sales order for 7 days. Or S status item committed to an sales order for… Continue reading How to Use multiple conditions in search filters
How to filter the search results using filter function
Create a search to fetch the customers who gave Feedback Response First get the search using search.create. Here we removed the customers who gave more than one response from the search results. // Get the search results const searchResults = customrecord_sf_responseSearchObj.run().getRange({ start: 0, end: 1000 }); //… Continue reading How to filter the search results using filter function
How to set landed cost at line level in item receipt
First we need to enable the ‘landed cost per line’ then set the value using script. let newRec = scriptContext.newRecord; let landedCostField = newRec.getSublistSubrecord({ sublistId: ‘item’, … Continue reading How to set landed cost at line level in item receipt
Why the record page got struck when we validate a field in fieldChanged function?
Here the sample code to check whether the opportunity name already exists, if it exist then it will show an error. However, if you are not added return values, then it struck in the same field and page also not support to enter the next fields. function fieldChanged(scriptContext) { try { … Continue reading Why the record page got struck when we validate a field in fieldChanged function?
How to get the button id from the contacts record.
First go to the contact record page. Then right click and select Inspect(Ctrl_shift+i). Go to the elements and select search (Ctrl+f) Then type the button name for example(New Task) then it will redirect to the that word. View the id of the button.
Create opportunity record using make a copy option by suitescript
To make a copy of a record using suitescript, use the following code. let objRecord = record.copy({ type: ‘opportunity’, id: ‘internal id of the record’, … Continue reading Create opportunity record using make a copy option by suitescript