CSV Import of an Invoice generates the CSV Response of 'You must enter at least one line item for this transaction'

On the CSV import of a new invoice the CSV response error 'You must enter at least one line item for this transaction' is received if a default value was provided to the Items : Item (Req) NetSuite field in the Field Mapping page of the Import Assistant.

For the CSV import of an invoice having a single item, it must be referenced in the CSV file as a separate column.
 

1.      Navigate to Setup > Import/Export > Import CSV Records (or if you are using Saved CSV Import go to Setup > Import/Export > Saved CSV Import > select the Saved Import).

2.      Select Transaction in the Import Type.

3.      Select Invoice in the Record Type.

4.      Select the CSV File.

5.      Click Next.

6.      Click Add in the Data Handling then click Next.

7.      In the Field Mapping page, please map the following fields:
Customer         =     Customer (Req)
External ID       =     External ID
Location           =     Location (Req)
Date                 =    Date (Req)
Item                 =     Items : Item (Req)

 

8.      Click Next.

9.      Click Run.