Hello, I keep running into the "Invalid account re...
# csvimports
s
Hello, I keep running into the "Invalid account reference key "xxxx" for subsidiary x" error while trying to import a vendor bill. The subsidiary "x" in this case is active. The column headers on our company import template in use are: Transaction Date, Vendor Reference Key, Vendor ID, Currency, Amount, GL Account, Channel/Cost Center, Memo, Approver, Tax. Is there anything else I could check here?
k
have you tried using internal IDs instead of names (for GL accts, Channels, approver)?
s
i have tried using internal ids/external ids/names for GL account & vendor, but not channels and approver
i didn't think that channels or approve would trigger that error since neither field is referenced in the error message...is that not the case? i'll try now..
k
this is the most common error… . I always try to use internal IDs whenever possible. Without more details it is hard to tell what is off with your file 😞
d
Try checking if the account used on the vendor bill is inactive
s
@Karina thank you for the reply, this is also my least favorite error
Apologies for the late follow up, I was out sick most of last week..
I am at a company that has templates and saved imports previously in place using external IDs mostly. I am not sure why they went that route and have been trying to find more information on preference for external IDs over internal IDs
Only thing i can think of is maybe its more user friendly?
I made a new template using internal IDs + a few more fields, which works, but can't get their original to work
@DX thank you for reply, unfortunately everything is active so something else is causing the error
k
@SpecialistBison - it is like with 20.1 upgrade the old template does not function well any longer. Good luck to you on the import. let us know if this does not work with the internal IDs