Userevent script to get the transit time details from FedEx and UPS. The requested transit time details can be displayed in a tabular format in Item Fulfillment record. const beforeLoad = (scriptContext) => { try { if (scriptContext.type === scriptContext.UserEventType.CREATE) { let newRecord = scriptContext.newRecord; let shippingCarrier = newRecord.getValue({ fieldId: ‘shipcarrier’ }); let transactionDateObject =… Continue reading Script to get the transit time details from FedEx and UPS API to Item fulfillment record in NetSuite.
Category: NS Integration
All articles / code related to Netsuite integration
Ship Central connection broken
Problem Statement: We are still in our implementation phase, hoping to go live 1 July 2024. Our developer did not have ship central in his scope of works, but I felt confident that I could follow instructions on how to set up Ship Central. This was successful, however the developer removed the SCM Mobile bundle… Continue reading Ship Central connection broken
OAuth 2.0 over OAuth 1.0
OAuth 2.0 is preferred over OAuth 1.0 for several reasons: 1. Simplicity of Implementation OAuth 1.0: Requires complex cryptographic signatures to verify requests. This means developers have to deal with complicated encryption methods and handle signing each request, which can be tricky and error-prone. OAuth 2.0: Uses simpler bearer tokens for authentication. This means you… Continue reading OAuth 2.0 over OAuth 1.0
Why OAuth 2.0 is preffered?
OAuth 2.0 is preferred because it offers secure, flexible, and user-friendly ways to manage access to your data: Secure Access: OAuth 2.0 lets apps access your data without needing your password, keeping your credentials safe. Control: You can give apps specific permissions (like read-only access) rather than full access, so you have more control over… Continue reading Why OAuth 2.0 is preffered?
Enable the OAuth 2.0 Feature
To enable OAuth 2.0 feature: Go to Setup > Company > Setup Tasks > Enable Features. Click the SuiteCloud subtab. In the SuiteScript section, check the following boxes: Client SuiteScript. Click I Agree on the SuiteCloud Terms of Service page. Server SuiteScript. Click I Agree on the SuiteCloud Terms of Service page. Note You must enable both the Client SuiteScript and Server SuiteScript… Continue reading Enable the OAuth 2.0 Feature
Adding Sync models in Hightouch to use as a NetSuite connector
Syncs declare how you want query results from a model to appear in your destination. To learn more about syncs on a conceptual level, see the core concepts page. Refer to destination docs for specific configuration details. To learn more about the information the Hightouch UI displays on your syncs and what actions you can take… Continue reading Adding Sync models in Hightouch to use as a NetSuite connector
How can I track which fields have been edited in Netsuite when syncing NetSuite sales orders to Salesforce?
If you have a limited set of fields to check you can make use of the old record. Rough idea below: function afterSubmit(context) { const oldRec = context.oldRecord; const newRec = context.newRecord; const updateSpec = getBodyChanges(newRec, oldRec); updateSpec.lines = []; // similar idea for lines but you also have to make sure lines (checking lineuniqekey)… Continue reading How can I track which fields have been edited in Netsuite when syncing NetSuite sales orders to Salesforce?
How to Call https.patch in NetSuite to Update a Salesforce Record
You can work around this limitation by sending a POST request and including a query string parameter _HttpMethod to override the HTTP method. For example, if you need to perform a PATCH requestyou can modify your request as follows by adding ?_HttpMethod=PATCH to the end of your url POST /your/endpoint?_HttpMethod=PATCH I found this solution in… Continue reading How to Call https.patch in NetSuite to Update a Salesforce Record
HRIMS Employee Attendance Sync
/** * @NApiVersion 2.1 * @NScriptType MapReduceScript */ /*********************************************** * ATPL-67 – Implementation | HRIMS Integration * ********************************************* * * Author: Jobin & Jismi IT Services LLP * * Date Created : 05-February-2024 * * Created By: JJ0124, Jobin & Jismi IT Services LLP * * Description : Map Reduce script is used to perfrom… Continue reading HRIMS Employee Attendance Sync
HRIMS Employee Sync
/** * @NApiVersion 2.1 * @NScriptType MapReduceScript */ /*********************************************** * ATPL-67 – Implementation | HRIMS Integration * ********************************************* * * Author: Jobin & Jismi IT Services LLP * * Date Created : 05-February-2024 * * Created By: JJ0124, Jobin & Jismi IT Services LLP * * Description : Map Reduce script is used to perfrom… Continue reading HRIMS Employee Sync