Create a Saved Search to show Bill Payment with the corresponding Bill and PO
Published on
January 18, 2024 at 10:16:03 PM PST January 18, 2024 at 10:16:03 PM PSTth, January 18, 2024 at 10:16:03 PM PST
Scenario
If a user wants to track all Bill Payments created with the corresponding column for the Bill and Amount where this was applied, and down to the corresponding Purchase Orders, then the user can create this Saved Search:
Solution
1.Navigate to Reports > Saved Searches > All Saved Searches > New
2.Select Search Type > Transaction
Under the Criteria Tab: > Standard
a.Add Type is Bill Payment
b.Add Main Line is No
On The Results Tab:
a.Add Date (Custom Label = Date Paid)
b.Add Paid Transaction (Custom Label = Bill Number)
c.Add Paid Transaction Fields Created From (Custom Label = PO Number)
d.Add Paid Amount (Custom Label = Amount Paid)
e.Add Document Number (Custom Label = Check Number)
f.Add Name (Custom Label = Payee)
g.Provide Search Title.
3.Hit Save and Run
Note:Using Amount Paid instead of Paid Amount will not show the correct value if a Bill was paid bymultiple Bill Payments. This is because Paid Amount will show how much the current Bill Payment hasbeen applied for the Bill while the Amount Paid will show how much the Bill has already been paid for theaggregate of all Bill Payment associated with it.