Personalized Community is here!
Quickly customize your community to find the content you seek.
Now Available in Community - New TechTalk Videos for 2020
Read More about New TechTalks for 2020
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 1 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 there any way to upload a spreadsheet when settling transactions. For example, we would receive 30 page remittance advice from client who does not pay the statement balance so could be paying only 60 out of 100 invoices. Instead of manually clicking the invoices, is there any way we can upload a spreadsheet of this remittance to d365. Need help or idea to work around this please. Thanks.
There is no support to load details when settling transactions. This would be a customization. How do you currently post the customer payments?
If you get the remittance advice in an electronic format such as Excel or csv you could leverage MS Flow for the upload and settlement of the payments.
Yet, there are many things that must be provided in the remittance advice form and match the data in D365FO.
If you can ensure this, you can create a solution with MS Flow; otherwise you might need a customization for that.
Thank you for your reply. So we load the payments received in the payment journal (so we export the payment journal from d365 and load the necessary details via excel and publish this and then validate in d365) and then settle it per line which is ticking the boxes of the invoices as per remittance. It would be easier if they are paying as per statement as we can filter document dates/due dates. But for big remittances with a lot of invoices that are not as per statement balance due, it could be time consuming as we have to tick it one by one.
I was thinking if there is the same way as how we load the payments in payment journal for settling transactions.
Hi Dr. Ludwig
Thank you for your response. I am not an IT person so have not heard of the MS Flow so I will check this out and see. Cause i can prepare a csv file from the remittance advice but just needing the option to load this.
There is a button in the customer payment journal called "Import payments". It does exactly this: it imports payments and settles them against the original invoices. You can create an new ER format configuration akin to camt.05x and let it read your file, or you can convert the remittance advice into the ISO20022 standard.
Thank you. I will have a look into this.
Business Applications communities