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
Unanswered

How to Settle Transactions with Matching Values in Dynamics 365?

(1) ShareShare
ReportReport
Posted on by Karen_Mendez 4
 

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... 287,696 Super User 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 4 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... 287,696 Super User 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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans