Scenario
There is no field on the Vendor Bill record that gives the information on when a vendor bill is fully paid directly on the UI.
Solution
On a Vendor bill record, if you click on the Related Records tab, under the Payments sub tab you will see the link to the bill payments that have been applied to set the status of the Bill to Paid in Full. The date when the bill is paid in full is the link that has the latest date. The Related Records tab is available on Standard Vendor Bill form. If you use a custom form, please ensure to have this sub tab enabled on the form.
This date when a vendor bill is paid in full can be retrieved by using dateclosed field on the saved search where transaction type is vendor bill. In order to use dateclosed field:
1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Select Transaction as Search Type
3. Under the Criteria Tab > Standard subtab, add the following filters:
- Type = is Vendor Bill
- Main Line = is True (Yes)
- Date Closed
5. Click Save & Run/Preview