Saturday, July 6, 2019

Report to Show Bill Payment with Status

1. Navigate to Reports > Vendors/Payables > A/P Payment History by Payment.

2. Customize the report, it should have the following by default on Edit Columns tab:

        - Bill Type, Date, Number, Amount

3. Add the following:

        - Add Bills By Payment > Entity > Name to the column

        - Add Bills By Payment > Transaction Status > Description.

4. Add a filter on Filters tab.

        - Bills By Payment > Transaction Type = Bill Payment.

5. The report showed the status of voided payments as Voided but the unvoided ones were displayed with Undefined.


Note: The ability to remove the Undefined status is logged as Enhancement 149765. Alternate solution would be to export the report and remove that via Excel.

No comments:

Post a Comment