210
Hello everyone,
I'm testing the import of a vendor bank account using the VendVendorBankAccountEntity.
The process fails because of an error I don't understand:
I mean of course the value "is not found", it doesn't even exists for that Vendor: I want to create it by the entity import.
What am I missing?
Thanks for your help and kind regards to everyone!
Gian Paolo
Hi,
I had the same issue as well.
I even tried to disable validate field on staging field VENDORBANKACCOUNTID but it's the same failed result.
After trying couple times, I found out that in data entity VendVendorBankAccountEntity field ISDEFAULTBANKACCOUNT needs to be set as No.
It's allowing to import vendor bank account record.
Best Regards,
David Santoso
Hi Parab,
Yes the vendor already existed though I didn't create it by myself. I'm using a Demo environment to test some Data management workspace functions, so the vendor I wanted to create a bank account for was already within the vendor list.
Hi Andre,
The data entity was the Vendor bank accounts one. This is a print screen of the import project I created:
Now, I tried a couple of imports today (not for the same vendor, with different bank accounts data) and the upload worked successfully!
I'll dig deeper in the error I reported in my post, I still haven't figured out what cause may have triggered it.
Thank you for your suggestion.
Appreciated.
Gian Paolo
HI Gian ,
Are you sure you are specifying vendor account and vendor bank account correctly in the file? I used this entity in the past and data gets imported correctly if the vendors exist. what platform you are on ? I tested this in my new VM (8.0) and even if vendor does not exist I don't get any error and record is inserted in vendBankAccount table but no vendor is created . The reason behind it is vendtable datasource in this entity is set to Read only .
You have to do your import as a two step process . First import vendors and then Import their bank accounts
Hi Gian,
Are you sure that you are using the Vendor bank accounts entity here? To me, it looks like you try to import it in the Vendors entity. Can you verify it?
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
