You’re offline. This is a read only version of the page.
Announcements
35
Hi All:
I have an account that I cannot connect to the Envestnet Yodlee service, and have attempted to define a CSV file import. I created the Data Exchange Definitions, and completed the Bank Export/Import Setup. I also assigned the format to the Bank account.
However when I use the payment reconciliation journal, and create a new journal - when I select the account I want to import into, and run "Import Bank Transactions" I am receiving this error:
Ext. Data Handling Codeunit must have a value in Data Exch. Def: Code=BANKSTMTCSV. It cannot be zero or empty.
However, when I navigate to the settings in Bank Export/Import that column is not empty?
I am not sure if I am looking in the wrong place to correct this but if someone could direct me I'd appreciate it.
Thanks,
John
Josh and Steve: thank you both for the assistance on this. This ended up being the definition that worked for me, at least based on the column format in my .csv file. I'll work on the assumption that "m" is used for minutes or some other value and that is why "M" could not be used here. Otherwise this seems like a cruel joke :)
Be well,
John
Josh, I just realized your instruction was to have the Date format with a capital "MM". I googled the error message itself and found this note on another thread which is what you suggested. I am going to give this a try in a few hours, i have to move to something else for a moment.
Hi Guys, unfortunately no luck, although now a different format error.
Josh, this is the setting I have on the Column Definitions, which I think is where you mean? I also updated The Field Mappings column
When I attempt import with the file I get the following:
The .csv file I have is formatted as such:
I also tried converting data to columns, so the values were straight text, but when I do that, and try to import I receive the following. Steve I received the same error using the Data Definition and Sample File you shared.
John,
I saw Josh replied to the error and Data format definition. Did this work?
Steve
Hi Steve, I battled with this more today. I did use your Data Exchange and sample import file, but I get this error when I try to run the import.
What I did instead is create a new exchange, and use what you sent as a base. Here are my settings, if you see anything that is off. I was unable to get the two columns to perform and just went with a single transaction column. The file loads fine, and your suggestion on the field mapping solved the issue with the amounts.
The issue I have now is I can't get the Transaction date to read properly. I've tried formatting it but it still comes through as all January transactions.
This is what I get when I import:
This is what the file looks like (I removed the description in the image). The dates seem to be in the correct format, I have no idea why they are being created to January.
Many thanks,
John
John,
I leave my export from the Bank separated into a Debit and Credit Column and the Data Exchange Import resolves this. This is part of the file I sent over. Make sure the Field mapping, on the Detail, is pointing to the fields correctly. They should be. Look at Statement Amount column. In your pic you are showing Transaction Amount column. I think this is the difference.
Thanks,
Steve
Hi Steve, sorry late in reply. I was traveling the past few days. I imported your data exchange and am now able to import the data successfully. So this is great.
The only thing I noticed is that BC seems to need a single transaction field. When I export my data from the bank, it lists the debits and credits as separate columns. I can concatenate them into a single column but was wondering if BC could just handle the separated columns.
The highlighted rows below are actually debits that are coming through as zero, which leads me to believe the transaction field in BC is mapped only to the credit column in the excel file.
Here is the excel file:
This is getting off the original topic but if you've any ideas I'd appreciate them. We are deploying BC, previously had Quickbooks.
Thanks,
John
John,
Below is a link to a Data Exchange. I setup your layout and used an Excel template to confirm import (also attaching). Try Import the Data Exchange Definition and use the attached excel to import some test transactions.
Also, make sure you setup the Bank Export/Import Setup for the new Data Exchange Definition. Here is the screen shot for my setup below:
Data Exchange = https://1drv.ms/u/s!AmRbkPn9LCQZnkhjUvcHKDzzMDkC?e=rkYOUo
Excel Template = https://1drv.ms/u/s!AmRbkPn9LCQZnknDCHE_uTex2fqD?e=szOO7t
Hope this resolves evereything.
Steve
Hi Steve, Happy New Year and thanks for the response. The account I need the transactions from is outside of the US and CAN which is why I am setting up the import. I do have the Yodlee extension installed and running, I have our US accounts set up.
I plan to create a new Data Extension from scratch. I tired removing the header line from my file, but experienced the same behavior.
If you are able to share the data exchange definition that would be helpful. I am assuming I have something set not properly that is causing the issue, but unfortunately not throwing an error in BC.
My csv file is a simple one with only 4 columns. Date, Description and then the debit and credit.
Thanks,
John
#1
André Arnaud de Cal...
294,099
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
