We can bring the custom field value retrieved using a Netsuite saved search to the Shopify product variant record meta field. For this first, we need to create a normal Item Search in Netsuite and add it in Export. The result of the search should include the custom field value As a next step, we… Continue reading Netsuite Custom Field to Shopify Product Variant Meta field – Celigo Custom Flow
Author: Anuja Varghese
Reallocating Committed Stock
Netsuite has a standard way to reallocate items that are already committed to an order. For that, we need to go to Transaction > Order management > Reallocate Item There we need to select the item we need to reallocate and then the Location. The current Quantity On Hand, Quantity Committed, and Quantity Required to… Continue reading Reallocating Committed Stock
Contact Record link in Customer Record
Usually, if the customer is an Individual the contact record tab doesn’t show up in the customer record. So to add the contact record link in the customer record, you can do the following steps. Go to Setup > Company > General Preferences Then check the ” SHOW INDIVIDUALS AS CONTACTS” checkbox and hit Save. So… Continue reading Contact Record link in Customer Record
Proposal For Activ PDF’s – Invoice, Purchase order, Credit Memo, Vendor Payment, and Statements
Proposal summary This proposal covers the scope of the PDF template customization for Invoice, Purchase order, Sales credit note, Vendor Payment, and Statement Requirement The Requirement is to create Advanced PDF templates for Invoice, Purchase order, Sales credit note, Vendor Payment, and Statement Our Solution We had gone through the field mapping you provided and… Continue reading Proposal For Activ PDF’s – Invoice, Purchase order, Credit Memo, Vendor Payment, and Statements
Automatic Deletion of files from File Cabinet Using Celigo Flow
A. Create an import Open Flow builder, and click + to add a new destination or lookup to the flow. Choose NetSuite for the application. Edit the Create destination/lookup settings as follows: What would you like to do? – Choose Import records into destination application Connection – Select an existing NetSuite connection to accept or edit it, or click + to add a new one Would you… Continue reading Automatic Deletion of files from File Cabinet Using Celigo Flow
Dropship Purchase Order Form
For making the Dropship purchase order form preferred, we had to do the following Go to Setup –> Accounting –> Accounting preferences, Click the Order management option at the top. In it under the Drop shipments and Special Order settings, there is an option to set the form for Dropship PO. When a Dropship purchase… Continue reading Dropship Purchase Order Form
REQUEST READ RECEIPT
The read receipt functionality in Netsuite also depends on some of the email settings of the sender and recipient. On the recipient side, the read receipt functionality should be enabled, then only the request to acquire the read receipt will reach the recipient side. This read receipt should be accepted by the recipient. Then only… Continue reading REQUEST READ RECEIPT
Item Grouping in PDF based on the Estimate customer in the Item line
Grouping based on Estimate customer in which we don’t print discount lines. The discount amount and tax will be deducted from the item to which the discount item is associated with Grouping based on Estimate customer and also printing the discount lines. For that first, we added the Estimate customer name in a long text… Continue reading Item Grouping in PDF based on the Estimate customer in the Item line
Mapping in Celigo
There are four types of mapping in Celigo. Standard Hard – Coded Lookup Multi – Field Standard field mapping This is the default setting, indicating that data found in a specific field in the export should map to its corollary in the import application (1:1 direct mapping). Hard – Code Field Mapping Use this setting… Continue reading Mapping in Celigo