Requirement We need the prevention of double-entry of the same Customer PO. We can show an alert message while trying to save the record. This alert also prevents the user from saving the sales order record. To check the double entry, we will check if there are any already existing sales order that has the… Continue reading Double Entry of the Same Customer PO
Author: Jesna John
Populating the files of a folder in file cabinet to select option in Suitelet page
Requirement We need to display the files of any type from a particular folder in file cabinet to the select options in suitelet page. Solution A saved search created to fetch the files from a folder (internal id :1635) in file cabinet. Then this files can be populated in the options of the select field… Continue reading Populating the files of a folder in file cabinet to select option in Suitelet page
Setting Saved search names to select option in Suitelet
Requirement We need to populate the saved searches created in the account to the select option in the suitelet page. The saved searches of type customer is set in the select field which will allow us to choose from the field’s drop down options. Solution
Automated Emails For Invoices And Credit Memo
The invoice emails including the credit memo and invoices will be sent on a scheduled basis. The requirement can be achieved by creating a custom record for scheduling purposes. The process will work as follows: A custom record will be created containing the following fields – Author Email Template Email Subject Email Body
Issue : Transaction search not running in Restlet script
A transaction search created in restlet script is not executing even if the script results no errors. The script was created for NetSuite Integration Solution Enable permission “Find Transaction” in the Transactions under the Permission subtab in the custom role created for integration.
Updating the Sales Invoice Status To Paid In Full
Requirement The status of the sales invoice is not updating to Paid In Full, if it is applied by a journal and so the sales invoice status will be open even if it is fully applied. Need to create a schedule script for updating the sales invoice status if it is fully applied ie, amount… Continue reading Updating the Sales Invoice Status To Paid In Full
Updating the Sales Invoice Status To Open
Requirement Update the status of sales invoice to open ,when it is in paid in full status with Amount Remaining greater than 0. Solution
PM Review for MPCR in employee center
Requirement Need to create a custom page to list all the mpcr that are open status and the current user is the corresponding project manager (Body or Line). The user is able to select the mpcr and click submit button and the corresponding PM review checkbox will be checked and the corresponding custom fields :… Continue reading PM Review for MPCR in employee center
Setting NetSuite Integration Record
There are a few steps that are needed before setting up the actual Integration record Enabling required NetSuite feature Make sure that all features are enabled by navigating to Setup > Company > Enable Features. Under the SuiteCloud subtab, find the Manage Authentication field group and enable the Token-Based Authentication and OAuth 2.0 features. Set up a custom integration-specific role Navigate to Setup >… Continue reading Setting NetSuite Integration Record
Customer Balance Integration API
Requirement We will be implementing an API to fetch the customer balance data from Netsuite to an application. Request : GET Parameters: CompanyCode : Company code(Company code field in the subsidiary record corresponding to subsidiary field in customer record)- Mandatory CustomerCode : Customer Code(id:custentity_code) field in the Customer record- MandatoryPageIndex: Index of the page(starting from… Continue reading Customer Balance Integration API