Payment Period Based On Invoice Date is considering cancelled payment entry as well

[sjain17]

Information about bug

The Payment Period Based On Invoice Date is considering the canceled payment entries as well.

If we cancel any payment entry transaction and do not delete it and try to generate the Payment Period Based On Invoice Date then it shows the canceled payment entries as well.

Steps to reproduce -

• Create one Payment entry with a receivable / payable account.
• Cancel this payment entry (do not delete it)
• Generate Payment Period Based On Invoice Date (it will show the cancelled payment entry as well; however, the debit and credit sum is equal) but it should not show as it is misleading when we see the total payment.

Module

accounts

Version

Currently, I am using the below git repo - Frappe version-13 ERPNext version-13

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

There is no error but the report shows the incorrect data due to cancelled entries are appearing.