Settlement View Of Vendor Transactions

(1) Share

Report

Posted on by D365_FO_Technical_Te

124

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?

I have the same question (0)

All responses (4)

Answers (0)

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Hi,

What do you mean by wrong values?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
D365_FO_Technical_Te 124 on at

Like (0)

Report

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 )

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Settlement View Of Vendor Transactions

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Settlement View Of Vendor Transactions

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates