Tag: Netsuite

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

SuiteScriptError”,”name”:”INVALID_FLD_VALUE”,”message”:”You have entered an Invalid Field Value

I have written a Map reduce script to create a sales order.But getting error when setting the Item.{“type”:”error.SuiteScriptError”,”name”:”INVALID_FLD_VALUE”,”message”:”You have entered an Invalid Field Value 19593 for the following field: item”}. Sript works fine for already existing item.But not working for the items I have recently created in Netsuite.These Items are not listed in the item… Continue reading SuiteScriptError”,”name”:”INVALID_FLD_VALUE”,”message”:”You have entered an Invalid Field Value

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

Proposal for Inventory Count and Adjustment Enhancement

Proposal Summary Flowco needs to have enhancements on Inventory Count and Inventory Adjustments.  Requirement Flowco needs to have the following enhancements on Inventory Count and Inventory Adjustments. Currently, the Inventory Adjustment is not having reference to the corresponding Inventory Count. So they need to have a hyperlink on the Inventory Adjustment record back to the… Continue reading Proposal for Inventory Count and Adjustment Enhancement

Time sheet records and time track records in Netsuite

Timesheet records are kind of records which keeps the time records of each customer. The records are for a week. Ie; it keeps the time record of each week. Whether you use time tracking features within NetSuite or you use some other system for employee time entry and approval, now is the time to take… Continue reading Time sheet records and time track records in Netsuite

Integration of Google maps in Netsuite

In the era of cloud based business and communication services, integration of services, processes and product has become a necessity for a business to improve its efficiency and productivity. The integration of two major cloud based service providers that don’t requires anyone’s introduction NetSuite and Google Apps has potential to completely change entire work efficiency… Continue reading Integration of Google maps in Netsuite

Generating passwordGUID and hostkey for connecting external servers via suitelet

Solution var HTTPSMODULE, SFTPMODULE, SERVERWIDGETMODULE;var HOST_KEY_TOOL_URL = ‘https://ursuscode.com/tools/sshkeyscan.php?url=’;/** *@NApiVersion 2.x *@NScriptType Suitelet *@NModuleScope Public */define([“N/https”, “N/sftp”, “N/ui/serverWidget”], runSuitelet);//********************** MAIN FUNCTION **********************function runSuitelet(https, sftp, serverwidget){ HTTPSMODULE= https; SERVERWIDGETMODULE= serverwidget; SFTPMODULE= sftp; var returnObj = {}; returnObj.onRequest = execute; return returnObj;}function execute(context){ var method = context.request.method; var form = getFormTemplate(method); if (method == ‘GET’) { form =… Continue reading Generating passwordGUID and hostkey for connecting external servers via suitelet