SQl Server Integration Services (SSIS)

SSIS simply helps to Migrate data’s from Netsuite to outside Databases which are mainly loaded in SQL server.Mostly Export is done through Visual studio Community towards SQL Server which is located in Microsoft Azure platform. Part_1: Netsuite Connection Setup through SuiteAnalytics Connect(ODBC Driver) Part_2: Creating  a project in Integration Services Project Template(Visual Studio community) Part_3:… Continue reading SQl Server Integration Services (SSIS)

How to Add Netsuite to Outlook

Search for Outlook Integration bundle on Enable features (Path: Setup -> Company -> Enable Features -> SuiteCloud -> Integration Add-ons -> Outlook Integration). On General Preferences (Path: Setup -> Company -> General Preferences -> Custom Preferences -> NetSuite for Outlook) select the following fields and save.

Feasibility of Amazon Integration using different methods

Requirement The Client requires to integrate the Orders which are ‘Fulfillment By Amazon’(FBA) to Netsuite. Also, they want to record the Fees from Amazon (such as Storage Fee, Advertisement Fee, etc) as a Journal in NetSuite. Introduction  The Integration of Orders and Fees with Netsuite from Amazon can be achieved by following methods: Amazon –… Continue reading Feasibility of Amazon Integration using different methods

Outbound Integration of Customer Master Data and Customer Balance From Netsuite

Requirement  The client would like to sync the customer data and customer balance data from Netsuite to the Application. Our Solution We will provide a REST API for the Application user to fetch the data from Netsuite to the Application. Customer Data Sync We will be implementing an API to fetch the customer data from… Continue reading Outbound Integration of Customer Master Data and Customer Balance From 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

Proposal For NetSuite Shopify Integration

Proposal summary We need to provide specifications for connecting Shopify to Netsuite. Requirement We would like to implement the following connections to API Add orders from Shopify under a single customer in NetSuite Import Orders from Shopify to NetSuite. Export Fulfillments from NetSuite to Shopify Export Inventory Levels from NetSuite to Shopify Export Item Pricing… Continue reading Proposal For NetSuite Shopify Integration

Adrenalin-Netsuite Employee Integration : Solution

Requirement: Neutrinos needs to integrate the Master Data Employees from Adrenalin to Netsuite. Also would like to migrate existing employee records from Adrenalin to NetSuite. Prerequisites: Token based Authentication(TBA)  is considered here as Authentication type. So, need to set TBA( refer http://jobinandjismi.in/setting-up-netsuite-token-based-authentication-tba/ ) We will provide the consumer key, consumer secret, token ID, token secret,… Continue reading Adrenalin-Netsuite Employee Integration : Solution

Setting Up Netsuite Token Based Authentication (TBA)

Token-based authentication is a protocol that generates encrypted security tokens. It enables users to verify their identity to websites, which then generates a unique encrypted authentication token. To use Token Based Authentication (TBA), the following things need to be done first: Enable Token-Based Authentication Create Integration record Create a Role and assign it to a… Continue reading Setting Up Netsuite Token Based Authentication (TBA)

Wrapper API- Integration

Proposal summary We are returning the order and financial summary from Netsuite in the JSON format using the Restlet script whenever the API is requested from the external application. Specifically we are returning the school order details, parent-student order details, invoice and payment details. Requirement  XSEEED Education is developing an internal app product that is… Continue reading Wrapper API- Integration