fix: remove cancelled payment entry from Payment Period Based On Invoice Date

[Nihantra-Patel]

fixes: #30916

Version 15 and 14

Before:

• This will include canceled payment entries, even though the amount debited and credited is the same. However, these canceled entries should not be displayed because they/users can be confused when looking at the total payment. and users can also confused because the status is not shown in the report.

https://github.com/frappe/erpnext/assets/141945075/8d369de5-a5c8-4c1a-aa81-fb113e2a2454

After:

• Remove cancelled payment entries from the report.

https://github.com/frappe/erpnext/assets/141945075/a50cdeb8-60bd-4915-832e-0d6ebfa8f98f

Thank You!