Friday, October 26, 2018

Transaction Saved Search to Display Invoices Paid via Credit cards and Include invoice date, number, invoice amount, payment date, payment method and amount paid

1. Navigate to Reports > Customer/Receivables > A/R Payment History by Invoice > Customize.

2. Under Edit Columns screen, work on the Payments By Invoice and Transaction Dimension folders and set the following column fields:

         Transaction Dimension: Date
    
     Transaction Dimension: Transaction Type
    ·    Transaction Dimension: Transaction Number
    
     Transaction Dimension: Terms: Name
    
     Transaction Dimension: Amount (Gross)
    
     Payments By Invoice: Date
    
     Payments By Invoice: Payment Method (Transaction): Name
    
     Payments By Invoice: Amount Paid

Note: You have the option to change the column field names by entering the appropriate name in the Column Label field. 
For example: Transaction Dimension: Date, you can fill the Column Label = Invoice Date

3. In the Filters page, you can further filter the report in addition to the Originating Transaction Date.

4. You can go to the Payments by Invoice folder > Payment Method (Transaction) subfolder.

5. Select Name and set - equal to the credit cards (i.e. Visa, Mastercard and others).  See example below:

         Report Component: Payment Method (Transaction)
    
     Field: Name
    
     Value: equal to Visa, Mastercard and others credit cards

6. In the Sorting page, you have the option to sort the report such as:

         Report Component: Payment by Invoice
    
     Field: Date
    
     Decending: Yes

7. Hit Preview or Save.

No comments:

Post a Comment