Notifications
Announcements
No record found.
Hello All,
We get a file from the bank that contains payment information from customers. We want to import that file into system and expect system to automatically select/pick the customers invoices to apply those payments.
Can anyone share steps for above scenario and also suggest how much D365 Finops can cover this as OOB functionality and what are the GAPs.
Hi Junaid,
In my implementations in Europe we usually used an add-on for this feature. Probably there might be some localizations which has more features, but I'm not aware of those. Can you tell for which country or countries you have this requirement?
It is up to your bankfile. Which format do you get bank files?
If it is in ISO20022 Camt054 format, you can use the standard config on Electronic reporting for Camt054 and link it to customer method of payment. It will match to customer transaction by payment id and invoice number and to the customer by name.
You can also use auto settlement where you can specify priority for settlement if payments don't have invoice references.
If payments have reference's then you can look at following approach and automate:
exploredynamics365.home.blog/.../
Hi Andre,
The requirement is from US based customer and We are also using 3rd party ISV solution for auto bank reconciliation and mainly BAI2 bank format is used here. The challenge is customer do not want to post payment until they receive a file from bank and expect system to post payment automatically and apply them as well against corresponding invoices based on mapping rules. Unfortunately I still didnt get the chance to discuss the full business case with customer. Will do that and get back to you with more details.
In your implementation that you are referring to, Was payment journal already posted before importing the bank file or not and system was just doing auto settlement with corresponding invoice based on standard matching rules like payment ID, Invoice, debtor/creditor name?
Hi Saurabh,
Thanks for the response. Yeah I'm quite aware of settlement priority option but the requirement is to create customer payment journals in sequential order once the customer get the file from bank (shud be automated process with no manual intervention)
I will wait till i receive further details from customer.
We have made such customization for one of our clients. We are pulling bank transactions with web API and importing them to a staging table. Then create a payment journal automatically with settlement functionality. Bank transactions are invoice based and the system use bank transactions description that contains invoiceId to settle the right invoice. You can settle your invoices with another option of course.
Best.
It is common in my area to import the bank file in a journal. Per transaction, if it is related to a customer payment, we try to match the lines with open transactions from customers. This is manually or we have to acquire an ISV solution for this. Once we completed the journal with correct information, we post it. Usually we don't use the bank reconciliation feature; only a general journal.
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 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
