Update Line Items in Estimates through CSV Import

To accomplish this in NetSuite perform the following steps:

1. Login to your account as the Administrator
2. Navigate to Setup > Import/Export > Import CSV Records > Import Type = Transactions > Record Type = Estimate > One file to upload = T > click Next
3. Data Handling = Update > click Next
4. Field Mapping:

- Name <=> Customer:Job
- *Proposal <=> Status
- Internal ID <=> Internal ID
--- Internal ID of the Estimate
- Date <=> Date
- Amount <=> Items: Amount
- Amount (FC) <=> Items: Gross Amount
- **Item <=> Items: Item
- ***2 <=> Items: Line ID
- Click Next > Enter a map name
- Click Save & Run

Actual Result: Estimate update retaining the old but 2nd line item was replaced with the new Item indicated in my CSV file.

* - Click on the Pencil icon and select the status of your Lead/Prospect/Customer
** - Click on the Pencil icon and select Internal ID.  Please note that in your CSV file, we should also use Internal ID of the Item
*** - Click on the Pencil icon and enter the Line Number of the Item that you want to update.  If there are 5 items in the Estimate and you want to update Line Item #3 then click the Pencil icon and enter #3