[MG2016]

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.

[MG2016]

Anyone imported vendor bills payment before?

[MikeBucklaew]

I import customer payments all the time. I actually use the two file import method. I link them using the customer column. Should be very similar to what you’re doing. screen shots of my csv and mapping. If the bill is already paid I think you’ll get the error you describe. You’ll notice that i don’t reference the line field at all.

[sjb343]

MG2016, did you ever get this working? I have the same problem. I’ve tried multiple ways but always get this error. Any help is appreciated!

[pmjeffrey]

Agree with MikeBucklawe. Typically when I see this error it’s because one of the bills is already paid. If you validate that absolutely 100% of the bills on your import file are still open, and that the amount you are applying is not greater than the unpaid amount on the bill, you have a defect. Otherwise you have a data issue. My experience has been the latter.

[Author]

Posts