Sunday, January 20, 2019

Create a Saved Search to show Bill Payment with the corresponding Bill and PO

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:

  1. Navigate to Reports > Saved Searches > All Saved Searches > New
  2. Select Transaction
  3. Under the Criteria tab > Standard:
    - Add Type is Bill Payment  
    - Add Main Line is No
  4. On the Results tab:
    - Add Date (Custom Label = Date Paid)
    - Add Applied To Transaction (Custom Label = Bill Number)
    - Add Applied To Transaction FieldsCreated From (Custom Label = PO Number)
    - Add Paid Amount (Custom Label = Amount Paid)

    - Add Document Number (Custom Label = Check Number)
    - Add Name (Custom Label = Payee)
  5. Hit Save and Run

NOTE: Using Amount Paid instead of Paid Amount will not show the correct value if a Bill was paid by multiple Bill Payments. This is because Paid Amount will show how much the current Bill Payment has been applied for the Bill while the Amount Paid will show how much the Bill has already been paid for the aggregate of all Bill Payment associated with it.

No comments:

Post a Comment