I have for only 1 vendor bills open while they have been paid
Hi, I have open bills in Vendor Open Balance and Unpaid Bills Detail. In Vendor Open Balance there are no amounts in the column Open balance, only in amount. In the Unpaid Bills detail the bills show up but have no amounts in the Open Balance column. In know that these bills have been paid because they are automatically deducted from our bank account. When I open the bill in the Vendors screen there is no PAID stamp on them. On the main screen that shows all bills there is no amount in the open balance column.
On the other hand, you may run and customize a QuickReport to check the payment transaction and link it with the open bill. It's possible that the payment was not properly link when recording it to pay the bill.
Go to the Lists menu.
Select Chart of Accounts.
Click the drop-down for Reports, and choose QuickReport: Account name.
Set the date range.
Click the Customize Report button.
Under Filters, search Transaction Type, and you can select Payment only.
Search and filter Account.
To open any of the transactions listed, double-click the transaction entry in the report.
Additionally, you can go to the Vendor Center and open the vendor payment. Then, press Ctrl + H on your keyboard to show the transactions linked to the payment.
That's it! This should help you link the bill to the vendor payment so it won't show on the Unpaid Bills Detail report. If there's anything else you need, drop a reply below. I'll be happy to answer. Have a great weekend!