Import – Page 2 – knowledgebase JJ

Unexpected error on item import

There are some scenarios which shows unexpected errors while doing item import. Some of the cases are, Item Name field and the Store Display Name field are mapped. You must map only the Item Name field or the Store Display Name field. Ensure that the Item Translation : Language field is also mapped.

Import Sub customer to a parent customer

We can create a new customer as a parent just with the company name, and we can make those customers as parents on creating the sub-customer, and the transactions of sub-customers will reflect the same format as “Master customer Name: Sub-customer Name“. Import file used Sub customernInternal ID parent company 42332 68623 CSX **Master Account***… Continue reading Import Sub customer to a parent customer

Import custom List in netsuite

Chart of account CSV Import

To import the chart of accounts into the new accounts go to Setup -> Import/Export -> Import CSV records. Set ‘Import Type’ as Accounting. Set Record Type – Chart of accounts. Set Character Encoding – Western (Windows 1252). Set CSV column Delimiter – Comma. Select CSV file(s) as ‘One File To Upload’. Then select the… Continue reading Chart of account CSV Import

List of items not having any commerce category

Through the direct item search we will not get the expected result.So we can create an item search and category search in NetSuite. Item search: Criteria can be blank , select name under the result.From this search we will get all items in NetSuite Commerce category search: Criteria can be blank, Select item name/number under… Continue reading List of items not having any commerce category

Bank Reconciliation Import Template For matching data with Netsuite and Bank

Template file used for importing the bank reconciliation data. Date (MM/DD/YYYY Payer/Payee Name Transaction ID Transaction Type Amount Memo NS Internal Customer ID NS Customer Name Invoice Number(s) date in the format*mandatory Name of payer*mandatory Transaction id *mandatory Type of transaction Eg: DEPOSIT*mandatory Amount*mandatory *Not Mandatory *Not Mandatory *Not Mandatory *Not Mandatory

Import Income Accounts

Scenario:- We have to import accounts with type income.For one account, there should be two subsidiaries. For the other one there should be three . And this account will be the child account of the first one. While adding more than one subsidiary to a account through import we can use ‘|’ for separation HEADQUARTERS… Continue reading Import Income Accounts

Error in Account Import

While importing the account of type income we get a following error This is because ,the account name we trying to use is already exists. We have to rename the newly importing account.

Workbook for SuiteCommerce Analytics Data – Backup data before category/item CSV import

Go to Analytics > Workbooks tab. Click New Workbook. Click New Dataset. If you already have a dataset, you can click the Dataset Name instead of creating a new dataset. Select a record type to analyze. The search bar is helpful for locating a record type. To search, enter any word or character from the record type name. No… Continue reading Workbook for SuiteCommerce Analytics Data – Backup data before category/item CSV import

Excel Functions Used In CSV Import

We have to use various excel functions for importing such as Text functions ,Lookup functions ,Date and Time functions, If and related functions etc Note: In Excel we can use FORMULATEXT() function to know the functions that we have used in each cells. a) Right function is used to extracts a given number of characters… Continue reading Excel Functions Used In CSV Import