Sunday, March 24, 2019

Saved Search to Expose the vendor bill amount not matching the vendor bill payment amount


1. Navigate to Lists > Search > Saved Searches > New.

2. Click Transaction.

3. Enter a Search Title.

4. Under the Criteria tab, Standard subtab, set the following filter fields:
---Type = is Bill
---System Notes : Field = is Document Status
---System Notes : Old Value = is Paid In Full
---System Notes : New Value = is Open
---Status  = is Bill:Open
---Main Line = is true
---Paying Transaction : Type = is Bill Payment

5. In the Results tab, Columns subtab, set the following fields:
---Date
---Period
---Type
---Number
---Name
---Account
---Amount, Custom Label: Bill Amount
---Paying Transaction : Amount, Custom Label: Bill Payment Amount
---Paying Transaction : Type

6. Click Save & Run.

No comments:

Post a Comment