Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / How to Settle Transact...
Finance forum
Answered

How to Settle Transactions with Matching Values in Dynamics 365?

(2) ShareShare
ReportReport
Posted on by Karen_Mendez 13
 

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.

Categories:
Financial Management
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 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 13 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... 290,277 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? 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,126 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans