[jokell]

I’m currently trying to import my open purchase orders from my legacy system before I go live in a couple of weeks. The problem I’m having is that no matter what I do, I get the following error on my test imports:

Invalid entity reference key 508297.

The number changes based on the line, but the error remains the same. The number in the above example is the ID of the vendor that the purchase order will be tied to. However, on that import the External ID was mapped to the Order Number, NOT to the vendor ID.

Any help with what I’m doing wrong here? Thanks!
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

RE: Invalid entity reference key on Purchase Order import

What is 508297? Is is the Netsuite sequential vendor ID, the internal id or the extenal id?

[jokell]

508297 is the Netsuite sequential vendor ID.

[Olivier Gagnon NC]

RE: Invalid entity reference key on Purchase Order import

Most likely NS expect the full ID, including the name. Try putting the vendor’s name as well and see if that works. Alternatively, if you’re able to import using Internal ID or External ID, I would recommend that. Much simpler.

[jokell]

I’d like to use External ID, but the purchase order still needs to be assigned to a vendor (we can’t put in a purchase order to nobody).

But I may be a bit confused on the External ID bit – I was thinking that could be the purchase order number from our legacy system. But when I try to set that as the External ID the import fails with the same error above.

[Olivier Gagnon NC]

RE: Invalid entity reference key on Purchase Order import

Assinging an External ID to your POs is indeed a very good idea, but I was talking about referencing the Vendor by external id. The problem is NS is failing ti recognize which Vendor exactly you’re talking about. Specifying the Vendor’s external id (or internal id) in the field would be more effective

[Author]

Posts