Month: August 2021

Import of Credit Memo

Extraction of Files  Report used is – JJ A/R Aging Detail for Invoice Migration Saved Search – JJ Credit memo migration Creation of the Unique ID Concatenate Document Number(Col F) + Internal ID (Col H) Example – 89307 + 12285 = 8930712285 Creation of External ID of the customer Concatenate NS + Internal ID (Col H)… Continue reading Import of Credit Memo

Import of Invoice

Extraction of Files  Report used is – JJ A/R Aging Detail for Invoice Migration Saved Search – JJ invoice migration body fields Creation of the Unique ID Concatenate Document Number(Col F) + Internal ID (Col H) Example – 89307 + 12285 = 8930712285 Creation of External ID of the customer Concatenate NS + Internal ID… Continue reading Import of Invoice

Custom Bulk Print Checks

To Print the multiple bill payments we have to create a custom UI to print the transactions as check.Created a custom UI for Multiple checks print as similar to standard “print checks and forms”. suitelet for creating the custom UI and Print the multiple pdf. client script advanced pdf template

Custom Bulk Print Page

Details of creating custom page for printing Packing Slip PDF on a button click , in Bulk. Suitelet for Design Bulk page print : – Client Script Suitelet for print multiple pages :-

Purchase order list API using Restlet

/** * @NApiVersion 2.1 * @NScriptType Restlet */define([‘N/search’,’./moment.min.js’,’./hs.2x.logger.js’], /** * @param{search} search */ (search,moment,logger) => { let DEFAULT_PAGE_SIZE = 25 let API = ‘PURCHASEORDER’ /** * Defines the function that is executed when a POST request is sent to a RESTlet. * @param {string | Object} requestBody – The HTTP request body; request body is… Continue reading Purchase order list API using Restlet

Excel Functions Used In CSV Import

We have to use various excel functions for importing such as Text functions ,Lookup functions ,Date and Time functions, If and related functions etc Note: In Excel we can use FORMULATEXT() function to know the functions that we have used in each cells. a) Right function is used to extracts a given number of characters… Continue reading Excel Functions Used In CSV Import

SagePay Integration Proposal

Proposal summary This proposal details how to enable SagePay as an external payment gateway in NetSuite with the help of SagePay APIs.  Requirement  Payments (Via the SagePay Integration) will be triggered from the Sales Order record only via a button/popup. On Customer Deposit Record The Deposit record must be created from the Sales Order to… Continue reading SagePay Integration Proposal

Klaviyo Integration Proposal

Proposal summary The proposal covers the Klaviyo Integration with NetSuite for the following scope :  Item Catalog Sync :Transquip should provide a saved search in NetSuite for Product Catalog integration that contains Item details including id, title, description, item link, item image link.We can build the connection but the trigger should be manual. Entity Sync… Continue reading Klaviyo Integration Proposal