Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
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
I've just looked at a series of three very useful tutorials:
As I'm a real beginner with electronic reporting I’m wondering if we can use ER to import project invoice or at least customer invoice and related payment and settle them one another. I'm asking this to load data in a new environment without use a specific development to handle settlement between invoices and payment
Why is it that you want to import customer invoices or project invoices?
Don't you create them in D365FO?
ER can certainly help you with data imports but it might not be easy to configure compared to using the data management workspace.
Unless there is a specific situation that cannot be handled with the data management, I would think twice to go with ER especially against the background that you just started with ER.
We create them in D365 but we have to process data migration from an old system. Usually we import them with DMF to generate a general journal. As we start in a current fiscal year we want to import both settled and non-settled transaction.
When I watched your webcast, I asked myself if ER wasn't more powerful? He may allow us to import project invoice and related payment and settle them.
ER is more powerful in my opinion but also more complex and if you just started having a look at ER, it will take you a long time to make this work.
Irrespective of that, I have a question about your approach:
For data migration, the project module has a special 'beginning balance' journal. You can easily import transactions there that don't affect GL. That is, things (transactions) that you want to invoice later on can be imported into this journal with the different posting / transaction types and recorded. If this is done then you can create the project invoice with the standard project invoice features in project management and accounting and you don't have to use a kind of GL journal for that. Have you considered making use of this option? To me this sounds the better approach. Probably have a look at this in a demo/test environment and give it a try.
You can import customer/vendor payments using electronic reporting by using camt.054 format.
Check the below documentation:
For customer payments, you can also settle payments by different criteria (paymentID, customer name, customer bank account). Basically the bank provides you the XML file in camt054 format and you can setup to import this file.
Or you can create your own import format to accept XML file but you need to built your model, model mapping and import format similar to camt054 for example. This requires some customization and knowledge on electronic reporting topic :)
Let me know if you need any other information and I will be more than happy to assist further.
My data are not coming from a bank statement because we are processing data transfer from a previous system (not AX) to D365. As a result my source is not an ISO20022 input.
The old system will give me a list of invoices and payments related one another. What I have to do is to import them when we will start to use D365.
Currently what I plan to do is to import invoices and payments by general ledger using DMF. What I am looking for is a way of settle them that's why I asked if there is a way out thanks to ER.
Thank you for your reply,
Business Applications communities