web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to Settle Transact...
Finance | Project Operations, Human Resources, ...
Answered

How to Settle Transactions with Matching Values in Dynamics 365?

(2) ShareShare
ReportReport
Posted on by Karen_Mendez
 

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.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at
    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? 
  • Karen_Mendez Profile Picture
    Karen_Mendez on at
    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... 301,231 Super User 2025 Season 2 on at
    Thanks for the clarification, Karen. This requirement is not supported in the standard application. You might consider a customization.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans