vendor having zero balance to settle but it showing in open vendor invoice

(1) Share

Report

Posted on by Community Member

Hi Professionals,

we are facing an issue our vendors having ZERO amount to settle but still showing in vendor open invoice report.

in "settle open transaction" page showing a single line

how to solve this issue.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Khaled Alloud 3,658 on at

Like (1)

Report

RE: vendor having zero balance to settle but it showing in open vendor invoice

Hello,

We are facing the same issue with one Vendor and it is really strange.

The balance of the Vendor is updated, right?

Maybe you can hide them from DB by a developer.

regards,

Was this reply helpful? Yes No
Suggested answer

Syed Fasih 2,442 on at

Like (1)

Report

RE: vendor having zero balance to settle but it showing in open vendor invoice

It is possible that payment made is not tagged with the invoice. You may want to go to "Settle open transactions" on the vendor account and then mark the payment with invoice.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (2)

Report

RE: vendor having zero balance to settle but it showing in open vendor invoice

Hi,

Can it be the case that a $0 invoice has been created?

Can you find out more details by drilling into the original document?

Best regards

Ludwig

Was this reply helpful? Yes No
Suggested answer

Israel Gonzalez 733 on at

Like (3)

Report

RE: vendor having zero balance to settle but it showing in open vendor invoice

Hello, for Ajithkumar and Kaled.

It happens because there are decimals in the record that aren't zero. If you check the table in the database (CustTransOpen) you will see for example 0.00002 and that is the reason why appear in open transactions.

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (1)

Report

RE: vendor having zero balance to settle but it showing in open vendor invoice

Dears,

When i look at the invoices i don't find penny differences; however, the invoice has 2 lines and 1 of them has 0 amount. But what is appearing in the open vendor invoices form is the total amount of the invoice.

Thank you,

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (2)

Report

RE: vendor having zero balance to settle but it showing in open vendor invoice

Did you check the database table, I mean in SQL?

Was this reply helpful? Yes No