Use of ignoreFieldChange options in record.setCurrentSublistValue(options)

There is a no of scenarios where the field values are auto-populated on the field change of a sublist field. For example, when an item sublist field value has been set in the sales order item lines, then fields like rate, tax code, description, location, etc will be automatically populated in the item line. The… Continue reading Use of ignoreFieldChange options in record.setCurrentSublistValue(options)

How to add values to an email template from a custom record and send email

We can use email templates for easily sending emails between two records having a contact. Email templates are helpful when the emails should follow a specific format or have some common content like company logo and address.Email templates can be accessed using the navigation: Documents> Templates > Email templatesIf needed to add field values from… Continue reading How to add values to an email template from a custom record and send email

Open Email Message Popup Window using a custom button and set default values

The following User Event Script deployed to Sales Order record places a button on the sales order page named Email CS. Once this button is clicked, an email message window popup will be opened with predefined values of recipient and template category. We could pass many field values through the URL parameters. For those values… Continue reading Open Email Message Popup Window using a custom button and set default values

Reallocate Items using SuiteScript

Reallocate committed items from Sales Order using SuiteScript. Please Note: NetSuite SuiteAnswer says scripting is not supported for Reallocate Items record, but this is possible via Suitescript. So this might become available in future NetSuite releases as a new feature. So I advise everyone to use this with precaution for now.

Proposal For Custom Page to Send Invoice Email

Proposal summary The proposal summarizes the details about the custom suitelet page which helps the user to preview invoice print and send mail to the user based on the invoice record. It includes email template creation and automatic email sending for specific customers. Prerequisites Macrofin needs to ensure that all the invoice via checkbox in… Continue reading Proposal For Custom Page to Send Invoice Email

Issue in iterating search results

Scenario: While creating saved searches, after getting its result we may need to iterate the result sometimes after the iteration only one item may show in the console(or any output platform). Solution: The searchResults.run() method need a return true statement to continue the iteration. In Suite script, there is no break statement to break the… Continue reading Issue in iterating search results

Auto journal creation & application in Payment

Scenario: Create a journal for applying in the credit section of the payment. Ultimate need is to capture the credit info from the custom record, need to create a journal or custom transaction of journal type then apply the same in the payment record.We have seen a limitation of once payment is saved the credit… Continue reading Auto journal creation & application in Payment

Comparing Two dates

Scenario: We have a start date and a Due date and need to a validation where Due date date should be a date after the Start date. Solution: Usually we can use the JavaScript Date() function. But you can’t compare two dates using that. Better approach to make comparison between dates is to use getTime() function. This… Continue reading Comparing Two dates

When you can’t add details in every fields in Suitelet

Suitelet scripts can be executed with any client scripts. Sometimes in such situations, the suitlet page(interface) mayn’t be working perfectly. There will be some conditions where some fields may not be working or sometime you can’t enter values to all (necessary) fields. In such situations, output also won’t be perfect. In the client script, almost… Continue reading When you can’t add details in every fields in Suitelet