Is there a way to import vendors and vendor bank accounts in a single job

(0) Share

Report

Posted on by OsmanIstanbul

2,781

Hi Experts

I have to migrate vendors for lots of legal entities and have a problem with vendor bank accounts. Vendors' data has a default bank account and vendor bank accounts have vendor account. I need a way to import them together. otherwise I have to import vendors without default bank account, import vendor bank accounts later, and update vendors again.

Any help is appreciated.

Categories:

Financial Management

All responses (2)

Answers (1)

OsmanIstanbul 2,781 on at

Like (0)

Report

RE: Is there a way to import vendors and vendor bank accounts in a single job

Thank you Andre, second option works for me.
Verified answer

André Arnaud de Cal... 283,860 Test role Public on at

Like (3)

Report

RE: Is there a way to import vendors and vendor bank accounts in a single job

Hi Osman,

You can improve this action in two ways:

1) Create a new data entity or extend the current vendors entity so it would be able to import the vendor together with a bank account. This would require development and testing before you would be able to import it.

2) Disable the validation on the default bank account field from the vendors entity. You can then import it with two steps: Vendors and bank accounts. It would save you from the action to import it again to update the default bank account. For this, you need to ensure you will not have incorrect values on the vendor default bank account.

To disable the field validation, go to System administration, Data management (workspace), Data entities (tile). Select the vendors entity and open the option Modify target mapping. You can then disable the option Call validate field method. This does not require development.