Developing a Custom GL Lines plug-in implementation

Developing a Custom GL Lines plug-in implementation

Custom GL Lines plug-in implementations in Netsuite are used to modify the GL entries for transactions. Following are the basic steps that need to be followed to develop plug-in implementation of the Custom GL Lines plug- in:

Enable Features : First, we need to enable  Custom GL Lines Plug-in and Server Suitescript features. To do this,

Setup > Company > Enable Features under Suitecloud tab enable Server SuiteScript, Custom GL Lines features by clicking on … Read the rest


Transfering Files To FTP Server using Suitescript

Tags :

Category : Uncategorized

In simple terms, FTP is a communication protocol that enables users to share files between systems. We can do this in Netsuite using Suitescript. Following is a sample code that can be used to upload file from Netsuite to the FTP server,

var fileObj = file.load({id: 271});

var FTPurl = ‘test.rebex.net’;

var FTPusername = ‘demo’;

var passwordGuid = ‘7a8812d753a94399996e007f965ac462’;

var hostKey = “AAAAB3NzaC1yc2EAAAABJQAAAQEAkRM6RxDdi3uAGogR3nsQMpmt43X4WnwgMzs8VkwUCqikewxqk4U7EyUSOUeT3CoUNOtywrkNbH83e6/yQgzc3M8i/eDzYtXaNGcKyLfy3Ci6XOwiLLOx1z2AGvvTXln1RXtve+Tn1RTr1BhXVh2cUYbiuVtTWqbEgErT20n4GWD4wv7FhkDbLXNi8DX07F9v7+jH67i0kyGm+E3rE+SaCMRo3zXE6VO+ijcm9HdVxfltQwOYLfuPXM2t5aUSfa96KJcA0I4RCMzA/8Dl9hXGfbWdbD2hK1ZQ1pLvvpNPPyKKjPZcMpOznprbg+jIlsZMWIHt7mq2OJXSdruhRrGzZw==”;

var conn = sftp.createConnection({

‘username’: FTPusername,

‘passwordGuid’: passwordGuid,

‘url’: FTPurl,

‘hostKey’: hostKey… Read the rest


Invoice Group in Netsuite – Features and Scripting

Tags :

Category : Uncategorized

Netsuite’s Invoice Groups feature enables grouping of invoices for customers. This feature allows for the creation of several Invoice Groups per customer. Applying payments to an Invoice Group is made easier by this functionality. All of the invoices in an Invoice Group are affected when a payment is applied to that group of invoices. Netsuite enables partial and full payment for Invoice Group just like it does for regular invoices.

For accessing the invoice groups, … Read the rest


Filtering in Celigo using Javascript

Tags :

Category : Uncategorized

Filtering in Celigo flows is of two types.

  1. Output filter – Used to filter data exiting an import(lookups)/export step
  2. Input filter – Used to filter date entering an import step

To add filters on a flow step

  1. Click on define options in the import/export step
  1. Now you can see the filter symbol next to your import/export

The symbol with the arrow exiting shows the output filter and the arrow entering shows the input filter

Now … Read the rest


Export & Import Data Into Microsoft Sql Using Celigo

Tags :

Category : Uncategorized

Microsoft Sql Server : Its a relational database management system developed by Microsoft.It is a software product with the primary functions of storing and retrieving data as requested by other software applications.

Export Data From Microsoft Sql Server

  • From the Resource menu, select Exports to open the list of exports of account.OR, at the upper right of exports page click + create export.
  • For creating an export, a new window will pop up,
Read the rest

Adding Lookup in HTTP Request body

Tags :

Category : Uncategorized

Import mapping defines how your source data relates to your import destination record data. During mapping, lookup in the field mapping settings is used to retrieve additional data from the same destination system.

In field-to-field mapping, you can add lookups from the settings.

But, when you are using HTTP Request Body to map your data, Things are different.

Here, you need to separately create lookup codes and call them in your request body.

To add … Read the rest


Celigo Presave hook with Example

Hooks means its a custom code that can be used in  different stages during the execution of  flow (exports,imports), to modify the processing data.

Export stage consists of 2 hook types:

1.    Presave 

2.    Presend

PRESAVE

The presave hook works after the export completes and  before the data  is taken from the destination application.

This hook is  mainly used to format,filter,perform logics etc on the data coming from export before the data moves … Read the rest


CONNECTING WITH POPULAR SOFTWARES USING CELIGO

HubSpot

System Overview : HubSpot is a CRM platform designed to help companies market better.

HubSpot helps to make proper interactions with customers.

With Hubspot we can assign tasks to our employees and we can conduct email campaigns.

HubSpot helps to track workflows that will help to generate quality leads.

Set up a token-based Celigo-HubSpot connection:

  • From the Resources menu, select Connections. Then, click + Create connection
  • Select Hubspot From Application list.
  • Name the connection
Read the rest