Category Archives: Uncategorized

Create Item Receipt From Inbound Shipment (Script)

Category : Uncategorized

  • Inbound Shipment record
  • When receive button is clicked,receive inbound shipment record is formed
  • Created item receipt can be found in the related transaction field of corresponding purchase order.

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


Customizing Address Forms In Netsuite

Category : Uncategorized

Custom address forms can be used to support address format localization for international customers, and unique business requirements for all customers. A standard address form is provided for all accounts and assigned by default to all countries. Account administrators and other users with the Custom Address Form permission can create as many customized versions of the address form as needed, and assign each custom address form to one or more countries.

When users view or … 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


Celigo ‘One to many’ configuration

Category : Uncategorized

  • Normally in celigo, flow runs against each record in the export.
  • ‘One to many’ configuration that is available at the connector level.
  • One to many configuration is used when the input data contains child records that should each be considered as the main record.
  • If the records being processed are JSON objects, the Path to many’ field can be used to enter the JSON path to child records.
  • In the below example while
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


Comparing Applied To Transaction and Applying Transaction In Netsuite Saved Search

Applied to Transaction and Applying Transaction are the two fields that often confuses Netsuite users while creating Transaction saved searches, yet very handy when we need to find related Transactions. Applied to Transaction fields are used to find the originated records of the current transaction whereas Applying Transactions are derived transactions from the current transaction.

For example, If you take Sales Order as the current transaction,Opportunity can be an Applied Transaction and Item Fulfillment can … 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