Tuesday, July 16, 2019

Find the Date when Vendor Bill is Fully Paid

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.

1) 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.

2) 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:

- Navigate to Reports > Saved Searches > All Saved Searches > New

- Select Transaction link

-  Set the following under Criteria Tab > Standard Subtab:

         Type =Vendor Bill


Under Results Tab > Columns Subtab, add following fields(choose other based on your preference)

               - dateclosed.



No comments:

Post a Comment