Notifications
Announcements
No record found.
Hello,
I've just looked at a series of three very useful tutorials:
https://dynamicsax-fico.com//?s=electronic+reporting&search=Go
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
Kind regards,
AP
Hello AP,
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.
Best regards,
Ludwig
Hello Ludwig,
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.
Aymeric
Hi Aymeric,
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.
Dear Aymeric,
You can import customer/vendor payments using electronic reporting by using camt.054 format.
Check the below documentation:
docs.microsoft.com/.../emea-iso20022-file-formats
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.
Hello Mihaela,
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,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
