Tuesday, December 11, 2018

Saved Search For Invoices With Related Payment Transactions

1. Navigate to Reports > Saved Searches > All Saved Searches  > New

2. Click Transaction.

3. Modify Search Title.

4. On the Criteria tab > Standard subtab > Set the following Filters:
- Type is Invoice
- Main Line is true
- Paying Transaction > none of > -None-


5. On the Results tab > Columns subtab > the following Fields are suggested:
- Date
- Document Number
- Name
- Amount
- Paying Transaction
- Paying Amount

6. Save & Run.

Note: Applying Transaction and Applying Transactions: Amount fields may also be used. Function for Applying Transaction: Amount should be set to Absolute value since payment amount is shown negative.

No comments:

Post a Comment