Finance | Project Operations, Human Resources, ...

Vendor open transaction balance is greater than vendor actual liability

(0) Share

Report

Posted on by Sonali Rout

Hello Experts,

My vendor is having a balance of -54,660.450 which we are liable to pay.

Whereas; when we create a vendor payment journal for the same vendor and marked all open transactions for settlement; the total value for marked lines is showing in "Debit" column as 74,635.450.

I have compared all open transactions as available in the "Settle transactions" form in the vendor master with the open transactions as marked for settlement in the payment journal. And there is no difference.

Currently I am settling all open transactions for 2019 only.

7612.Capture.JPG

As we are aware of that; this -54,660.450 is the running balance of the vendor which means transactions from both 2019 and 2020 are there. But question is; my "Settlement balance" is showing 0.000 as you can see above. Which means there is no amount left for 2019 which is pending for settlement.

And open transactions so far recorded in this vendor in 2020 is only -2160.000

Can you please tell me what could be the reason for this?

Thanks and regards,

Sonali

I have the same question (0)

All responses (6)

Answers (0)

Sort by

André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Sonali,

Can you tell if for 2019 all vendor transactions are settled against payments, so you only selected the real open transactions? Is BHD your local currency? Or are these amounts in a foreign currency compared to your accounting currency?

Was this reply helpful? Yes No
Sonali Rout 70 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Thank you for the response.

Few transactions are already settled for 2019 which I can see in the "Undo settlement" form in vendor master.

BHD is the local currency. All transactions posted for this vendor in local currency BHD only.

Could you kindly clarify by "Real open transactions" as you mentioned! This is not clear to me unfortunately.

Thanks & regards,

Sonali

Was this reply helpful? Yes No
André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Sonali,

If you have many unsettled invoices and payments, then these are not really open. In that case, there might be a settlement marking already which could not be included in your current journal. Can you first try to use the vendor option to settle transactions and after that create a new payment journal and check the outcome? (Probably in a separate test environment first...)

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Sonali,

Can you run the vendor balance report - for all vendors - and compare it with the GL balance that you have on your vendor summary account?

Are those amounts identical?

If this is the case then check whether and what transactions of the vendor are already settled, as Andre mentioned.

You can run the vendor statement report for that purposes and/or open the vendor transactions for exporting and analyzing them (e.g. in Excel).

Example:

Best regards,

Ludwig

Was this reply helpful? Yes No
Sonali Rout 70 on at

Like (1)

Report
Copy link

Link copied!

Hi Ludwig and Andre,

Thank you for the explanation. I am currently checking this in UAT and will get back to you.

Thanks and regards,

Sonali

Was this reply helpful? Yes No
André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Sonali,

Were you already able to verify it? It would be great if you can keep us updated on the status.

Was this reply helpful? Yes No