Tag: Import

Resolve Error: “You have entered an Invalid Field Value xx for the following field: expenselimit” when Importing Employees

Scenario When user is trying to import Employees, they received an error “You have entered an Invalid Field Value enter Period xx for the following field: expenselimit”. Solution This error is received when the system detects that the Expense Limit column have different format set in the CSV file. To resolve this error: Edit the… Continue reading Resolve Error: “You have entered an Invalid Field Value xx for the following field: expenselimit” when Importing Employees

Setting Multiple Transaction Currencies for Customers Import

The Multiple Currencies feature enables us to enter sales transactions in multiple currencies for individual customers. When this feature is enabled, you can define a primary currency for customers by including the Currency body field in your CSV file and mapping it in the Import Assistant, exactly as you would without the feature enabled. However,… Continue reading Setting Multiple Transaction Currencies for Customers Import

Importing NetSuite Access Details for Customer Contacts

For Customers Only imports that update existing records, the Field Mapping page includes a Contact Access sublist. We can map this sublist’s fields to provide Customer Center access to contacts. Sublist fields include: Access – Boolean indicating whether to grant NetSuite access to the contact Contact – Contact name used the key for the sublist… Continue reading Importing NetSuite Access Details for Customer Contacts

What is the preferred order for importing data into NetSuite?

The following order is preferred for data imports: Chart of Accounts Note that you should enter opening balances as journal entries on “go live”, using the specialized journal entry import process. Classifications Departments, Classes, Locations – supported by Import Assistant Entities Employees, Vendors, Partners, Customers (including Leads, Prospects, and Customers), Contacts – supported by Import… Continue reading What is the preferred order for importing data into NetSuite?

Inventory Worksheet Import Limitations

Each import can create one new inventory worksheet. You cannot use the inventory worksheet import to update an existing NetSuite inventory worksheet or to create multiple inventory worksheets at one time. Each inventory worksheet import can import data for one combination of class, department, location, and, if applicable, subsidiary values. You must do multiple import… Continue reading Inventory Worksheet Import Limitations

Error: “The total inventory detail quantity must be 1.” for CSV Import of Vendor Bill.

Scenario The system throws the error when the user imports Vendor Bill records through CSV Import. Solution Map the field Vendor Bill Items : Quantity in the Field Mapping page of the Import Assistant.  If this field is not mapped, the quantity defaults to 1. Any line that is more or less than the quantity 1 will cause the error.

Please select member items before submitting

When member items are created in a separate CSV file, there needs to be a linking column: Assembly Item: External ID, Internal ID or Name. When performing the import, ensure that the following options are specified: Import Type – enter Item Record Type – enter Assembly/BOM Item Click Multiple Files to Upload For Primary File – Item,… Continue reading Please select member items before submitting