CSV import > Error: You have attempted an invalid sublist or line item operation. You are either trying to cannot access a field on a non-existent line or you are trying to add or remove lines from a static sublist.

1. User is trying to add another vendor and purchase price on the item record. User has already one vendor listed on the item record and needs to add another one.

 

2. On the CSV file he has the Internal ID of the item, Vendor and Vendor Purchase Price.

3. Navigate to Setup > Import/Export > Import CSV Records.

-Record Type = Items

-Import Type = Inventory Items

-Select the CSV file

-Next

-Data Handling = Update

-Next

-On the Field Mapping:

-Internal ID = Internal ID

-Vendor = Vendors 2 : Vendor

-Vendor Purchase Price = Vendors 2 : Purchase Price

-Next

-Enter an Import Map Name

-Save and Run

Actual Result: Error: You have attempted an invalid sublist or line item operation. You are either trying to cannot access a field on a non-existent line or you are trying to add or remove lines from a static sublist.

To resolve, you need to map the Vendor name and the Vendor Purchase Price to Vendors 1 : Vendor and Vendor Purchase Price to Vendors 1 : Purchase Price or to the Vendor 1 folder.

Note: This will not replace the vendor already in the Item record as long as Overwrite sublist checkbox is not checked on the Advanced Options portlet.