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
Tag: Netsuite
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:
Update additional tracking number field in purchase order record if request json contains greater than 5 purchase orders.
Reducing the Recurrence count by one whenever a user creates a copy of the PO record in Before Submit Trigger using User Event Script in Netsuite.
Steps:- First visit a Parent PO record. Click on edit and enter a desired positive integer value in the Number of Recurrence field. Click on save. Make a copy of the Parent PO. Save the child record or copy of that PO. Navigate to the respective or related Parent PO. The number will be reduced… Continue reading Reducing the Recurrence count by one whenever a user creates a copy of the PO record in Before Submit Trigger using User Event Script in Netsuite.
Update additional tracking number field in Purchase order
/** * @NApiVersion 2.1 * @NScriptType MapReduceScript */ define([‘N/email’, ‘N/record’, ‘N/render’, ‘N/recordContext’, ‘N/runtime’,’N/currentRecord’, ‘N/search’,’N/file’], /** * @param{email} email * @param{record} record * @param{recordContext} recordContext * @param{runtime} runtime * @param{search} search */ (email, record,render, recordContext, runtime, currentRecord, search, file) => { /** * @description the function to check whether a value exists in parameter * @param… Continue reading Update additional tracking number field in Purchase order
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
Invoice email script-payment
script that triggers only on Create context of Payment ,that will send the emailusing the email template “CTG-Invoice” to anyone with “receive invoice” (on the customerform, under Relationships) checkbox checked and terms not Empty. only send the email in the case of invoice is “Paid in Full”
Oracle NetSuite Beta Program
Description To access beta records via REST API, we need to enable a feature in Enable Features page, on the SuiteCloud subtab. In normal case, this feature will not be available in that page. So the company must review and accept the Oracle Cloud Services Beta Trial License Agreement by completing the Oracle NetSuite Beta… Continue reading Oracle NetSuite Beta Program