Using SUitescript 2.0 function search.lookupFields we can get any fields in sales order, from there we can get customer id for the correspomding customer record. Code snippet:
Tag: Suitescript2.0
Transforming an SO to IF using Suitescript 1.0 and suitescript 2.0
This code will transform a sales order to itemfulfillment using suitescript 2.0 and 1.0
Adding Loading symbol while processing
Scenario: When some process is processing if you need to show any kind of loading symbol for representing the process may take some time. For this you need to add a loading symbol on the page Solution: For this you need to add a jQuery section with a HTML code block. The HTML code block… Continue reading Adding Loading symbol while processing
In script how to check ,whether a field value contains a particular word or not ?
In order to check whether a field value contains a particular word or not ,We can use indexOf method. For example : In Script check whether Tracking Number field value contains “PRO#” value or not ? Solution: var trackingNumber = ifRec.getValue({ fieldId: ‘tracking_number’ }); var index = trackingNumber.indexOf(“PRO#”); if(index != -1){ alert(“PRO# found”); } else { alert(“PRO# not found!”); }
Suitelet Page For Resource Allocation
Scenario: We need to create a suitelet page for resource allocation. The suitelet page should contain similar pages like the same. The Body fields should contain, Project Name. Common project fields. The sublist structure should same as the below image. Solution We can use a client script for the validation and another suitelet for background… Continue reading Suitelet Page For Resource Allocation
Rate Card Search
Scenario: Create a saved search for listing the rate card price of a specific billing class with a specific currency. Eg: if the billing class is ‘Consultant’ and the preferred currency is US Dollars, search result should be the corresponding currency value. Solution:
Remove the CORRESPONDING PO and ETA Column Values from Sales Orders.
REQUIREMENT Determine which sales orders are included in the corresponding PO and make sure thecommitted quantity equals the order quantity. If the condition is met, remove thecorresponding PO value and the estimated time of arrival (ETA) from the corresponding salesorder column. SOLUTION
Notify the purchase order’s quantity update by email
Requirement: Send an email to acknowledge the quantity update on the purchase order’s items. When a user or system modifies the number of products in a purchase order. Check that the PO is listed in the “corresponding PO” column of the sales order. If the purchase order is included in the “corresponding PO” column of… Continue reading Notify the purchase order’s quantity update by email
Scheduled Email For PM’s using MR script
Requirement: We need to send pending timesheet details to the corresponding project manager by end of the Day.We can use a scheduled script for the development and it will check the timesheet and send a list of pending timesheets to the corresponding project managers with necessary details such as Date,Timesheet details,Actual Hours,Employee name , timesheet… Continue reading Scheduled Email For PM’s using MR script
Case pack quantity updation with the sales order line quantity
Requirement: In the sales orders, we can enter any number of item line quantities. But from the client business perspective, they need to control the quantity based on the item case pack. The quantity should be multiples of the case pack number and if the quantity is not a case pack multiple we need to… Continue reading Case pack quantity updation with the sales order line quantity