CSV Import > Vendor Payment > You are attempting to link transaction line items, but items on the lines do not match

Solution:

This occurs when an additional column has been added on the CSV file containing a Line ID. This has been mapped with the NetSuite field Bills : Line.

The file may look like this:

External Id |      Date      |    Payee    |   Bill |   Account   | Amount | Line Id

ABC123     | 3/14/2012  |  Vendor 1 |    10  |  Checking  |  100       | 1

 

When doing an import to add new Vendor Payment, the fields included in the CSV file as well as the Field Mapping page are (but not limited to): External Id, Date, Payee, Internal Id of the Bill, Amount, and Account. It is unnecessary to add another column on the file which is the Line Id.

1.Remove the extra column on the CSV file for the Line Id. Save the file.

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

--Import type = Transactions

--Record Type = Vendor Payment

--Click the Select button and upload the CSV file

--Click Next

3. Data Handling = Add. Click Next.

4.Map the fields. Click Next.

5.Enter an import map name. Click Save and Run.

Note:Result shows that the import is now successful.