Hi all! I've got an end user who is trying to do a CSV import of vendor bill payments and getting an error that account 1030 does not exist for subidiary 8. When I check, that account number does exist on that sub, so I assume it must need to be formatted in some other way. I've tried account name, account number and account name, and account hierarchy as it appears in NetSuite. I'm stumped, what format does it expect it to be in?

What are they using to map to the account? Internal ID? External ID? Name?

When in doubt, I do two things: 1. Use the UI to see if that combo is available 2. Import the CSV using internal ids as references.

account number. It is available in the UI when I try the same. I'll try internal ID.

I'd recommend using Internal ID as a general rule anywhere you can in all CSV imports. It's way too easy for random/stray characters to get into names

Invalid account reference key "227" for subsidiary 8.

Is the account inactive?

It's active

And you selected that little pencil and picked "Internal ID" as the reference type when you mapped?

Oooh no I did not