Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

How to Settle Transactions with Matching Values in Dynamics 365?

(2) ShareShare
ReportReport
Posted on by
 

Here is the question translated into English for your Dynamics blog:


Question: How to Settle Transactions with Matching Values in Dynamics 365?

Hello everyone,

I have a question regarding the settlement of transactions in Dynamics 365.

I am managing the accounts payable for a vendor who has about 100 transactions, including payments and invoices. My goal is to settle them so that the values match exactly. For instance, if I have an invoice for 10,000, I want it to be automatically settled with a payment of 10,000, without the system trying to find values to match the settlements.

Is there a way in Dynamics 365 to automate this process of settling transactions with matching values? I would appreciate any guidance or best practices you can offer to handle this situation efficiently.

Thank you in advance for your help.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 Super User 2024 Season 2 on at
    How to Settle Transactions with Matching Values in Dynamics 365?
    Thanks for the clarification, Karen. This requirement is not supported in the standard application. You might consider a customization.
  • Karen_Mendez Profile Picture
    Karen_Mendez on at
    How to Settle Transactions with Matching Values in Dynamics 365?
    Hola André, 
     
    The transactions in question are not related to opening balances, nor do they represent the total transactions of the vendor. We are applying a specific filter when settling the transactions to manage a large volume of different values. It is important to note that we aim to prevent the automatic association of transactions that, although equal in sum, do not match exactly in amount. For example, we do not want a transaction of 20,000 to be automatically settled with two transactions of 10,000 each. We prefer that each transaction is matched and settled with another of the exact same value to maintain clarity and precision in our accounts and records.
     
    Thanks
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 Super User 2024 Season 2 on at
    How to Settle Transactions with Matching Values in Dynamics 365?
    Hi Karen,
     
    Can you provide the background of this question? Are there transactions related to opening balances? What is the current balance of this vendor? 

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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans