I am new to ERPNext and am trying to get things configured. I have a Frappe Cloud instance and I want to load bank transactions and found I can do this using the Plaid integration. Coming from Odoo, it was so simple. I just clicked to add my bank and it just worked. I am not experiencing that here. I get an invalid request error.
I have read through the integration and am told to add some settings to the site_config.json file. I think I have figured out how to add to the site configuration, but not sure what to put there.
Odoo uses Plaid to connect a bank without an account. Reading on some posts here, they talk about needing an account on Plaid (a video mentions it too). If you need an account there, what type of account?
So it appears Plaid is a no go now. I talked with them and from what I can gather, you need some expensive account.
Is there any other way to link a US bank and pull transactions? I want to go to an ERP to automate things and get away from manual importing of data. Is anyone in the US linking their bank transactions to ERPNext? If so, how?
Thanks to both of you! I was able to get through the Plaid sign up process and am able to get much further. My account settings look like yours @batonac, but instead of unlimited access shows 200 free. Everything else looks the same.
I can select my bank, which is more than I could do before, but I think there is still a configuration issue in Plaid as I get two errors when trying to get transactions. I see the errors in the Plaid developer’s logs.
The first is an Authorization Request:
Response Code - 400 Bad Request
Error Code - ADDITIONAL_CONSENT_REQUIRED
Error Type - INVALID_INPUT
Error Message - client does not have user consent to access the
PRODUCT_AUTH product
The other one is a Link Request:
Error Code - INVALID_LINK_CUSTOMIZATION
Error Type - INVALID_INPUT
At least one Data Transparency Messaging use case if require to be configured.
Please configure use case in the Data Transparency Messaging Link
Customization.
I have tried to configure the Link Customization Data Transparency and selected:
Verify your account
Track and manage your finances
Do business accounting and tax preparation
When linking a bank account to Plaid, I get the text message popup and a popup to select my Bank. After that, it just returns to the Plaid setup page.
You have to make sure you have selected the correct products at plaid.com. Since you stated the billing amount was unexpected, I have a feeling you’ve selected the wrong product.
I think I have the correct plan set up and the the correct products. When connecting the account, I think there should be another popup that allows me to login to my bank, but that doesn’t happen.
Are these settings correct? Until I added items here, it didn’t connect to my bank at all. That is why I think there is still a Plaid setting that I need set.
It appears that Plaid has been making some changes and has added Data Transparency to their Link configuration. This is enabled for all new accounts (like mine) since October this year (2024). Lucky me. I contacted Plaid and they have stated that the auth product is required along with transactions. Since auth is required for transactions, it needs to be added to the products array in the PlaidConnector class constructor.
Line 15 in plaid_connector.py needs to change from:
self.products = [“transactions”]
to
self.products = [“transactions”, “auth”]
I put in a bug ( #44802), but I am new to ERPNext and not sure how long it takes to get something like this done.
I am running on Frappe cloud. Is there a way can replace just the Plaid module and test this out?