Hi, I have a question. Does anyone know why I get " no reference key" error when importing a csv file? I am trying to import data to a custom record. This custom record is linked to a Vendor. so I put vendor name as a key,, but the error says it can't find a vendor key.

are you mapping the vendor by name, external or internal id? Is it all vendors that fail, or only some? Maybe the vendor's inactive, or some filtering on the custom record's vendor field excludes them.

Hi, David! it worked when I mapped vendor by internal ID. Why doesn't it work when I map by vendor name..?

I don't really know. I normally map by internal id because I find it more reliable than mapping by name. It could be that the name is slightly off? (like trailing spaces either in the CSV or the vendor name in NS)

I see! I'll also try to map by internal id from next time 🙂 Thanks a lot !!

(appreciate you already have it working so this is probably not of much interest to you but for future reference) Did you make sure on the original mapping that on the vendor column you specified name rather than internal id? Otherwise it would (potentially) have been trying to use the name you supplied thinking it was an internalid which, of course, would be invalid.

Hi, NElliott! I think I did specify name on the vendor column.. hmm but I might have not! I will keep that in mind 🙂 I'm pretty new to netsuite. So this is really helpful, thank you so much !!