Usually, a Sales Order can be closed manually in the following ways: Click on the CLOSE button visible in the Sales Order Mark the CLOSED checkbox true in all the item lines. Besides the above mentioned a Sales Order get closed automatically when all the Item Quantities are set as 0. The Sales Order status… Continue reading Sales Order status set to Closed upon creation
Author: Aishwarya M J
Composite Method in HTTP import
Composite method imports records depending on the existence or absence of records in the destination application. Composite requests require you to define how to create new records, identify existing records, and update existing records. Different options available in Composite method are: Create new records & update existing records: dynamically create new records or update existing… Continue reading Composite Method in HTTP import
Convert date to format YYYYMMDD
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
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.