The below function can be used to convert a date value to format YYYYMMDD. function (inputDate) { // convert to YYYYMMDD var date = new Date(inputDate); var d = date.getDate(); var m = date.getMonth() + 1; var y = date.getFullYear() var dateString = (y+(m <= 9 ? ‘0’ + m : m)+(d <= 9 ?… Continue reading Convert date to format YYYYMMDD
Author: Aishwarya M J
Upgrade Integration App Edition
The editions available for pre-built Shopify-NetSuite Integration App are: Starter Standard Premium The set of flows available in each edition are different. In order to upgrade from starter to standard or premium edition of the integration app, you can click the “Request Upgrade” option available under the Subscription section on the Integration App settings page.… Continue reading Upgrade Integration App Edition
Send XML files to SFTP server
This script summarizes on creating XML files for Purchase Orders and save to an SFTP server. A saved search is used to find the Purchase Orders to be send. The passGUID and hostkey mentioned in the below code should be generated using the SFTP helper tools suitelet.
Manually Sync Amazon settlement report to NetSuite
There are chances that the Settlement report got missed to be processed by the Celigo flow. Then we have to upload the settlement report manually and run the flow which will create the settlement transactions in NetSuite. Login into the Amazon seller central account and download the settlement report in Flat file v2 format. In… Continue reading Manually Sync Amazon settlement report to NetSuite
Shipping Items for multiple subsidiaries
In NetSuite One World it is not possible to associate a shipping item with more than one subsidiary. The suggested solution is you can create multiple shipping items for the same shipping service. You can then use the shipping services across multiple subsidiaries. The shipping services respect currencies and post to the appropriate subsidiary accounts.… Continue reading Shipping Items for multiple subsidiaries
Resolve error: “Please enter a value for Tax Code”
The error “Please enter a value for Tax Code” is encountered when entering the Item lines in a transaction. The error is caused due to Tax code is auto populated in the Item lines. This can be resolved by enabling a tax preference as follows: Setup > Accounting > setup taxes >select corresponding subsidiary >… Continue reading Resolve error: “Please enter a value for Tax Code”
Proposal For Custom Page to Update Ship Date in Sales Orders
RequirementMarshall Electronics would like to develop a Custom page to update the line level Ship date in Salesorder Item lines in bulk.Our SolutionThe requirement can be achieved by creating Custom page using Suite script.The page will have the following user input fields: Sales Order# (text field) PO # (text field) Ship date (date field)Initially all… Continue reading Proposal For Custom Page to Update Ship Date in Sales Orders
Advanced Pdf code to Print Package Description in Packing slip
The Package content description in the Item fulfillment record can be printed in Packing slip as follows.
Ship bob to NetSuite Integration using Celigo
Requirement The requirement is to integrate the 3PL Ship Bob with NetSuite using Celigo. Our Solution Prerequisites NetSuite account (Sandbox and Production) with administrator permissions. Access to Celigo integrator.io Access to Ship Bob (Sandbox and Production) Description of the task A.Setup Connection NetSuite Connection: The pre-built NetSuite connector in Celigo can be used to create… Continue reading Ship bob to NetSuite Integration using Celigo
Proposal for custom page to Reverse Cost in transactions by creating Journal Entry
Proposal Summary This proposal covers the scope of Custom Page to Reverse Cost in transactions by creating a Journal entry. Requirement Client would like to develop a Custom page that list the transactions based on selected criteria and create a Journal Entry to reverse the transaction costs. Our Solution The requirement can be achieved by… Continue reading Proposal for custom page to Reverse Cost in transactions by creating Journal Entry