Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Settlement View Of Ven...
Finance | Project Operations, Human Resources, ...
Unanswered

Settlement View Of Vendor Transactions

(1) ShareShare
ReportReport
Posted on by D365_FO_Technical_Te 112
Hello everyone,
 
I have one requirement where i want to modify settlement View of Vendor's Transactions. can someone please tell me how can i achieve this functionality.
 
Path : Accounts Payable > Vendors > All Vendor > Transactions > View Settlement.
 
so, when we are opening this View Settlement form it is showing me wrong value in 4 Amount fields
1.) Amount Settled in Transaction Currency
2.) Amount Settled
3.) Amount in Reporting Currency
4.) Balance
 
I have 1 Custom Table, based on that table fields i have to do some calculation based on which data should come in this View Settlement form on posting Vendor Payment Journal.
 
Can anyone please suggest me where can i write the code?
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    Settlement View Of Vendor Transactions
    I'm not fully able to understand what exactly need to be done here. What is the purpose of the new custom table? It is about an outstanding balance for each vendor transaction? If so, the vendor transactions already have the details. 
    Can you share a screenshot of the View Settlements form how it should look like with your required customization? 
  • D365_FO_Technical_Te Profile Picture
    D365_FO_Technical_Te 112 on at
    Settlement View Of Vendor Transactions
    Hi,
     
    Sorry, it's not wrong value.
     
    Requirement is when I will post vendor payment journal , during that time I need to check my custom table - my custom table has 1 amount column and 1 invoice id column. 
    So, based on the invoice id which I have marked in vendor payment journal it should fetch my custom table (marked Invoice == customeTable.invoiceid).
     
    Then I have to deduct amount I'd (my custom table field which I have fetched from marked Invoice id) from the invoice amount. And then it should populate the records on View Settlement form i.e. deducted amount(invoice amount - custom Table's amount field )
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    Settlement View Of Vendor Transactions
    Hi,
     
    Can you please provide examples, so we can understand what you mean by wrong and what values you have in your custom table? Why do you think standard Dynamics is showing the wrong information? Are you sure your custom table has the correct data?
  • BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,784 Most Valuable Professional on at
    Settlement View Of Vendor Transactions
    Hi,
    What do you mean by wrong values?

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans