I am wanting to import some legacy data into NetSuite. I can import Vendor Bill (expense line) records without any issues. Now, I want to import Vendor Bill Payment records but I am getting this error: Unable to find a matching line for sublist apply with key: [doc,line].
Since there is only one expense line Item I am mapping the 'Line' field with the value 0. I've tried using 1 too. I can;t see to get this import working. My excel data looks like this:
Internal ID
External ID
Payee
Date
Line
51687
1
1456
31/05/2016
0
Attached is a screen shop of my mapping. Any suggestions?
Thanks
This is a cached copy. Click here to see the original post.