Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Is it possible to manually import bank statements from CSV, TXT etc files? When the bank account has the databank conv I get the error "the expected data was not received from the webserver". When I make it Sepa, the error is "A Call to system.xml.xmldocument.load failed with this message: Data at the root level is invalid. Line 1, position 1". I tried making an exchange definition and then the import says "the request body is not set". So obviously I have something set wrong. Not sure what i'm doing anyway : P
Same issue, have you figured out the problem.
i followed these instructions and did it this way. However, when I import the bank statement, it always makes the date january, no matter the month i'm importing (playing catch up). So, i just go through the dates and change it to the right month. But other than that it worked.
I have had this problem before of the date filling as January. Go to Column definitions for Data Exchange Definition. Make sure Data Format has an uppercase M.
To explain, in my CSV file, date is formatted as 7/21/16... if I use data format of M/d/yy then the date will fill in correctly. If I use a data format of m/d/yy then the date will fill in wrong (January). Another example, if in my CSV file the date is shown as 21/7/16 (different culture) and I use data format of d/M/yy then date will fill in correctly. If I set data format as d/m/yy then it will fill in as January.
I have tested all of this.
I have been struggling with this for a few months now. This works!!! Thank you!
I change the M in M/d/yyyy to an uppercase and it worked. It stopped importing everything as January. That is the dumbest thing I have seen all day. Thanks for the info.
I have tried importing a bank statement CSV file, with more than 300 records. But when i import the file only 10 records are inserted in the bank reconciliation page. Could you help me out for such an issue.
Have been having the same issue and looking for a solution, thanks!
Business Applications communities