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?
Unfortunately, it can take quite a while to fix since we have already been waiting for more than six months (after the Plaid API changed) without any updates. Very unfortunate that we have to wait such a long time while there are some PR’s provided to fix this.
Looks like this finally got fixed. Now it seems to only pull this month. Is there a way to get all past transactions pulled? I only need to do this once vs importing them.
I started setting up my plaid account but it asking me questions about developing a application so I can use the API. Am I in the right area or did I go down a wrong path?
Yes, they will ask you a lot of questions. They are wanting to know the security of your runtime environment. They will review your request once you have all the answers entered.
I have the Pay As You Go plan, Basically, you setup an app profile for ERPNext. I have AUTH, BALANCE, IDENTITY, and TRANSACTIONS products selected. Not sure if you need all of those, but it is working as I need.
You need to setup the Link Customization to match your needs.
Under Developers, you will find the keys you will need for ERPNext setup.
Once the ERPNext code was updated to cover the API changes, it was easy. Plaid is changing the API again, I just hope ERPNext keeps up and this access doesn’t drop.
Yes, they did the same with me. I actually talked to them. They basically said I couldn’t have an account for this. But the folks here cleared it up for me and showed how to “pay as you go”. You can see the conversation above. After the implementation change (needed to adjust to their API changes), it has been working well.
Talk to them or not, they are just trying to get you to purchase the more expensive tier plan. If I had to do it over, I wouldn’t talk to them.
