Trying to do a journal entry CSV import and keep receiving this error "Invalid account reference key "1000" for subsidiary 1." . Nothing online seems to point to the right solution. I thought it might be because the "include children" box was not checked (this has fixed this error in the past) however I cannot click that box on this account as its a bank account. Any ideas?

I believe you need the name of the account# as well. Example: 1000 Wells Fargo Bank or whatever it may be

Hi Jordan, thanks for the reply! I'm using external ID to reference the accounts so it wont be pulling a name anywhere. The bank account I selected is apart of the subsidiary I'm setting as the default value. I only have one subsidiary for this organization.

I guess without seeing how you are mapping it's hard to tell. Answer ID 10005 shows what requirements you need for it. I'd think you would need to map Journal Entry - Line to the 'Account' as I mentioned above 1000 Wells Fargo Bank.

ns account is the external ID Covered line is the only subsidary in this org debit and credit import are the net differences for the trial balances im importing by JE

external id is different from the account number. Here is a video that might help explain it

@Ashlin, what is the currency of the bank account, the subsidiary and the journal entry? The bank account currency must match either the subsidiary's base currency OR the journal entry currency. (Assuming your reference types are correct, this may be another thing to check)

All are USD @Luis

Simply put. You get this error when there is a mismatch between the subsidiary specified by the account. If this is for a cash account, you are trying to post a JE line for subsidiary A's account to Subsidiary B

@Ashlin you can only select 1 subsidiary per bank account. what is the subsidiary selected on this Account and does it match the subsidiary you are setting on your JE?

Hello! Thats where I'm confused as there is only one subsidiary available in my account. So I can only choose one subsidiary. Chose the same sub (only one available) for both the account and the mapping.

oh i see. So you column ns account in your CSV file the value is the external ID of the account?

@AI1 gotcha, let me try out your method above and ill see what happens. Will report back findings soon. Thanks!

In my experience, the fact that the key is in quotes ("1000") indicates that you need to update the pencil icon to map the import based on the external ID. The quotes usually means you are trying to update the field based on the Name, which is the NetSuite default.

Hi @Paul Giese I did make that mistake before so I used the pencil icon to change it to external id before submitting and receiving this error so unfortunately that wasnt the problem on this one.