Requirement We need to create a child sales order from parent sales order. The child sales order must open in new tab when clicked on a button in parent sales order. And should populate with basic body fields. Solution
Author: Jesna John
Project Task Auto Population In Timesheet
Requirement We need to populate the corresponding project task in the timesheet when the user selects the project. The population will only take place if the project has one project task. Solution We can create a client script and a suitelet script to populate the project task. When a project is selected in a time… Continue reading Project Task Auto Population In Timesheet
Downloading a file in PDF format from suitelet page
Requirement We need to download an invoice pdf from the listed invoices when clicking on the link provided against each line of invoices in suitelet page. Solution We can provide a suitelet link as download link. While clicking on the link, that particular invoice is downloaded in pdf format. This can be done by using… Continue reading Downloading a file in PDF format from suitelet page
Issue when suitelet page redirects to Netsuite Login
Issue The suitelet page will redirect to netsuite login page when open by clicking on suitelet URL Solution The suitelet page will open without redirecting to Netsuite Login page when the returnExternalUrl is set to true while calling the suitelet script from any other scripts. Following is the code snippet to set it true.
EDI Possibility in NetSuite
Requirement The client has a new requirement to check the possibility of integrating EDI with NetSuite. They need to have an opportunity to get them to invoice via EDI. At present they have a reasonably manual system where they compare the Bluescope invoice that comes through each day (samples attached) with the coils taken off… Continue reading EDI Possibility in NetSuite
Getting values from a saved search formula column
Requirement Formula columns are all named the same internally, which is why you can’t directly get their values individually. For instance, if you have two Formula (Numeric) columns in your search, both internal column names will be “formulanumeric”. Therefore, using getValue(‘formulanumeric’) will get only the first formula value. Solution
Item Cost Changes for Selective POs
Requirement We need to ability to select the purchase orders for updating the line-level item cost. We need to update the none of PO status closed, canceled and billed PO’s with the new item rate when it is being updated in the item record. But this should not update the item cost for all the… Continue reading Item Cost Changes for Selective POs
Item Cost Auto Update in Open POs
REQUIREMENT The requirement is that need to update the none of PO status closed, canceled and billed PO’s with the new item rate when it is being updated in the item record. SOLUTION Client script for to check if the item rate is changed in Item Record A custom record is created to store the… Continue reading Item Cost Auto Update in Open POs
Sales Order Customization
Requirement We need to create a new button in the sales order and if the user clicks the button, a new sales order will open and the body fields will be populated from the parent sales order (Except some fields like date). User will enter the item lines manually and save the child sales orders.… Continue reading Sales Order Customization
Double Entry of the Same Customer PO
Requirement Need to prevent the double-entry of the same Customer PO. We can prevent this by using a client script. 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… Continue reading Double Entry of the Same Customer PO