Tag: Scheduled script

Update Item status to inactive

Requirement We need yo update an to inactive item records if the following conditions are satisfied: Item is discontinued item Total inventory is zero (Quantity on hand in item record is zero) If there is no purchase orders exist for the item in the following status Purchase order: Pending Supervisor approval  Purchase order: Partially received … Continue reading Update Item status to inactive

Passing values to Script parameters via Suitescript

Script parameters are useful when there is a requirement to store data specific to a script but more accessible to all users other than developers. Using script parameterswe can avoid hardcoding certain values to the code that is required to be modified often. Also these values can be modified by anyone having access to the… Continue reading Passing values to Script parameters via Suitescript

Scheduling Fixed Asset Creation

Scenario: If the bill/journal contains lines that don’t have fixed assets created is greater than 100,  The script will create fixed assets with scheduled process. The script will be scheduled for every 1 hour. And the scheduled script will send the email to the bill owner after creating the fixed asset for that bill. Solution:… Continue reading Scheduling Fixed Asset Creation

Rescheduling Tasks using scheduling script

Scenario: Example for rescheduling tasks using scheduling task For rescheduling, you need to import ‘N/task’ module first. It is needed for creating each rescheduling tasks after reaching the limit of remaining governance. You can just call this function whenever you want rescheduling. You can change the parameters of the function according the requirement. In this… Continue reading Rescheduling Tasks using scheduling script

Commission Report On Dashboard

Requirement To set up the dashboard to display the commission reports based on the market managers and regional managers. Solution Its not possible to setup a Dashboard using single saved search. So What we have to do is combine multiple saved searches to calculate commissions and setting up dashboard. So we can approach custom records… Continue reading Commission Report On Dashboard

Hubspot integration of activities

Integrating phone calls, emails, and notes from Hubspot to Netsuite. Details: Initiate an integration with OAuth 2.0: to do the initial authentication and to get the redirect url for creating refresh token Example Authorization URL: Sending a user to this URL will ask the user to approve access to contacts and workflows: https://app.hubspot.com/oauth/authorize?client_id=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&scope=contacts%20automation&redirect_uri=https://www.example.com/ If they… Continue reading Hubspot integration of activities