Importing NetSuite InventoryItem With Required Fields

Importing NetSuite InventoryItem With Required Fields

book

Article ID: KB0078628

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) -

Description

When creating a SalesOrder in NetSuite, NetSuite requires at least one child record, such as InventoryItem. The TIBCO Scribe® Online Connector For NetSuite creates a fictitious InventoryItem in NetSuite to serve as the required child record on new SalesOrders until true InventoryItem records are added.  If your NetSuite organization has required fields for the InventoryItem child entity, the TIBCO Scribe® Online Connector for NetSuite cannot create this fictitious InventoryItem, preventing the creation of SalesOrders, nor can it create any other InventoryItems.  An error similar to the following is generated:
 
Source Entity:           Opportunity
Error title:             Error in calling
Error description:       Operation failed.  Label: Create NS Sales Order, Name: SalesOrderCreate, Message: [Code=USER_ERROR] Please choose an item to add
[Code=WARNING] Nonexistent externalId Scribe Online Item External Id for item

Issue/Introduction

NetSuite requires at least one child record, such as InventoryItem, when creating a SalesOrder.

Resolution

Import InventoryItems into NetSuite using a CSV file listing the fictitious TIBCO Scribe® Online InventoryItem and any other InventoryItems your organization needs.
 
  1. Create a CSV file as shown below:
kA332000000L122CAC_en_US_1_0
 
  1. The first line contains the NetSuite InventoryItem field names.
  2. The second line must be exactly as shown to fulfill the TIBCO Scribe® Online requirements.
  3. You can add any other InventoryItems you want to create in NetSuite.
  4. Once the CSV file is complete, log into NetSuite.
  5. Navigate to Setup > Import/Export > Import CSV records.
  6. Use the NetSuite Import Assistant to map any additional required NetSuite fields if they don't exist in the CSV file.
  7. The Item:Item Name/Number value must be [Scribe Online Item]

See the attached document for more detailed instructions: Importing Scribe Online Item.docx

For additional information about this Connector, see the following in the TIBCO Scribe® Online Help:     TIBCO Scribe® Online Connector For NetSuite
 

Attachments

Importing NetSuite InventoryItem With Required Fields get_app
Powered by Wolken Software